Home / server / Questions / 372291
Accepted
Mahendra Liya
Asked: 2012-03-22 22:29:03 +0800 CST

MySQL master-master replication between database running on 3 different server

  • 772

I am trying to implement a master-master replication between 3 MySQL Databases running on 3 different servers.

I implemented master-master replication for 2 servers, but can't figure out how can I implement if for 3 different MySQL Servers.

Does anyone know how to accomplish this?

mysql database mysql-replication master-master

1 Answers

  1. Best Answer

    You have to set it up as a ring -- A is the master for B, B is the master for C, and C is the master for A. And don't forget to set the log_slave_updates option so that they will pass on upstream changes, and set replicate-same-server-id to 0 so that the updates won't go round and round the ring for ever.

    Read this article -- the ring configuration is described on page 2.

    • 2