2 way replication, also referred to as dual master replication, has been
available for quite some time. However implementation can be tricky. Look
for the "Dual master" section in chapter 7 of the High Performance MySQL
If you need more than 2 masters, then all bets are off..
On Mon, 12 Feb 2007, Rilawich Ango wrote:
> Hi all,
> I know it is an old question and I have read from the mysql website
> about the topic. Until now, mysql still doesn't support 2 ways
> replication, quoted from mysql website. As I have multiple location
> and each location will have a DB. Most of all need to read and write
> to the database.
> In my case, 2 ways replication is the most direct way to do it. Any
> other solution is suitable for me to implement if 2 ways replication
> is not a good way? Anyone has successfully implement 2 ways
> replication? Any suggestion?
> 1PC-read/update-DB(a) <--- 2 ways replication --> DB(b)-read/update-PC2