Paste P6483

(An Untitled Masterwork)
ActivePublic

Authored by Marostegui on Dec 18 2017, 3:49 PM.
1​root@PRODUCTION test-s4 master[(none)]> select @@hostname;
2​+------------+
3​| @@hostname |
4​+------------+
5​| db1111 |
6​+------------+
7​1 row in set (0.00 sec)
8
9​root@PRODUCTION test-s4 master[(none)]> show slave status\G
10​*************************** 1. row ***************************
11​ Slave_IO_State:
12​ Master_Host: db1068.eqiad.wmnet
13​ Master_User: repl
14​ Master_Port: 3306
15​ Connect_Retry: 60
16​ Master_Log_File: db1068-bin.000947
17​ Read_Master_Log_Pos: 881028012
18​ Relay_Log_File: db1111-relay-bin.000027
19​ Relay_Log_Pos: 881028300
20​ Relay_Master_Log_File: db1068-bin.000947
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: 881028012
33​ Relay_Log_Space: 881028642
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: 171978775
51​ Master_SSL_Crl:
52​ Master_SSL_Crlpath:
53​ Using_Gtid: Slave_Pos
54​ Gtid_IO_Pos: 171978775-171978775-1214378164,0-180359175-3368394787,171970589-171970589-201132050,180359175-180359173
55​1 row in set (0.00 sec)
Marostegui created this paste.Dec 18 2017, 3:49 PM