Azure mysql master and master replication

Question

Can we kindly build master and master replication using Azure database for mysql ?

Answer 1

Hi @sakuraime

You can configure Azure Db Data in Replication for SQL inclusive master.

https://learn.microsoft.com/en-us/azure/mysql/howto-data-in-replication
https://learn.microsoft.com/en-us/azure/mysql/concepts-data-in-replication

Database Read Replica(s) helps in decreasing load on the primary DB by serving read-only traffic. Read replicas allow you to elastically scale out beyond the capacity constraints of a single DB instance for read-heavy database workloads. Cross-region replication can be helpful for scenarios like disaster recovery planning or bringing data closer to your end users

Ref: Read : https://learn.microsoft.com/en-us/azure/mysql/concepts-read-replicas#:~:text=The%20read%20replica%20feature%20allows,file%20position%2Dbased%20replication%20technology.

(Please don’t forget to "Accept the answer" and “up-vote” wherever the information provided helps you, this can be beneficial to other community members. Thank You)

Regards,
J.D.

Disclaimer: This posting is provided "AS IS" with no warranties or guarantees, and confers no rights.

Answer 2

Multi master replication is not supported with azure database for MySQL. But for scenarios in which your application needs to write to multiple databases while maintaining the same data set across all databases, you might want to replicate data between two MySQL servers. This is generally referred to as “bidirectional”, or “master-master”, replication. With Azure Database for MySQL – Flexible Server, you can use GTID-based replication to enable bidirectional replication. However, data consistency should be handled on the application side to address data conflicts.

For more details https://techcommunity.microsoft.com/t5/azure-database-for-mysql-blog/bidirectional-replication-with-azure-database-for-mysql-flexible/ba-p/3052250