Active Geo-Replication (like SQL Database)
For enterprise companies, business continuity and disaster recovery are one of the most important features. We cannot stop our services even when the region failure happens.
Cross-region read replicas are now available in public preview. You can create up to five read-only replicas in any region supported by the MySQL service.
To get started, please use the Azure portal to select the location for your read replica: https://docs.microsoft.com/en-us/azure/mysql/howto-read-replicas-portal#create-a-read-replica
Andrea Lam on behalf of the Azure DB for MySQL team
@Andrea Lam, Yes Read Replicas are available. However in an event of disaster I have to change my code to point to the replica. This should be seamless. Something like a proxy in front and once a disaster happens proxy should route to the secondary, by this approach we don't have to change our code line. This feature is highly needed for mysql would suggest pg team to look after this.
Roger Maddron Jr commented
So... where is this? It's becoming hard to recommend people use MySQL on Azure as a result of this.
Victor J Crawl commented
Is there a new status or projected time frame for implementing active geo-replication?
Any updates on this. We are having Business continuity conversation with Enterprise customer on Azure MySQL and this feature can really help us sell this product better.
Any updates would be appreciated.
Andrew Rigg commented
Good Morning, any update on this? - MySQL support for geo-replication Active Active
Ben Walters commented
Any update on this? I am also looking for such a feature.
OGDEN, SCOTT commented
Is there any update on this? Originally it was stated to be ready 'H2 2018'. We are into 2019 and no updates.
Is there any update on when Active Geo-Replication for Azure Database for MySQL will be available?
Does Azure DB for MySQL now support geo-replication and its multiple read-only secondary like Read Replica in AWS? It's been obviously way more than a few months by now.
Tao Wu commented
Understood. Geo-Replication is definitely is definitely a very important feature. It is in development, and will be available before GA.