i'm doing something research on master-master(standby) replication. so
far we use manually method to exchange the standby master as master
when occur some problems.

Do you have any idea to exchange roles automatically when occur
problems?

sissi <sissiyam (AT) gmail (DOT) com> wrote:
I suggest you stay with that.

Heartbeat/Pacemaker comes to mind.

However: MySQL replication is asynchronous - so you have no guarantee
that your slave is up to date. Switching roles without additional
checks is probably a bad idea.


XL