Page MenuHomePhabricator
Paste P7211

(An Untitled Masterwork)
ActivePublic
Actions

Authored by • Marostegui on Jun 4 2018, 2:21 PM.
Tags
None
Referenced Files
F18744723:
Jun 4 2018, 2:21 PM
Subscribers
None
root@labsdb1010:~# 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.005930
Read_Master_Log_Pos: 970730645
Relay_Log_File: labsdb1010-relay-bin-db1095.012561
Relay_Log_Pos: 970730934
Relay_Master_Log_File: db1095-bin.005930
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: 970730645
Relay_Log_Space: 970731288
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: 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: 2494800209
Slave_received_heartbeats: 0
Slave_heartbeat_period: 1800.000
Gtid_Slave_Pos: 0-171966669-4066390944,171966555-171966555-590,171966558-171966558-63,171966669-171966669-2474496651,171966670-171966670-2332919106,171970589-171970589-201132050,171970593-171970593-3479,171970599-171970599-24483,171970637-171970637-1751242743,171970663-171970663-100,171970751-171970751-21842,171974668-171974668-23,171974686-171974686-867,171974769-171974769-52,171974784-171974784-44193860,171974883-171974883-18190954,171974884-171974884-1473084269,171978764-171978764-57,171978765-171978765-33,171978766-171978766-1375989821,171978767-171978767-2160521799,171978771-171978771-30,171978772-171978772-1562,171978775-171978775-2612271957,171978777-171978777-802818939,171978778-171978778-584494846,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.001158
Read_Master_Log_Pos: 733729094
Relay_Log_File: labsdb1010-relay-bin-s2.003085
Relay_Log_Pos: 733729383
Relay_Master_Log_File: db1102-bin.001158
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: 733729094
Relay_Log_Space: 733729733
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: 538660427
Slave_received_heartbeats: 2
Slave_heartbeat_period: 1800.000
Gtid_Slave_Pos: 0-171966669-4066390944,171966555-171966555-590,171966558-171966558-63,171966669-171966669-2474496651,171966670-171966670-2332919106,171970589-171970589-201132050,171970593-171970593-3479,171970599-171970599-24483,171970637-171970637-1751242743,171970663-171970663-100,171970751-171970751-21842,171974668-171974668-23,171974686-171974686-867,171974769-171974769-52,171974784-171974784-44193860,171974883-171974883-18190954,171974884-171974884-1473084269,171978764-171978764-57,171978765-171978765-33,171978766-171978766-1375989821,171978767-171978767-2160521799,171978771-171978771-30,171978772-171978772-1562,171978775-171978775-2612271957,171978777-171978777-802818939,171978778-171978778-584494846,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.001328
Read_Master_Log_Pos: 613662950
Relay_Log_File: labsdb1010-relay-bin-s4.004346
Relay_Log_Pos: 613663239
Relay_Master_Log_File: db1102-bin.001328
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: 613662950
Relay_Log_Space: 613663589
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: 2090588859
Slave_received_heartbeats: 1
Slave_heartbeat_period: 1800.000
Gtid_Slave_Pos: 0-171966669-4066390944,171966555-171966555-590,171966558-171966558-63,171966669-171966669-2474496651,171966670-171966670-2332919106,171970589-171970589-201132050,171970593-171970593-3479,171970599-171970599-24483,171970637-171970637-1751242743,171970663-171970663-100,171970751-171970751-21842,171974668-171974668-23,171974686-171974686-867,171974769-171974769-52,171974784-171974784-44193860,171974883-171974883-18190954,171974884-171974884-1473084269,171978764-171978764-57,171978765-171978765-33,171978766-171978766-1375989821,171978767-171978767-2160521799,171978771-171978771-30,171978772-171978772-1562,171978775-171978775-2612271957,171978777-171978777-802818939,171978778-171978778-584494846,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.000734
Read_Master_Log_Pos: 218511437
Relay_Log_File: labsdb1010-relay-bin-s6.002119
Relay_Log_Pos: 218511726
Relay_Master_Log_File: db1102-bin.000734
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: 218511437
Relay_Log_Space: 218512076
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: 392041964
Slave_received_heartbeats: 1
Slave_heartbeat_period: 1800.000
Gtid_Slave_Pos: 0-171966669-4066390944,171966555-171966555-590,171966558-171966558-63,171966669-171966669-2474496651,171966670-171966670-2332919106,171970589-171970589-201132050,171970593-171970593-3479,171970599-171970599-24483,171970637-171970637-1751242743,171970663-171970663-100,171970751-171970751-21842,171974668-171974668-23,171974686-171974686-867,171974769-171974769-52,171974784-171974784-44193860,171974883-171974883-18190954,171974884-171974884-1473084269,171978764-171978764-57,171978765-171978765-33,171978766-171978766-1375989821,171978767-171978767-2160521799,171978771-171978771-30,171978772-171978772-1562,171978775-171978775-2612271957,171978777-171978777-802818939,171978778-171978778-584494846,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.001009
Read_Master_Log_Pos: 32902819
Relay_Log_File: labsdb1010-relay-bin-s7.002760
Relay_Log_Pos: 32903108
Relay_Master_Log_File: db1102-bin.001009
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: 32902819
Relay_Log_Space: 32903458
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: 751513233
Slave_received_heartbeats: 2
Slave_heartbeat_period: 1800.000
Gtid_Slave_Pos: 0-171966669-4066390944,171966555-171966555-590,171966558-171966558-63,171966669-171966669-2474496651,171966670-171966670-2332919106,171970589-171970589-201132050,171970593-171970593-3479,171970599-171970599-24483,171970637-171970637-1751242743,171970663-171970663-100,171970751-171970751-21842,171974668-171974668-23,171974686-171974686-867,171974769-171974769-52,171974784-171974784-44193860,171974883-171974883-18190954,171974884-171974884-1473084269,171978764-171978764-57,171978765-171978765-33,171978766-171978766-1375989821,171978767-171978767-2160521799,171978771-171978771-30,171978772-171978772-1562,171978775-171978775-2612271957,171978777-171978777-802818939,171978778-171978778-584494846,180359172-180359172-49702202,180359174-180359174-94123432,180359175-180359175-43143522
Content licensed under Creative Commons Attribution-ShareAlike (CC BY-SA) 4.0 unless otherwise noted; code licensed under GNU General Public License (GPL) 2.0 or later and other open source licenses. By using this site, you agree to the Terms of Use, Privacy Policy, and Code of Conduct. · Wikimedia Foundation · Privacy Policy · Code of Conduct · Terms of Use · Disclaimer · CC-BY-SA · GPL