Changes between Version 15 and Version 16 of MySqlReplication

Timestamp:

Nov 7, 2014, 9:41:26 AM (12 years ago)

Author:

Serge CHASTEL

Comment:

--

MySqlReplication

@@ -113 +113 @@
 }}}
 
+= Start/Stop the slave =
+
+To start the slave:
+{{{
+mysql prompt> START SLAVE;
+}}}
+
+To stop it:
+{{{
+mysql prompt> STOP SLAVE;
+}}}
+
+To check it status:
+{{{
+mysql prompt> SHOW SLAVE STATUS\G
+}}}
+The displayed message looks like:
+{{{
+mysql> SHOW SLAVE STATUS\G
+*************************** 1. row ***************************
+             Slave_IO_State: Waiting for master to send event
+                Master_Host: ippdb01
+                Master_User: ipp
+                Master_Port: 3306
+              Connect_Retry: 60
+            Master_Log_File: mysqld-bin.032506
+        Read_Master_Log_Pos: 13793409
+             Relay_Log_File: mysqld-relay-bin.002900
+              Relay_Log_Pos: 13793547
+      Relay_Master_Log_File: mysqld-bin.032506
+           Slave_IO_Running: Yes
+          Slave_SQL_Running: Yes
+            Replicate_Do_DB: czardb,gpc1,ippadmin,ipptopsps,megacam,ssp,uip
+        Replicate_Ignore_DB: 
+         Replicate_Do_Table: 
+     Replicate_Ignore_Table: 
+    Replicate_Wild_Do_Table: 
+Replicate_Wild_Ignore_Table: 
+                 Last_Errno: 0
+                 Last_Error: 
+               Skip_Counter: 0
+        Exec_Master_Log_Pos: 13793409
+            Relay_Log_Space: 13793547
+            Until_Condition: None
+             Until_Log_File: 
+              Until_Log_Pos: 0
+         Master_SSL_Allowed: No
+         Master_SSL_CA_File: 
+         Master_SSL_CA_Path: 
+            Master_SSL_Cert: 
+          Master_SSL_Cipher: 
+             Master_SSL_Key: 
+      Seconds_Behind_Master: 0
+1 row in set (0.00 sec)
+}}}
 = Enjoy... =
 It might be necessary to tell the slave to ignore some updates: