Page MenuHomePhabricator
Paste P6253

(An Untitled Masterwork)
ActivePublic

Authored by Marostegui on Nov 3 2017, 6:27 AM.
Tags
None
Referenced Files
F10583121:
Nov 3 2017, 6:27 AM
Subscribers
None
root@PRODUCTION s4 slave[(none)]> select @@hostname;
+------------+
| @@hostname |
+------------+
| db1103 |
+------------+
1 row in set (0.00 sec)
root@PRODUCTION s4 slave[(none)]> show slave status\G
*************************** 1. row ***************************
Slave_IO_State:
Master_Host: db1068.eqiad.wmnet
Master_User: repl
Master_Port: 3306
Connect_Retry: 60
Master_Log_File: db1068-bin.000817
Read_Master_Log_Pos: 587981290
Relay_Log_File: db1103-relay-bin.000007
Relay_Log_Pos: 587981578
Relay_Master_Log_File: db1068-bin.000817
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: 587981290
Relay_Log_Space: 587981920
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: 171978775
Master_SSL_Crl:
Master_SSL_Crlpath:
Using_Gtid: Slave_Pos
Gtid_IO_Pos: 171978775-171978775-918988082,0-180359175-3368394787,171970589-171970589-201132050,180359175-180359175-43143523
1 row in set (0.00 sec)

Event Timeline

mysql:root@localhost [(none)]> select @@hostname;
+------------+
| @@hostname |
+------------+
| db2089     |
+------------+
1 row in set (0.00 sec)

mysql:root@localhost [(none)]> show slave status\G
*************************** 1. row ***************************
               Slave_IO_State:
                  Master_Host: db2023.codfw.wmnet
                  Master_User: repl
                  Master_Port: 3306
                Connect_Retry: 60
              Master_Log_File: db2023-bin.005629
          Read_Master_Log_Pos: 458614132
               Relay_Log_File: db2089-relay-bin.000046
                Relay_Log_Pos: 458614421
        Relay_Master_Log_File: db2023-bin.005629
             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: 458614132
              Relay_Log_Space: 458614764
              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: 180359179
               Master_SSL_Crl:
           Master_SSL_Crlpath:
                   Using_Gtid: Slave_Pos
                  Gtid_IO_Pos: 180359179-180359179-96540411,0-180359179-5749966788,171974884-171974884-1397499924,171970704-171970704-351094622
      Replicate_Do_Domain_Ids:
  Replicate_Ignore_Domain_Ids:
                Parallel_Mode: conservative
1 row in set (0.00 sec)