Page MenuHomePhabricator
Paste P16309

(An Untitled Masterwork)
ActivePublic

Authored by Marostegui on Jun 7 2021, 5:59 AM.
Tags
None
Referenced Files
F34484729: raw-paste-data.txt
Jun 7 2021, 5:59 AM
Subscribers
None
root@dbstore1004:/srv# for i in 2 3 4; do echo "====== $i ======"; mysql -S /run/mysqld/mysqld.s$i.sock -e "show slave status\G" ; done
====== 2 ======
*************************** 1. row ***************************
Slave_IO_State:
Master_Host: db1122.eqiad.wmnet
Master_User: repl
Master_Port: 3306
Connect_Retry: 60
Master_Log_File: db1122-bin.002981
Read_Master_Log_Pos: 987954888
Relay_Log_File: dbstore1004-relay-bin.000072
Relay_Log_Pos: 987955184
Relay_Master_Log_File: db1122-bin.002981
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: 987954888
Relay_Log_Space: 987955539
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: 171978786
Master_SSL_Crl:
Master_SSL_Crlpath:
Using_Gtid: Slave_Pos
Gtid_IO_Pos: 171970567-171970567-390719906,0-180359173-4858865027,180359173-180359173-70817914,171978786-171978786-3193273639,180359271-180359271-332498589,171966574-171966574-2221092918,180359241-180359241-121693516,171966670-171966670-2410812544
Replicate_Do_Domain_Ids:
Replicate_Ignore_Domain_Ids:
Parallel_Mode: conservative
SQL_Delay: 0
SQL_Remaining_Delay: NULL
Slave_SQL_Running_State:
Slave_DDL_Groups: 0
Slave_Non_Transactional_Groups: 0
Slave_Transactional_Groups: 63183171
====== 3 ======
*************************** 1. row ***************************
Slave_IO_State:
Master_Host: db1123.eqiad.wmnet
Master_User: repl
Master_Port: 3306
Connect_Retry: 60
Master_Log_File: db1123-bin.004324
Read_Master_Log_Pos: 466847508
Relay_Log_File: dbstore1004-relay-bin.000106
Relay_Log_Pos: 466847804
Relay_Master_Log_File: db1123-bin.004324
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: 466847508
Relay_Log_Space: 466848159
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: 171978787
Master_SSL_Crl:
Master_SSL_Crlpath:
Using_Gtid: Slave_Pos
Gtid_IO_Pos: 171978787-171978787-3089023103,0-171966669-4075108480,171966669-171966669-4196523483,180359174-180359174-94123433,180363367-180363367-134174373,171974792-171974792-378345284,180355192-180355192-321029096
Replicate_Do_Domain_Ids:
Replicate_Ignore_Domain_Ids:
Parallel_Mode: conservative
SQL_Delay: 0
SQL_Remaining_Delay: NULL
Slave_SQL_Running_State:
Slave_DDL_Groups: 0
Slave_Non_Transactional_Groups: 0
Slave_Transactional_Groups: 71748739
====== 4 ======
*************************** 1. row ***************************
Slave_IO_State:
Master_Host: db1138.eqiad.wmnet
Master_User: repl
Master_Port: 3306
Connect_Retry: 60
Master_Log_File: db1138-bin.004144
Read_Master_Log_Pos: 173967607
Relay_Log_File: dbstore1004-relay-bin.000124
Relay_Log_Pos: 173967903
Relay_Master_Log_File: db1138-bin.004144
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: 173967607
Relay_Log_Space: 173968258
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: 171978876
Master_SSL_Crl:
Master_SSL_Crlpath:
Using_Gtid: Slave_Pos
Gtid_IO_Pos: 0-180359175-3368394787,171978876-171978876-2925644422,171966557-171966557-1948492266,180363436-180363436-1155411339,171978775-171978775-4822899280,180359175-180359175-43143523,171970589-171970589-201132050,180359190-180359190-192195477
Replicate_Do_Domain_Ids:
Replicate_Ignore_Domain_Ids:
Parallel_Mode: conservative
SQL_Delay: 0
SQL_Remaining_Delay: NULL
Slave_SQL_Running_State:
Slave_DDL_Groups: 0
Slave_Non_Transactional_Groups: 0
Slave_Transactional_Groups: 94416129