Have Active-Active Azure Sql Server Database replication

Question

I want to have a real-time sync-up for disaster recovery in between both active read-write databases for low latency to the customers from different locations.

Can anyone help me with this? How I can able to achieve it?

Answer 1

You can have multiple options related with it:

SQL Server consists of Peer-to-peer Transactional Replication but for that you need to make sure that changes are not introduced into multiple nodes.

Also, It has Merge Replication option as well.

And, Azure Cosmos DB supports Multi-Master. It helps you with cost/complexity.

I hope this will help.

Want to become an Azure expert? join azure certification now!!