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
-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
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
-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