-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 On Monday 24 May 2004 02:28 pm, Free Grafton - CCB wrote: > Can someone show me how a configuration file (my.cnf) would look to > have dual MySQL masters. I know it can be done, as I have read about > others using it. I simply can't figure out how to configure it myself. > There is nothing on the MySQL site about having a server be a master > and a slave to another master and I have been through about 2 hours of > Google searches with nothing yet helpful. > I don't need a lecture on the dangers of running dual masters. 99.4% of > the data transfer on our servers are for read requests. Not too worried > about data being written at the same time to different masters and > getting out of sync. Thanks for your help. > Free Grafton
Just give the two servers different id's numbers as usual. Just find the article in the manual about creating a master slave combo.. If memory serves, you just do that twice.. obviosly just doing the opposite to the servers each time.. so A-B the first time.. b-a the second time.. I believe its that simple - -- When the fun and games are over, the serious foolishness starts. -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.2.4 (GNU/Linux) iD8DBQFAslU9ld4MRA3gEwYRAv+8AJwOtWZ0MGPCV9f+sa7JjTakxIsFYACeI6CB v8G9UJoVNMq+5j2Ix02JmgE= =OcVG -----END PGP SIGNATURE----- -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]