db1064 master position
ActivePublic
Actions

Authored by • Marostegui on Feb 6 2017, 9:31 AM.

Tags

None

Referenced Files

	F5508174: db1064 master position
	Feb 6 2017, 9:31 AM

Subscribers

None

	```
	root@PRODUCTION s4[(none)]> select @@hostname;
	+------------+
	\| @@hostname \|
	+------------+
	\| db1064 \|
	+------------+
	1 row in set (0.00 sec)

	root@PRODUCTION s4[(none)]> show master status\G
	************************* 1. row *************************
	File: db1064-bin.002546
	Position: 489454975
	Binlog_Do_DB:
	Binlog_Ignore_DB:
	1 row in set (0.00 sec)

	root@PRODUCTION s4[(none)]> show slave status\G
	************************* 1. row *************************
	Slave_IO_State:
	Master_Host: db1040.eqiad.wmnet
	Master_User: repl
	Master_Port: 3306
	Connect_Retry: 60
	Master_Log_File: db1040-bin.002748
	Read_Master_Log_Pos: 47699873
	Relay_Log_File: db1064-relay-bin.000037
	Relay_Log_Pos: 47700161
	Relay_Master_Log_File: db1040-bin.002748
	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: 47699873
	Relay_Log_Space: 47700503
	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: 171970589
	Master_SSL_Crl:
	Master_SSL_Crlpath:
	Using_Gtid: Slave_Pos
	Gtid_IO_Pos: 0-171970589-3223209106
	1 row in set (0.00 sec)
	```

db1064 master positionActivePublicActions