1

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?

Linger
  • 249
Mahendra Liya
  • 349

1 Answers1

2

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.

Mike Scott
  • 8,228