*************************** 1. row *************************** Connection_name: abc Slave_SQL_State: Slave has read all relay log; waiting for the slave I/O thread to update it Slave_IO_State: Waiting for master to send event Master_Host: 123.123.123.123 Master_User: abcdefg Master_Port: 3306 Connect_Retry: 60 Master_Log_File: mysql-bin-changelog.030453 Read_Master_Log_Pos: 475420 Relay_Log_File: mysqld-relay-bin-au.018704 Relay_Log_Pos: 475721 Relay_Master_Log_File: mysql-bin-changelog.030453 Slave_IO_Running: Yes Slave_SQL_Running: Yes Replicate_Do_DB: Replicate_Ignore_DB: Replicate_Do_Table: Replicate_Ignore_Table: Replicate_Wild_Do_Table: Replicate_Wild_Ignore_Table: mysql.%,dumps.%,some_stuff.%,test.%,tmp.% Last_Errno: 0 Last_Error: Skip_Counter: 0 Exec_Master_Log_Pos: 475420 Relay_Log_Space: 476083 Until_Condition: None Until_Log_File: Until_Log_Pos: 0 Master_SSL_Allowed: No Master_SSL_CA_File: /run/keys/defghi-ca.crt Master_SSL_CA_Path: Master_SSL_Cert: /run/keys/defghi-repl.crt Master_SSL_Cipher: Master_SSL_Key: /run/keys/defghi-repl.key Seconds_Behind_Master: 0 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: 2123496094 Master_SSL_Crl: /run/keys/defghi-ca.crt Master_SSL_Crlpath: Using_Gtid: No Gtid_IO_Pos: Retried_transactions: 0 Max_relay_log_size: 1073741824 Executed_log_entries: 6085129 Slave_received_heartbeats: 0 Slave_heartbeat_period: 1800.000 Gtid_Slave_Pos: 0-1-704091057 *************************** 2. row *************************** Connection_name: bcd Slave_SQL_State: Slave has read all relay log; waiting for the slave I/O thread to update it Slave_IO_State: Waiting for master to send event Master_Host: 124.124.124.124 Master_User: abcdefg Master_Port: 3306 Connect_Retry: 60 Master_Log_File: mysql-bin.019783 Read_Master_Log_Pos: 2578720 Relay_Log_File: mysqld-relay-bin-db02.000332 Relay_Log_Pos: 2579007 Relay_Master_Log_File: mysql-bin.019783 Slave_IO_Running: Yes Slave_SQL_Running: Yes Replicate_Do_DB: Replicate_Ignore_DB: Replicate_Do_Table: Replicate_Ignore_Table: Replicate_Wild_Do_Table: Replicate_Wild_Ignore_Table: mysql.%,dumps.%,some_stuff.%,test.%,tmp.% Last_Errno: 0 Last_Error: Skip_Counter: 0 Exec_Master_Log_Pos: 2578720 Relay_Log_Space: 2579353 Until_Condition: None Until_Log_File: Until_Log_Pos: 0 Master_SSL_Allowed: Yes Master_SSL_CA_File: /run/keys/defghi-ca.crt Master_SSL_CA_Path: Master_SSL_Cert: /run/keys/defghi-repl.crt Master_SSL_Cipher: Master_SSL_Key: /run/keys/defghi-repl.key Seconds_Behind_Master: 0 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: 2 Master_SSL_Crl: /run/keys/defghi-ca.crt Master_SSL_Crlpath: Using_Gtid: No Gtid_IO_Pos: Retried_transactions: 0 Max_relay_log_size: 1073741824 Executed_log_entries: 4343834 Slave_received_heartbeats: 0 Slave_heartbeat_period: 1800.000 Gtid_Slave_Pos: 0-1-704091057 *************************** 3. row *************************** Connection_name: cde Slave_SQL_State: Slave has read all relay log; waiting for the slave I/O thread to update it Slave_IO_State: Waiting for master to send event Master_Host: 125.125.125.125 Master_User: abcdefg Master_Port: 3306 Connect_Retry: 60 Master_Log_File: mysql-bin.008007 Read_Master_Log_Pos: 34060211 Relay_Log_File: mysqld-relay-bin-db04.004044 Relay_Log_Pos: 34060498 Relay_Master_Log_File: mysql-bin.008007 Slave_IO_Running: Yes Slave_SQL_Running: Yes Replicate_Do_DB: Replicate_Ignore_DB: Replicate_Do_Table: Replicate_Ignore_Table: Replicate_Wild_Do_Table: Replicate_Wild_Ignore_Table: mysql.%,dumps.%,some_stuff.%,test.%,tmp.% Last_Errno: 0 Last_Error: Skip_Counter: 0 Exec_Master_Log_Pos: 34060211 Relay_Log_Space: 34060844 Until_Condition: None Until_Log_File: Until_Log_Pos: 0 Master_SSL_Allowed: Yes Master_SSL_CA_File: /run/keys/defghi-ca.crt Master_SSL_CA_Path: Master_SSL_Cert: /run/keys/defghi-repl.crt Master_SSL_Cipher: Master_SSL_Key: /run/keys/defghi-repl.key Seconds_Behind_Master: 0 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: 4 Master_SSL_Crl: /run/keys/defghi-ca.crt Master_SSL_Crlpath: Using_Gtid: No Gtid_IO_Pos: Retried_transactions: 0 Max_relay_log_size: 1073741824 Executed_log_entries: 20621017 Slave_received_heartbeats: 0 Slave_heartbeat_period: 1800.000 Gtid_Slave_Pos: 0-1-704091057 *************************** 4. row *************************** Connection_name: efg Slave_SQL_State: Slave has read all relay log; waiting for the slave I/O thread to update it Slave_IO_State: Waiting for master to send event Master_Host: 126.126.126.126 Master_User: abcdefg Master_Port: 3306 Connect_Retry: 60 Master_Log_File: mysql-bin.005779 Read_Master_Log_Pos: 81395823 Relay_Log_File: mysqld-relay-bin-my.000172 Relay_Log_Pos: 81396110 Relay_Master_Log_File: mysql-bin.005779 Slave_IO_Running: Yes Slave_SQL_Running: Yes Replicate_Do_DB: Replicate_Ignore_DB: Replicate_Do_Table: Replicate_Ignore_Table: Replicate_Wild_Do_Table: Replicate_Wild_Ignore_Table: mysql.%,dumps.%,some_stuff.%,test.%,tmp.% Last_Errno: 0 Last_Error: Skip_Counter: 0 Exec_Master_Log_Pos: 81395823 Relay_Log_Space: 81395772 Until_Condition: None Until_Log_File: Until_Log_Pos: 0 Master_SSL_Allowed: Yes Master_SSL_CA_File: /run/keys/defghi-ca.crt Master_SSL_CA_Path: Master_SSL_Cert: /run/keys/defghi-repl.crt Master_SSL_Cipher: Master_SSL_Key: /run/keys/defghi-repl.key Seconds_Behind_Master: 0 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: 2 Master_SSL_Crl: /run/keys/defghi-ca.crt Master_SSL_Crlpath: Using_Gtid: No Gtid_IO_Pos: Retried_transactions: 0 Max_relay_log_size: 1073741824 Executed_log_entries: 27757168 Slave_received_heartbeats: 0 Slave_heartbeat_period: 1800.000 Gtid_Slave_Pos: 0-1-704091057 *************************** 5. row *************************** Connection_name: bad-master Slave_SQL_State: Slave has read all relay log; waiting for the slave I/O thread to update it Slave_IO_State: Waiting for master to send event Master_Host: 127.127.127.127 Master_User: abcdefg Master_Port: 3306 Connect_Retry: 60 Master_Log_File: mysql-bin.018036 Read_Master_Log_Pos: 4400422 Relay_Log_File: mysqld-relay-bin-oms.000390 Relay_Log_Pos: 4400709 Relay_Master_Log_File: mysql-bin.018036 Slave_IO_Running: Yes Slave_SQL_Running: Yes Replicate_Do_DB: Replicate_Ignore_DB: Replicate_Do_Table: Replicate_Ignore_Table: Replicate_Wild_Do_Table: Replicate_Wild_Ignore_Table: mysql.%,dumps.%,some_stuff.%,test.%,tmp.% Last_Errno: 0 Last_Error: Skip_Counter: 0 Exec_Master_Log_Pos: 4400422 Relay_Log_Space: 4401054 Until_Condition: None Until_Log_File: Until_Log_Pos: 0 Master_SSL_Allowed: Yes Master_SSL_CA_File: /run/keys/defghi-ca.crt Master_SSL_CA_Path: Master_SSL_Cert: /run/keys/defghi-repl.crt Master_SSL_Cipher: Master_SSL_Key: /run/keys/defghi-repl.key Seconds_Behind_Master: 0 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: 2 Master_SSL_Crl: /run/keys/defghi-ca.crt Master_SSL_Crlpath: Using_Gtid: No Gtid_IO_Pos: Retried_transactions: 0 Max_relay_log_size: 1073741824 Executed_log_entries: 83363253 Slave_received_heartbeats: 0 Slave_heartbeat_period: 1800.000 Gtid_Slave_Pos: 0-1-704091057 *************************** 6. row *************************** Connection_name: fgh Slave_SQL_State: Slave has read all relay log; waiting for the slave I/O thread to update it Slave_IO_State: Waiting for master to send event Master_Host: 128.128.128.128 Master_User: abcdefg Master_Port: 3306 Connect_Retry: 60 Master_Log_File: mysql-bin.003201 Read_Master_Log_Pos: 85836920 Relay_Log_File: mysqld-relay-bin-sc.000223 Relay_Log_Pos: 85837207 Relay_Master_Log_File: mysql-bin.003201 Slave_IO_Running: Yes Slave_SQL_Running: Yes Replicate_Do_DB: Replicate_Ignore_DB: Replicate_Do_Table: Replicate_Ignore_Table: Replicate_Wild_Do_Table: Replicate_Wild_Ignore_Table: mysql.%,dumps.%,some_stuff.%,test.%,tmp.% Last_Errno: 0 Last_Error: Skip_Counter: 0 Exec_Master_Log_Pos: 85836920 Relay_Log_Space: 85837551 Until_Condition: None Until_Log_File: Until_Log_Pos: 0 Master_SSL_Allowed: Yes Master_SSL_CA_File: /run/keys/defghi-ca.crt Master_SSL_CA_Path: Master_SSL_Cert: /run/keys/defghi-repl.crt Master_SSL_Cipher: Master_SSL_Key: /run/keys/defghi-repl.key Seconds_Behind_Master: 0 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: 2 Master_SSL_Crl: /run/keys/defghi-ca.crt Master_SSL_Crlpath: Using_Gtid: No Gtid_IO_Pos: Retried_transactions: 0 Max_relay_log_size: 1073741824 Executed_log_entries: 11866564 Slave_received_heartbeats: 3 Slave_heartbeat_period: 1800.000 Gtid_Slave_Pos: 0-1-704091057 *************************** 7. row *************************** Connection_name: ghi Slave_SQL_State: Slave has read all relay log; waiting for the slave I/O thread to update it Slave_IO_State: Waiting for master to send event Master_Host: 129.129.129.129 Master_User: abcdefg Master_Port: 3306 Connect_Retry: 60 Master_Log_File: mysql-bin.006846 Read_Master_Log_Pos: 105446040 Relay_Log_File: mysqld-relay-bin-sg.000092 Relay_Log_Pos: 105446327 Relay_Master_Log_File: mysql-bin.006846 Slave_IO_Running: Yes Slave_SQL_Running: Yes Replicate_Do_DB: Replicate_Ignore_DB: Replicate_Do_Table: Replicate_Ignore_Table: Replicate_Wild_Do_Table: Replicate_Wild_Ignore_Table: mysql.%,dumps.%,some_stuff.%,test.%,tmp.% Last_Errno: 0 Last_Error: Skip_Counter: 0 Exec_Master_Log_Pos: 105446040 Relay_Log_Space: 105446671 Until_Condition: None Until_Log_File: Until_Log_Pos: 0 Master_SSL_Allowed: Yes Master_SSL_CA_File: /run/keys/defghi-ca.crt Master_SSL_CA_Path: Master_SSL_Cert: /run/keys/defghi-repl.crt Master_SSL_Cipher: Master_SSL_Key: /run/keys/defghi-repl.key Seconds_Behind_Master: 0 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: 2 Master_SSL_Crl: /run/keys/defghi-ca.crt Master_SSL_Crlpath: Using_Gtid: No Gtid_IO_Pos: Retried_transactions: 0 Max_relay_log_size: 1073741824 Executed_log_entries: 14610478 Slave_received_heartbeats: 0 Slave_heartbeat_period: 1800.000 Gtid_Slave_Pos: 0-1-704091057 *************************** 8. row *************************** Connection_name: hij Slave_SQL_State: Slave has read all relay log; waiting for the slave I/O thread to update it Slave_IO_State: Waiting for master to send event Master_Host: 130.130.130.130 Master_User: abcdefg Master_Port: 3306 Connect_Retry: 60 Master_Log_File: mysql-bin-changelog.082066 Read_Master_Log_Pos: 72493 Relay_Log_File: mysqld-relay-bin-zops.003791 Relay_Log_Pos: 72794 Relay_Master_Log_File: mysql-bin-changelog.082066 Slave_IO_Running: Yes Slave_SQL_Running: Yes Replicate_Do_DB: Replicate_Ignore_DB: Replicate_Do_Table: Replicate_Ignore_Table: Replicate_Wild_Do_Table: Replicate_Wild_Ignore_Table: mysql.%,dumps.%,some_stuff.%,test.%,tmp.% Last_Errno: 0 Last_Error: Skip_Counter: 0 Exec_Master_Log_Pos: 72493 Relay_Log_Space: 73158 Until_Condition: None Until_Log_File: Until_Log_Pos: 0 Master_SSL_Allowed: Yes Master_SSL_CA_File: /run/keys/rds-ca.crt Master_SSL_CA_Path: Master_SSL_Cert: Master_SSL_Cipher: Master_SSL_Key: Seconds_Behind_Master: 0 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: 1872969121 Master_SSL_Crl: /run/keys/rds-ca.crt Master_SSL_Crlpath: Using_Gtid: No Gtid_IO_Pos: Retried_transactions: 0 Max_relay_log_size: 1073741824 Executed_log_entries: 121612 Slave_received_heartbeats: 0 Slave_heartbeat_period: 1800.000 Gtid_Slave_Pos: 0-1-704091057