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.

  • Hi Mark, Is it the same codebase for all sites? - if no, can you explain more how do you manage your releases and deployment? Oct 19, 2021 at 10:12
  • @HanyShehata Yes code base is same for all 3 live sites which is on helix pattern and single deployment package is being moved to CM & CD currently. For new main site we're planning to maintain separate repo/code.
    – Sukhjeevan
    Oct 19, 2021 at 13:09
  • @Mark, If the new main site has brand new code, may I ask for which reasons are you planning to mirror SQL Cluster? - as per my understanding the new code will be deployed on CDs only, but will be shared with other sites on CM and databases .. please confirm if my understanding is correct Oct 20, 2021 at 14:17
  • @HanyShehata New SQL Cluster(C) will be having all databases as mentioned in question but as we know core DB is common in CM/CD XP set up , that's why we're going to set up replication for specially core DB between SQL Cluster(C) and SQL Cluster(D). New code will be deployed on both CM and new 2 CDs. 2 new CDs will have connections to only SQL Cluster(C). Content Author team want to review pages on cms site( cms.mycompany.com ) before publishing.
    – Sukhjeevan
    Oct 21, 2021 at 2:42

1 Answer 1


@Sukhjeevan, There're many assumptions here. although, answering your question directly, I can't see a problem with your suggested setup; however, I can suggest some changes that might simplify and save some money ;)

The suggested changes:

What did you get from these changes? what are the benefits?

  • Your websites are up and running without any dependency on XP or CM work
  • In case of issues on CM or XP, you will be losing only analytical data
  • Simplify SQL cluster setup
  • Straight-forward deployment
  • Simplify your release management/cycle
  • Less operation/maintenance headache

Hope I could help you here .. best of luck.

  • Yes this approach is just adding a new site in current live XP 9.3 environment without any addition in Infra side but how about during DR in this approach? Bringing main site back during DR is also our top most priority, other sites can wait. That's why we're planning to add 2 CD and new SQL Cluster(C) so that we can bring main site back first.
    – Sukhjeevan
    Oct 25, 2021 at 14:52
  • You just need introduce content freeze period while running DR test; This will allow you to move DBs in secure way from content point of view Nov 3, 2021 at 14:38

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.