List:General Discussion« Previous MessageNext Message »
From:Luc Foisy Date:December 15 2003 4:03pm
Subject:FW: Replication
View as plain text  
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)
Thread
FW: ReplicationLuc Foisy15 Dec