Changes between Version 17 and Version 18 of MySqlReplication

Timestamp:

Nov 7, 2014, 10:01:56 AM (12 years ago)

Author:

Serge CHASTEL

Comment:

--

MySqlReplication

@@ -174 +174 @@
 *) Make sure that slave01 and slave02 both run the exact same version of mysql
 
-*) Stop the replication on slave01
-{{{
-mysql@slave01> STOP SLAVE;
+*) Stop the mysql server on slave01
+{{{
+shell@slave01> mysqladmin -u root -p shutdown now
 }}}
 
 *) 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
+shell@slave02> 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 .
+shell@slave02> mysqladmin -u root -p shutdown now
+shell@slave02> cd /etc/mysql
+shell@slave02> mv my.cnf my.cnf.before_rsync
+shell@slave02> 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
+The server-id value has to be a number, I usually use YYYYMMDD<RUNNING NUMBER>, e.g. for the 5th slave install on 2025 Nov 6th (busy day), I would use:
+{{{
+server-id = 2025110605
+}}}
+
+*) If you want to be super-safe (and if you have space), make a copy of the rsync on slave02
+{{{
+shell> cp -a /var/lib/mysql.slave01 /var/lib/mysql.slave01.sos
+}}}
+
+*) Make mysql.slave01 the new mysql data directory
+{{{
+shell@slave02> mv /var/lib/mysql /var/lib/mysql.before_rsync.delete_me_when_working
+shell@slave02> mv /var/lib/mysql.slave01 /var/lib/mysql
+}}}
+
+*) Start the mysql server on slave02
+{{{
+shell@slave02> /etc/init.d/mysql zap
+shell@slave02> /etc/init.d/mysql start
+}}}
+
 = Enjoy... =
 It might be necessary to tell the slave to ignore some updates: