I tried the below. asked show master status on SERVER2 and I see the two db's I asked
to replicate on that server but no indication that the logging is happening from the
replication of DB1 from SERVER1
( I missed below showing replicate-do-db=DB1 in the SERVER2 my.cnf, and the
binlog-do-db's in SERVER3 should read replicate-do-db)
Will set up the replication on SERVER3 in a bit to see if I am getting anything from
that log-slave-updates
-----Original Message-----
From: Luc Foisy
Sent: Monday, December 15, 2003 11:03 AM
To: MYSQL-List (E-mail)
Subject: FW: Replication
I sent this out friday, but didn't see it come through to the list, so sorry if it
comes up twice if the original is lost in lala land at the moment.
-----Original Message-----
From: Luc Foisy
Sent: Friday, December 12, 2003 4:17 PM
To: MYSQL-List (E-mail)
Subject: Replication
The scenario we wish to accomplish
SERVER1 - Logging DB1
SERVER2 - Logging DB2
Logging DB3
Replicating DB1 from SERVER1 - Logging DB1
SERVER3 - Replicating DB1 from SERVER2
Replicating DB2 from SERVER2
Replicating DB3 from SERVER2
What I am asking is for confirmation that the following my.cnf files would do that.
SERVER1
[mysqld]
log-bin
binlog-do-db=DB1
server-id=1
SERVER2
[mysqld]
log-bin
master-host=SERVER1
master-user=SERVER2
master-password=<password>
binlog-do-db=DB2
binlog-do-db=DB3
log-slave-updates
server-id=2
SERVER3
[mysqld]
master-host=SERVER2
master-user=SERVER3
master-password=<password>
binlog-do-db=DB1
binlog-do-db=DB2
binlog-do-db=DB3
server-id=3
To do the initial setup of the slaves I would do the following?
Dump DB1 from SERVER1
Start logging of DB1 on SERVER1
Load Dump of DB1 onto SERVER2
Start replication of DB1 on SERVER2 (add replication parameters to my.cnf and restart)
Dump DB2 from SERVER2
Dump DB3 from SERVER2
Load Dump of DB1 onto SERVER3
Load Dump of DB2 onto SERVER3
Load Dump of DB3 onto SERVER3
Start replication of DB1 on SERVER3 (add replication parameters to my.cnf and restart)
--
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]
