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]
