Read-scale and cross-region database replication
I am a Principal Program Manager in Azure SQL Database. I want to provide better support for the following scenario.
I have a web application that is currently deployed in Europe. We expect the business to grow so we will need to expand to other regions. I am using SQL Azure for my DB. The data is relatively small (<10GB) so I don’t want to deal with data partitioning. Also having a single data image will help me with the analytics. I would like to replicate the data to all regions and setup smart routing so that the web front in the region is automatically routed to the local data to minimize access latency. Eventually I would like to go multi-master but initially single master would be OK so long as the writes are automatically routed to the master. My ultimate goal is to enable the app to expand easily without any major design/schema changes.
If you have a similar scenario and could share your specific requirements I would like to hear from you.
Thanks for your feedback here.
This would be an awesome feature for our company. Are there any plans around this that you can share Alexander/Guy?