> -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 the
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
-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 c
For each master you will have in your dual master setup you will need to
modify the my.cnf file accordingly.
master-host=
master-user=
master-password=
master-port=
server-id=
log-slave-updates
log-bin
-Original Message-
From: Free Grafton - CCB
To: [EMAIL PROTECTED]
Sent: 5/24/04 2:28 PM
