switchdc check DB in sync
No One
Actions

Authored By

	Volans
	Sep 6 2018, 8:57 AM

Size

1 KB

Referenced Files

None

Subscribers

None

switchdc check DB in sync
View Options

	Executing commands ('mysql --skip-ssl --skip-column-names --batch -e "SELECT @@GLOBAL.gtid_binlog_pos"',) on 1 hosts: db2034.codfw.wmnet
	----- OUTPUT of 'mysql --skip-ssl...gtid_binlog_pos"' -----
	171966572-171966572-297840043,171974681-171974681-198565537,180355159-180355159-17196909,180363268-180363268-40608909
	================
	PASS: \|####################################################################################################\| 100% (1/1) [00:00<00:00, 3.02hosts/s]
	FAIL: \| \| 0% (0/1) [00:00<?, ?hosts/s]
	100.0% (1/1) success ratio (>= 100.0% threshold) for command: 'mysql --skip-ssl...gtid_binlog_pos"'.
	100.0% (1/1) success ratio (>= 100.0% threshold) of nodes successfully executed all commands.



	Executing commands ('mysql --skip-ssl --skip-column-names --batch -e "SELECT MASTER_GTID_WAIT(\'171966572-171966572-297840043,171974681-17197468
	1-198565537,180355159-180355159-17196909,180363268-180363268-40608909\', 30)"',) on 1 hosts: db1069.eqiad.wmnet
	----- OUTPUT of 'mysql --skip-ssl...-40608909', 30)"' -----
	0
	================
	PASS: \|####################################################################################################\| 100% (1/1) [00:00<00:00, 1.37hosts/s]
	FAIL: \| \| 0% (0/1) [00:00<?, ?hosts/s]
	100.0% (1/1) success ratio (>= 100.0% threshold) for command: 'mysql --skip-ssl...-40608909', 30)"'.
	100.0% (1/1) success ratio (>= 100.0% threshold) of nodes successfully executed all commands.