Current Sitecore environment running 3 sites with multi-site set up approach. This is Sitecore 9.3 XP set up on Azure IaaS.
Current XP set up: 1 CM, 2 CD, 1 SQL Cluster for Sitecore DBs, 1 xDB SQL Cluster for xDB, 3 SolR Servers
SQL Cluster(A) contains CM, CD DBs: core, security, master, web, experienceforms , exm
xDB SQL Cluster(B) contains xDBs: messaging, referencedata, reporting, reporting_secondary
Now we need to add new main site and for that we're going to add 2 CDs from where new site will run and backend will be new SQL Cluster(C) which will be copy of SQL Cluster(A). We'll set up replication to keep SQL Cluster(A) and SQL Cluster(C) database in sync. We'll set up new publishing target which will move new main site related content to new SQL Cluster(C). Deployment package( code ) will be same on CM and CD servers. Request to new CDs for main site will be handled via Azure App Gateway. The reason we came up with 2 CD + SQL Cluster(C) is because during DR scenario , we'll bring these servers(
2 new CDs and new SQL Cluster(C)) first since this is main site.
Can we go with addition of new CD and SQL cluster for new main site or there will be some challenges? Does this set up support A/B Testing, Content Testing, Personalization etc.