MySQL replication be bi-directional

Question

We have successfully set up a Master-Slave replication as described in MySQL literature.

However, I'm curious if anyone has set up a bidirectional replication. For example, if one has a Drupal or Wordpress installation. The first ('master') database server goes down, and the secondary ('slave') picks up. All the while, users continue to make edits, writing new data. When the First database server is restarted, can changes written to the Second be replicated upward to the First?

That is: are there other replication strategies than only the Master-Slave?

Answer 1

You can do Master-Master replication. Unfortunately, Neither Drupal or Wordpress support this. The best thing to do is Master-Slave or Master-Slave-Slave, then make the first slave in the chain the new Master if the original master goes down. Then reconfigure the old Master to slave off the new Master (or last slave in the chain).

How often does your mysql server go down?

Answer 2

Master-Master Replication has some disadvantages. For example data inconsistencies can easily occur.

Have you tried synchronous multi-Master Replication with Galera Cluster for MySQL?

http://codership.com/