Changes between Version 16 and Version 17 of MySqlReplication

Timestamp:

Nov 7, 2014, 9:51:05 AM (12 years ago)

Author:

Serge CHASTEL

Comment:

--

MySqlReplication

@@ -168 +168 @@
 1 row in set (0.00 sec)
 }}}
+
+= Create a slave from another one =
+*) I assume that we want to create a mysql slave on host slave02 from a (running/functioning) slave named slave01
+
+*) Make sure that slave01 and slave02 both run the exact same version of mysql
+
+*) Stop the replication on slave01
+{{{
+mysql@slave01> STOP SLAVE;
+}}}
+
+*) RSync the contents of /var/lib/mysql on slave01 to /var/lib/mysql.slave01 on slave02
+{{{
+shell> rsync -av root@slave01:/var/lib/mysql /var/lib/mysql.slave01
+}}}
+
+*) Stop the mysql server on slave02 if it is running, backup /etc/mysql/my.cnf on slave02 and copy /etc/mysql/my.cnf from slave01 there
+{{{
+shell> mysqladmin -u root -p shutdown now
+shell> cd /etc/mysql
+shell> mv my.cnf my.cnf.before_rsync
+shell> scp root@slave01:/etc/mysql/my.cnf .
+}}}
+
+*) Edit /etc/mysql/my.cnf on slave02 and change the server-id.
+The server-id value has to be a number, I usually use
 = Enjoy... =
 It might be necessary to tell the slave to ignore some updates: