root@labsdb1011:~# mysql --skip-ssl -e "stop all slaves;" ; mysql --skip-ssl -e "show all slaves status\G" *************************** 1. row *************************** Connection_name: db1095 Slave_SQL_State: Slave_IO_State: Master_Host: db1095.eqiad.wmnet Master_User: repl Master_Port: 3306 Connect_Retry: 60 Master_Log_File: db1095-bin.005975 Read_Master_Log_Pos: 650015259 Relay_Log_File: labsdb1011-relay-bin-db1095.043636 Relay_Log_Pos: 91330161 Relay_Master_Log_File: db1095-bin.005975 Slave_IO_Running: No Slave_SQL_Running: No Replicate_Do_DB: 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: 650015259 Relay_Log_Space: 91330471 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: NULL Master_SSL_Verify_Server_Cert: No Last_IO_Errno: 0 Last_IO_Error: Last_SQL_Errno: 0 Last_SQL_Error: Replicate_Ignore_Server_Ids: Master_Server_Id: 171974784 Master_SSL_Crl: Master_SSL_Crlpath: Using_Gtid: No Gtid_IO_Pos: Replicate_Do_Domain_Ids: Replicate_Ignore_Domain_Ids: Parallel_Mode: conservative Retried_transactions: 0 Max_relay_log_size: 1073741824 Executed_log_entries: 749384 Slave_received_heartbeats: 0 Slave_heartbeat_period: 1800.000 Gtid_Slave_Pos: 0-171966669-4066540871,171966555-171966555-590,171966558-171966558-63,171966669-171966669-2535277494,171966670-171966670-2345400201,171970589-171970589-201132050,171970593-171970593-3479,171970599-171970599-24483,171970637-171970637-1761296687,171970663-171970663-100,171970751-171970751-21842,171974668-171974668-23,171974686-171974686-867,171974769-171974769-52,171974784-171974784-44332768,171974883-171974883-22910812,171974884-171974884-1473084269,171978764-171978764-246,171978765-171978765-33,171978766-171978766-1375989821,171978767-171978767-2173896991,171978771-171978771-30,171978772-171978772-1562,171978775-171978775-2628246368,171978777-171978777-805337706,171978778-171978778-591291768,180359172-180359172-49702202,180359174-180359174-94123432,180359175-180359175-43143522 *************************** 2. row *************************** Connection_name: s2 Slave_SQL_State: Slave_IO_State: Master_Host: db1102.eqiad.wmnet Master_User: repl Master_Port: 3312 Connect_Retry: 60 Master_Log_File: db1102-bin.001165 Read_Master_Log_Pos: 468321269 Relay_Log_File: labsdb1011-relay-bin-s2.013186 Relay_Log_Pos: 47857050 Relay_Master_Log_File: db1102-bin.001165 Slave_IO_Running: No Slave_SQL_Running: No Replicate_Do_DB: 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: 468321269 Relay_Log_Space: 47857356 Until_Condition: None Until_Log_File: Until_Log_Pos: 0 Master_SSL_Allowed: Yes Master_SSL_CA_File: Master_SSL_CA_Path: Master_SSL_Cert: Master_SSL_Cipher: Master_SSL_Key: Seconds_Behind_Master: NULL Master_SSL_Verify_Server_Cert: No Last_IO_Errno: 0 Last_IO_Error: Last_SQL_Errno: 0 Last_SQL_Error: Replicate_Ignore_Server_Ids: Master_Server_Id: 171978764 Master_SSL_Crl: Master_SSL_Crlpath: Using_Gtid: No Gtid_IO_Pos: Replicate_Do_Domain_Ids: Replicate_Ignore_Domain_Ids: Parallel_Mode: conservative Retried_transactions: 0 Max_relay_log_size: 1073741824 Executed_log_entries: 369810 Slave_received_heartbeats: 0 Slave_heartbeat_period: 1800.000 Gtid_Slave_Pos: 0-171966669-4066540871,171966555-171966555-590,171966558-171966558-63,171966669-171966669-2535277494,171966670-171966670-2345400201,171970589-171970589-201132050,171970593-171970593-3479,171970599-171970599-24483,171970637-171970637-1761296687,171970663-171970663-100,171970751-171970751-21842,171974668-171974668-23,171974686-171974686-867,171974769-171974769-52,171974784-171974784-44332768,171974883-171974883-22910812,171974884-171974884-1473084269,171978764-171978764-246,171978765-171978765-33,171978766-171978766-1375989821,171978767-171978767-2173896991,171978771-171978771-30,171978772-171978772-1562,171978775-171978775-2628246368,171978777-171978777-805337706,171978778-171978778-591291768,180359172-180359172-49702202,180359174-180359174-94123432,180359175-180359175-43143522 *************************** 3. row *************************** Connection_name: s4 Slave_SQL_State: Slave_IO_State: Master_Host: db1102.eqiad.wmnet Master_User: repl Master_Port: 3314 Connect_Retry: 60 Master_Log_File: db1102-bin.001340 Read_Master_Log_Pos: 848623023 Relay_Log_File: labsdb1011-relay-bin-s4.012821 Relay_Log_Pos: 51218123 Relay_Master_Log_File: db1102-bin.001340 Slave_IO_Running: No Slave_SQL_Running: No Replicate_Do_DB: 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: 848623023 Relay_Log_Space: 51218429 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: NULL Master_SSL_Verify_Server_Cert: No Last_IO_Errno: 0 Last_IO_Error: Last_SQL_Errno: 0 Last_SQL_Error: Replicate_Ignore_Server_Ids: Master_Server_Id: 171978764 Master_SSL_Crl: Master_SSL_Crlpath: Using_Gtid: No Gtid_IO_Pos: Replicate_Do_Domain_Ids: Replicate_Ignore_Domain_Ids: Parallel_Mode: conservative Retried_transactions: 0 Max_relay_log_size: 1073741824 Executed_log_entries: 548653 Slave_received_heartbeats: 0 Slave_heartbeat_period: 1800.000 Gtid_Slave_Pos: 0-171966669-4066540871,171966555-171966555-590,171966558-171966558-63,171966669-171966669-2535277494,171966670-171966670-2345400201,171970589-171970589-201132050,171970593-171970593-3479,171970599-171970599-24483,171970637-171970637-1761296687,171970663-171970663-100,171970751-171970751-21842,171974668-171974668-23,171974686-171974686-867,171974769-171974769-52,171974784-171974784-44332768,171974883-171974883-22910812,171974884-171974884-1473084269,171978764-171978764-246,171978765-171978765-33,171978766-171978766-1375989821,171978767-171978767-2173896991,171978771-171978771-30,171978772-171978772-1562,171978775-171978775-2628246368,171978777-171978777-805337706,171978778-171978778-591291768,180359172-180359172-49702202,180359174-180359174-94123432,180359175-180359175-43143522 *************************** 4. row *************************** Connection_name: s6 Slave_SQL_State: Slave_IO_State: Master_Host: db1102.eqiad.wmnet Master_User: repl Master_Port: 3316 Connect_Retry: 60 Master_Log_File: db1102-bin.000736 Read_Master_Log_Pos: 206488347 Relay_Log_File: labsdb1011-relay-bin-s6.008347 Relay_Log_Pos: 24620690 Relay_Master_Log_File: db1102-bin.000736 Slave_IO_Running: No Slave_SQL_Running: No Replicate_Do_DB: 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: 206488347 Relay_Log_Space: 24620996 Until_Condition: None Until_Log_File: Until_Log_Pos: 0 Master_SSL_Allowed: Yes Master_SSL_CA_File: Master_SSL_CA_Path: Master_SSL_Cert: Master_SSL_Cipher: Master_SSL_Key: Seconds_Behind_Master: NULL Master_SSL_Verify_Server_Cert: No Last_IO_Errno: 0 Last_IO_Error: Last_SQL_Errno: 0 Last_SQL_Error: Replicate_Ignore_Server_Ids: Master_Server_Id: 171978764 Master_SSL_Crl: Master_SSL_Crlpath: Using_Gtid: No Gtid_IO_Pos: Replicate_Do_Domain_Ids: Replicate_Ignore_Domain_Ids: Parallel_Mode: conservative Retried_transactions: 0 Max_relay_log_size: 1073741824 Executed_log_entries: 330412 Slave_received_heartbeats: 0 Slave_heartbeat_period: 1800.000 Gtid_Slave_Pos: 0-171966669-4066540871,171966555-171966555-590,171966558-171966558-63,171966669-171966669-2535277494,171966670-171966670-2345400201,171970589-171970589-201132050,171970593-171970593-3479,171970599-171970599-24483,171970637-171970637-1761296687,171970663-171970663-100,171970751-171970751-21842,171974668-171974668-23,171974686-171974686-867,171974769-171974769-52,171974784-171974784-44332768,171974883-171974883-22910812,171974884-171974884-1473084269,171978764-171978764-246,171978765-171978765-33,171978766-171978766-1375989821,171978767-171978767-2173896991,171978771-171978771-30,171978772-171978772-1562,171978775-171978775-2628246368,171978777-171978777-805337706,171978778-171978778-591291768,180359172-180359172-49702202,180359174-180359174-94123432,180359175-180359175-43143522 *************************** 5. row *************************** Connection_name: s7 Slave_SQL_State: Slave_IO_State: Master_Host: db1102.eqiad.wmnet Master_User: repl Master_Port: 3317 Connect_Retry: 60 Master_Log_File: db1102-bin.001018 Read_Master_Log_Pos: 638563469 Relay_Log_File: labsdb1011-relay-bin-s7.011040 Relay_Log_Pos: 35645405 Relay_Master_Log_File: db1102-bin.001018 Slave_IO_Running: No Slave_SQL_Running: No Replicate_Do_DB: 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: 638563469 Relay_Log_Space: 35645711 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: NULL Master_SSL_Verify_Server_Cert: No Last_IO_Errno: 0 Last_IO_Error: Last_SQL_Errno: 0 Last_SQL_Error: Replicate_Ignore_Server_Ids: Master_Server_Id: 171978764 Master_SSL_Crl: Master_SSL_Crlpath: Using_Gtid: No Gtid_IO_Pos: Replicate_Do_Domain_Ids: Replicate_Ignore_Domain_Ids: Parallel_Mode: conservative Retried_transactions: 0 Max_relay_log_size: 1073741824 Executed_log_entries: 337077 Slave_received_heartbeats: 0 Slave_heartbeat_period: 1800.000 Gtid_Slave_Pos: 0-171966669-4066540871,171966555-171966555-590,171966558-171966558-63,171966669-171966669-2535277494,171966670-171966670-2345400201,171970589-171970589-201132050,171970593-171970593-3479,171970599-171970599-24483,171970637-171970637-1761296687,171970663-171970663-100,171970751-171970751-21842,171974668-171974668-23,171974686-171974686-867,171974769-171974769-52,171974784-171974784-44332768,171974883-171974883-22910812,171974884-171974884-1473084269,171978764-171978764-246,171978765-171978765-33,171978766-171978766-1375989821,171978767-171978767-2173896991,171978771-171978771-30,171978772-171978772-1562,171978775-171978775-2628246368,171978777-171978777-805337706,171978778-171978778-591291768,180359172-180359172-49702202,180359174-180359174-94123432,180359175-180359175-43143522