Hey Folks,
I wonder if anyone who knows about mysql replication
can answer some questions.
We are thinking of setting up a replicated mysql
layout with the following:
two master servers
four slave servers
1) does having two master servers make sense?
It seems like slaves will only talk to one master
server. So if the master fails there is no automatic
way to have them fail over to a secondard master.
Is that true?
2) Can two masters be set up to be both masters and
slaves of each other? What is put in the /etc/my.cnf
file for them?
3) Would it make more sense to have the second "master"
actually be a slave. And if the master "master" dies,
have it take over the IP so the slaves will not notice
the difference? This is assuming that the IP could be
taken over.
4) Any other thoughts or ideas on this kind of setup?
5) What might be a better set up?
Ken Jones
