We have 4 MySQL servers and our main motto is that data should replicate across all the 4 servers if one is getting updated and the same changes has to go to all other 3 servers.

And below are the few other requirements

1. Changes need to be on all 4 servers.

2. one should be active at anytime which should be on Read/Write and rest of 3 to be on read-only mode.

3. If switch/Failover happens the new master should only be read/write and other servers has to be on read only

We want to achieve the above explained funtionality through the Circular replication mechanisum? Is it possible?

If not possible then what would be the recommended HA setup solution to meet above said requirement.

Appriciate any help or suggessions on this.

Thnks, Ram

We have 4 MySQL servers and our main motto is that data should replicate across all the 4 servers if one is getting updated and the same changes has to go to all other 3 servers.

And below are the few other requirements

1. Changes need to be on all 4 servers.

2. one should be active at anytime which should be on Read/Write and rest of 3 to be on read-only mode.

3. If switch/Failover happens the new master should only be read/write and other servers has to be on read only

We want to achieve the above explained funtionality through the Circular replication mechanisum? Is it possible?

If not possible then what would be the recommended HA setup solution to meet above said requirement.

Appriciate any help or suggessions on this.