Created
January 22, 2014 00:24
-
-
Save winebarrel/8551279 to your computer and use it in GitHub Desktop.
MHAによるオンライン切り換え時のクエリログ
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| 140122 0:21:53 7 Connect mha@yog on | |
| 7 Query set autocommit=1 | |
| 7 Query SELECT CONNECTION_ID() AS Value | |
| 8 Connect mha@yog on | |
| 8 Query set autocommit=1 | |
| 8 Query SELECT CONNECTION_ID() AS Value | |
| 8 Query SET wait_timeout=86400 | |
| 8 Query SELECT @@global.server_id As Value | |
| 8 Query SELECT VERSION() AS Value | |
| 8 Query SHOW GLOBAL VARIABLES LIKE 'log_bin' | |
| 8 Query SHOW MASTER STATUS | |
| 8 Query SELECT @@global.datadir AS Value | |
| 8 Query SELECT @@global.relay_log_info_file AS Value | |
| 8 Query SELECT @@global.datadir AS Value | |
| 8 Query SHOW SLAVE STATUS | |
| 8 Query SELECT @@global.read_only As Value | |
| 8 Query SELECT @@global.relay_log_purge As Value | |
| 140122 0:21:55 8 Query FLUSH NO_WRITE_TO_BINLOG TABLES | |
| 8 Query SELECT GET_LOCK('MHA_Master_High_Availability_Monitor', '0') AS Value | |
| 8 Query SHOW PROCESSLIST | |
| 140122 0:21:56 8 Query SELECT RELEASE_LOCK('MHA_Master_High_Availability_Monitor') As Value | |
| 8 Quit | |
| 140122 0:21:57 9 Connect mha@yog on | |
| 9 Query SET SQL_LOG_BIN = 0 | |
| 9 Query DROP USER scott@'%' | |
| 9 Query FLUSH PRIVILEGES | |
| 9 Query SHOW PROCESSLIST | |
| 9 Query SHOW PROCESSLIST | |
| 9 Query SHOW PROCESSLIST | |
| 9 Query SHOW PROCESSLIST | |
| 9 Query SHOW PROCESSLIST | |
| 9 Query SHOW PROCESSLIST | |
| 9 Query SHOW PROCESSLIST | |
| 9 Query SHOW PROCESSLIST | |
| 9 Query SHOW PROCESSLIST | |
| 9 Query SHOW PROCESSLIST | |
| 140122 0:21:58 9 Query SHOW PROCESSLIST | |
| 9 Query SHOW PROCESSLIST | |
| 9 Query SHOW PROCESSLIST | |
| 9 Query SHOW PROCESSLIST | |
| 9 Query SHOW PROCESSLIST | |
| 9 Query SHOW PROCESSLIST | |
| 9 Query SET GLOBAL READ_ONLY = 1 | |
| 9 Query select @@read_only as read_only | |
| 9 Query SHOW PROCESSLIST | |
| 9 Query SHOW PROCESSLIST | |
| 9 Query SHOW PROCESSLIST | |
| 9 Query SHOW PROCESSLIST | |
| 9 Query SHOW PROCESSLIST | |
| 140122 0:21:59 9 Query SHOW PROCESSLIST | |
| 9 Query SET SQL_LOG_BIN = 1 | |
| 9 Quit | |
| 10 Connect mha@yog on | |
| 10 Query set autocommit=1 | |
| 10 Query SELECT CONNECTION_ID() AS Value | |
| 10 Query SET wait_timeout=86400 | |
| 10 Query FLUSH TABLES WITH READ LOCK | |
| 10 Query SHOW MASTER STATUS | |
| 140122 0:22:00 10 Query UNLOCK TABLES | |
| 10 Query SELECT RELEASE_LOCK('MHA_Master_High_Availability_Failover') As Value | |
| 10 Quit |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| 140122 0:21:53 7 Connect mha@yog on | |
| 7 Query set autocommit=1 | |
| 7 Query SELECT CONNECTION_ID() AS Value | |
| 8 Connect mha@yog on | |
| 8 Query set autocommit=1 | |
| 8 Query SELECT CONNECTION_ID() AS Value | |
| 8 Query SET wait_timeout=86400 | |
| 8 Query SELECT @@global.server_id As Value | |
| 8 Query SELECT VERSION() AS Value | |
| 8 Query SHOW GLOBAL VARIABLES LIKE 'log_bin' | |
| 8 Query SHOW MASTER STATUS | |
| 8 Query SELECT @@global.datadir AS Value | |
| 8 Query SELECT @@global.relay_log_info_file AS Value | |
| 8 Query SELECT @@global.datadir AS Value | |
| 8 Query SHOW SLAVE STATUS | |
| 8 Query SELECT @@global.read_only As Value | |
| 8 Query SELECT @@global.relay_log_purge As Value | |
| 8 Query SHOW SLAVE STATUS | |
| 8 Query SELECT Repl_slave_priv AS Value FROM mysql.user WHERE user = 'repl' | |
| 140122 0:21:55 8 Query SELECT GET_LOCK('MHA_Master_High_Availability_Failover', '0') AS Value | |
| 8 Query SHOW SLAVE STATUS | |
| 8 Query SHOW SLAVE STATUS | |
| 140122 0:21:56 8 Query SHOW PROCESSLIST | |
| 140122 0:21:57 9 Connect mha@yog on | |
| 9 Query SET GLOBAL READ_ONLY = 1 | |
| 9 Query select @@read_only as read_only | |
| 9 Quit | |
| 140122 0:21:59 8 Query SHOW SLAVE STATUS | |
| 8 Query SELECT MASTER_POS_WAIT('mysqld-bin.000002','107',0) AS Result | |
| 8 Query STOP SLAVE SQL_THREAD | |
| 8 Query SHOW SLAVE STATUS | |
| 8 Query SHOW MASTER STATUS | |
| 10 Connect mha@yog on | |
| 10 Query SET SQL_LOG_BIN = 0 | |
| 10 Query SET GLOBAL READ_ONLY = 0 | |
| 10 Query SET SQL_LOG_BIN = 1 | |
| 10 Quit | |
| 140122 0:22:00 8 Query SELECT @@global.read_only As Value | |
| 11 Connect repl@nyar on | |
| 11 Query SELECT UNIX_TIMESTAMP() | |
| 11 Query SHOW VARIABLES LIKE 'SERVER_ID' | |
| 11 Query SET @master_heartbeat_period= 1799999979520 | |
| 11 Binlog Dump Log: 'mysqld-bin.000002' Pos: 107 | |
| 8 Query STOP SLAVE | |
| 8 Query SHOW SLAVE STATUS | |
| 8 Query RESET SLAVE /*!50516 ALL */ | |
| 8 Query SHOW SLAVE STATUS | |
| 8 Query SELECT RELEASE_LOCK('MHA_Master_High_Availability_Failover') As Value | |
| 8 Quit | |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| 140122 0:21:53 7 Connect mha@yog on | |
| 7 Query set autocommit=1 | |
| 7 Query SELECT CONNECTION_ID() AS Value | |
| 8 Connect mha@yog on | |
| 8 Query set autocommit=1 | |
| 8 Query SELECT CONNECTION_ID() AS Value | |
| 8 Query SET wait_timeout=86400 | |
| 8 Query SELECT @@global.server_id As Value | |
| 8 Query SELECT VERSION() AS Value | |
| 8 Query SHOW GLOBAL VARIABLES LIKE 'log_bin' | |
| 8 Query SHOW MASTER STATUS | |
| 8 Query SELECT @@global.datadir AS Value | |
| 8 Query SELECT @@global.relay_log_info_file AS Value | |
| 8 Query SELECT @@global.datadir AS Value | |
| 8 Query SHOW SLAVE STATUS | |
| 8 Query SELECT @@global.read_only As Value | |
| 8 Query SELECT @@global.relay_log_purge As Value | |
| 8 Query SHOW SLAVE STATUS | |
| 8 Query SELECT Repl_slave_priv AS Value FROM mysql.user WHERE user = 'repl' | |
| 140122 0:21:55 8 Query SELECT GET_LOCK('MHA_Master_High_Availability_Failover', '0') AS Value | |
| 8 Query SHOW SLAVE STATUS | |
| 8 Query SHOW SLAVE STATUS | |
| 140122 0:21:59 8 Query SHOW SLAVE STATUS | |
| 140122 0:22:00 8 Query SHOW SLAVE STATUS | |
| 8 Query SELECT MASTER_POS_WAIT('mysqld-bin.000002','107',0) AS Result | |
| 8 Query STOP SLAVE SQL_THREAD | |
| 8 Query SHOW SLAVE STATUS | |
| 8 Query STOP SLAVE | |
| 8 Query SHOW SLAVE STATUS | |
| 8 Query RESET SLAVE | |
| 8 Query CHANGE MASTER TO MASTER_HOST='hastur', MASTER_PORT=3306, MASTER_USER='repl', MASTER_LOG_FILE='mysqld-bin.000002', MASTER_LOG_POS=107 | |
| 8 Query SET GLOBAL relay_log_purge=0 | |
| 8 Query START SLAVE | |
| 8 Query SHOW SLAVE STATUS | |
| 9 Connect Out repl@hastur:3306 | |
| 8 Query SHOW SLAVE STATUS | |
| 8 Query SELECT RELEASE_LOCK('MHA_Master_High_Availability_Failover') As Value | |
| 8 Quit | |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment