RE: Dual Master Configuration
For each master you will have in your dual master setup you will need to modify the my.cnf file accordingly. master-host=ip-address-other-master master-user=replication-user master-password=replication-password master-port=listening-port server-id=unique-server-id log-slave-updates log-bin -Original Message- From: Free Grafton - CCB To: [EMAIL PROTECTED] Sent: 5/24/04 2:28 PM 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]
Re: Dual Master Configuration
-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]
RE: Dual Master Configuration
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]
RE: Dual Master Configuration
-Original Message- From: Free Grafton - CCB [mailto:[EMAIL PROTECTED] Sent: Monday, May 24, 2004 11:29 AM To: [EMAIL PROTECTED] Subject: Dual Master Configuration Can someone show me how a configuration file (my.cnf) would look to have dual MySQL masters. Its more then just my.cnf changes-your application needs logic as well to handle dual masters. A---B Use log-slave-updates, logbin, serverid. A replicates from B and B replicates from A, they need to have distinct serverids to avoid cycles. -- 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]