Hi Your cnf file just needs to have log-bin and unique server-id's. Then use the CHANGE MASTER TO commands on each. So each will be a slave to the other.
That's a brief summary. Good luck. Gabe -----Original Message----- From: Free Grafton - CCB [mailto:[EMAIL PROTECTED] Sent: Monday, May 24, 2004 3:29 PM To: [EMAIL PROTECTED] Subject: Dual Master Configuration 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 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
