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]

Reply via email to