Does MySQL supports Synchronous Replication.

amit_27 · November 23, 2009, 6:49am

Hi All,

Does MySQL supports Synchronous Replication? If it is then From which version it is supported and how?

Any help on this highly appreciated.

Thanks.

Neo · November 23, 2009, 4:10pm

You can find your answers at the MySQL web site. For MySQL 5.4:

amit_27 · November 24, 2009, 10:53pm

Thanks for the prompt reply.

Let me know if We can make a setup like using MySQL.

We have master - A and slave - B setup.

Case 1:

If master(A) goes down then slave (B) becomes a master. So changes on slave(B - which is now master) needs to replicate to master (A) when master (A) up.

Case 2.

If master(A) down and then up then it again will become a master and B becomes slave.

Does MySQL supports this kind of mechanism?

Amit

amit_27 · November 30, 2009, 2:17am

Hi Neo,

Does "Switching Masters During Failover" supports for prior to version 4.1?

I found this point in 5.0 onward manual and not in "MySQL 3.23/4.0/4.1" manual.

Can you please tell me it is supported in prior to 4.1 versions?

Regards,
Amit