The Ultimate Guide to High Availability with MariaDB
This is a read-only copy of the MariaDB Knowledgebase generated on 2024-11-16. For the latest, interactive version please visit https://mariadb.com/kb/.

Bidirectional replication

I have a user that requires a bidirectional sync as below:

Primary system is a windows server. I need to replicate the database for their application in real-time to a backup hosted system (CentOS 6) so all records are available in case the primary system is unavailable.

Once users start using the backup hosted system, I would need any changes made on the backup (new records insterted) to automatically be pushed back to the primary (master) server so there is no loss of any new records and the users can revert back to using the primary system with no data loss. I don't need failover of the application itself as they will manually switch between the apps on the 2 systems, just need the db istelf replicated both ways. What's the best way to achieve this? TIA to all.

Kevin

Answer Answered by Gabriel Preda in this comment.

There are 2 things that come to my mind immediately:

- Master-Master replication (also called Circular replication - that is B replicates from A, and A replicates from B.

- MariaDB Galera Cluster - but for now it is not available on Windows and you might need a 3rd node

I would go for Master-Master replication.

Content reproduced on this site is the property of its respective owners, and this content is not reviewed in advance by MariaDB. The views, information and opinions expressed by this content do not necessarily represent those of MariaDB or any other party.