1

I'm deploying a Sitecore website using Azure and Azure SQL, and one of the requirements is to have some of the databases in different Azure Regions but sharing the same data among the other databases.

For example: 1. Web database will be in East US and West US 2. Sitecore website also in East US and West US 3. Website from East US will point to East database, and Website from West US will point to West database 4. Databases must be in sync (some lag is acceptable)

I had a look into Azure SQL Data Sync but looks like it is in preview mode, and I was wondering if Azure SQL has another feature to address. Despite the fact Azure SQL will be in place, I'd also wondering if on-premises SQL have anything similar?

3

Based on your scenario Data Sync is the best fit. It's the only Azure PaaS solution for Data Synchronizaion.

Transactional replication is supported for on-premise to Azure. If sync in this direction is enough for you, you can use replication. See Transactional Replication to Azure SQL DB now in public preview

2

If your require a true multi-master, i.e. both writes and reads must be local and you are OK with a synchronization lag, then use DataSync. It is also the only way to sync partial data between different Azure SQL databases (e.g. a shared table). If you need to replicate the entire database between several regions and are ok with writes having higher latency, then you can consider using geo-replication. It will give you a very low replication lag (<5 sec) but it is a single master solution. In that sense, it optimizes for the read-only proximity and perf.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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