Paste P6422

(An Untitled Masterwork)
ActivePublic

Authored by Marostegui on Dec 4 2017, 6:42 AM.
1​root@PRODUCTION s6 slave[(none)]> select @@hostname;
2​+------------+
3​| @@hostname |
4​+------------+
5​| db1098 |
6​+------------+
7​1 row in set (0.00 sec)
8
9​root@PRODUCTION s6 slave[(none)]> show slave status\G
10​*************************** 1. row ***************************
11​ Slave_IO_State:
12​ Master_Host: db1061.eqiad.wmnet
13​ Master_User: repl
14​ Master_Port: 3306
15​ Connect_Retry: 60
16​ Master_Log_File: db1061-bin.002342
17​ Read_Master_Log_Pos: 844755810
18​ Relay_Log_File: db1098-relay-bin.000249
19​ Relay_Log_Pos: 361352197
20​ Relay_Master_Log_File: db1061-bin.002342
21​ Slave_IO_Running: No
22​ Slave_SQL_Running: No
23​ Replicate_Do_DB:
24​ Replicate_Ignore_DB:
25​ Replicate_Do_Table:
26​ Replicate_Ignore_Table:
27​ Replicate_Wild_Do_Table:
28​ Replicate_Wild_Ignore_Table:
29​ Last_Errno: 0
30​ Last_Error:
31​ Skip_Counter: 0
32​ Exec_Master_Log_Pos: 844755810
33​ Relay_Log_Space: 844756910
34​ Until_Condition: None
35​ Until_Log_File:
36​ Until_Log_Pos: 0
37​ Master_SSL_Allowed: Yes
38​ Master_SSL_CA_File:
39​ Master_SSL_CA_Path:
40​ Master_SSL_Cert:
41​ Master_SSL_Cipher:
42​ Master_SSL_Key:
43​ Seconds_Behind_Master: NULL
44​Master_SSL_Verify_Server_Cert: No
45​ Last_IO_Errno: 0
46​ Last_IO_Error:
47​ Last_SQL_Errno: 0
48​ Last_SQL_Error:
49​ Replicate_Ignore_Server_Ids:
50​ Master_Server_Id: 171978766
51​ Master_SSL_Crl:
52​ Master_SSL_Crlpath:
53​ Using_Gtid: Slave_Pos
54​ Gtid_IO_Pos: 0-180359184-3049354376,180359184-180359184-35598956,171970705-171970705-239075865,171978766-171978766-771758772
55​1 row in set (0.00 sec)
Marostegui created this paste.Dec 4 2017, 6:42 AM