Created
March 11, 2014 10:25
-
-
Save s-tajima/9483097 to your computer and use it in GitHub Desktop.
Command log of test for MHA failover.
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
= t1 ------------------------------------------------------------------------------------------------------------------------------------------- | |
mysqlserver-a> select * from test_table01; | |
+----+---------------------+---------------------------+ | |
| id | time | text | | |
+----+---------------------+---------------------------+ | |
| 1 | 2014-03-10 15:33:42 | cva3fiwqey0owkoosc4c04kk4 | | |
| 2 | 2014-03-10 15:33:42 | 4bbdnnjqxr0gkw48kkgc8k8sc | | |
| 3 | 2014-03-10 15:33:42 | 6515bxq6eyw4w8ksoogogo4wo | | |
+----+---------------------+---------------------------+ | |
3 rows in set (0.00 sec) | |
mysqlserver-b> select * from test_table01; | |
+----+---------------------+---------------------------+ | |
| id | time | text | | |
+----+---------------------+---------------------------+ | |
| 1 | 2014-03-10 15:33:42 | cva3fiwqey0owkoosc4c04kk4 | | |
| 2 | 2014-03-10 15:33:42 | 4bbdnnjqxr0gkw48kkgc8k8sc | | |
| 3 | 2014-03-10 15:33:42 | 6515bxq6eyw4w8ksoogogo4wo | | |
+----+---------------------+---------------------------+ | |
3 rows in set (0.00 sec) | |
mysqlserver-b> show slave status\G | |
*************************** 1. row *************************** | |
Slave_IO_State: Waiting for master to send event | |
Master_Log_File: mysqld-bin.000007 | |
Read_Master_Log_Pos: 21039 | |
Relay_Log_File: mysqlserver-b-relay-bin.000002 | |
Relay_Log_Pos: 7832 | |
Relay_Master_Log_File: mysqld-bin.000007 | |
Slave_IO_Running: Yes | |
Slave_SQL_Running: Yes | |
Exec_Master_Log_Pos: 21039 | |
Seconds_Behind_Master: 0 | |
SQL_Delay: 0 | |
SQL_Remaining_Delay: NULL | |
Slave_SQL_Running_State: Slave has read all relay log; waiting for the slave I/O thread to update it | |
Master_Retry_Count: 86400 | |
mysqlserver-c> select * from test_table01; | |
+----+---------------------+---------------------------+ | |
| id | time | text | | |
+----+---------------------+---------------------------+ | |
| 1 | 2014-03-10 15:33:42 | cva3fiwqey0owkoosc4c04kk4 | | |
| 2 | 2014-03-10 15:33:42 | 4bbdnnjqxr0gkw48kkgc8k8sc | | |
| 3 | 2014-03-10 15:33:42 | 6515bxq6eyw4w8ksoogogo4wo | | |
+----+---------------------+---------------------------+ | |
3 rows in set (0.00 sec) | |
mysqlserver-c> show slave status\G | |
*************************** 1. row *************************** | |
Slave_IO_State: Waiting for master to send event | |
Master_Log_File: mysqld-bin.000007 | |
Read_Master_Log_Pos: 21039 | |
Relay_Log_File: mysqlserver-c-relay-bin.000002 | |
Relay_Log_Pos: 7832 | |
Relay_Master_Log_File: mysqld-bin.000007 | |
Slave_IO_Running: Yes | |
Slave_SQL_Running: No | |
Exec_Master_Log_Pos: 21039 | |
Seconds_Behind_Master: NULL | |
SQL_Delay: 0 | |
SQL_Remaining_Delay: NULL | |
Slave_SQL_Running_State: Slave has read all relay log; waiting for the slave I/O thread to update it | |
Master_Retry_Count: 86400 | |
= t2 ------------------------------------------------------------------------------------------------------------------------------------------- | |
mysqlserver-c> stop slave SQL_THREAD; | |
Query OK, 0 rows affected, 1 warning (0.00 sec) | |
mysqlserver-a> select * from test_table01; | |
+----+---------------------+---------------------------+ | |
| id | time | text | | |
+----+---------------------+---------------------------+ | |
| 1 | 2014-03-10 15:33:42 | cva3fiwqey0owkoosc4c04kk4 | | |
| 2 | 2014-03-10 15:33:42 | 4bbdnnjqxr0gkw48kkgc8k8sc | | |
| 3 | 2014-03-10 15:33:42 | 6515bxq6eyw4w8ksoogogo4wo | | |
| 4 | 2014-03-10 15:37:38 | 3zt9uxz3456oww8wccowooo48 | | |
| 5 | 2014-03-10 15:37:38 | awryz2kz30g00cw44o884ss84 | | |
| 6 | 2014-03-10 15:37:38 | ezkr0ccu0pskkc40c4so4kcoo | | |
+----+---------------------+---------------------------+ | |
6 rows in set (0.00 sec) | |
mysqlserver-b> select * from test_table01; | |
+----+---------------------+---------------------------+ | |
| id | time | text | | |
+----+---------------------+---------------------------+ | |
| 1 | 2014-03-10 15:33:42 | cva3fiwqey0owkoosc4c04kk4 | | |
| 2 | 2014-03-10 15:33:42 | 4bbdnnjqxr0gkw48kkgc8k8sc | | |
| 3 | 2014-03-10 15:33:42 | 6515bxq6eyw4w8ksoogogo4wo | | |
| 4 | 2014-03-10 15:37:38 | 3zt9uxz3456oww8wccowooo48 | | |
| 5 | 2014-03-10 15:37:38 | awryz2kz30g00cw44o884ss84 | | |
| 6 | 2014-03-10 15:37:38 | ezkr0ccu0pskkc40c4so4kcoo | | |
+----+---------------------+---------------------------+ | |
6 rows in set (0.00 sec) | |
mysqlserver-b> show slave status\G | |
*************************** 1. row *************************** | |
Slave_IO_State: Waiting for master to send event | |
Master_Host: mysqlserver-a | |
Master_User: repluser | |
Master_Port: 3306 | |
Connect_Retry: 60 | |
Master_Log_File: mysqld-bin.000007 | |
Read_Master_Log_Pos: 22086 | |
Relay_Log_File: mysqlserver-b-relay-bin.000002 | |
Relay_Log_Pos: 8879 | |
Relay_Master_Log_File: mysqld-bin.000007 | |
Slave_IO_Running: Yes | |
Slave_SQL_Running: Yes | |
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: 22086 | |
Relay_Log_Space: 9063 | |
Until_Condition: None | |
Until_Log_File: | |
Until_Log_Pos: 0 | |
Master_SSL_Allowed: No | |
Master_SSL_CA_File: | |
Master_SSL_CA_Path: | |
Master_SSL_Cert: | |
Master_SSL_Cipher: | |
Master_SSL_Key: | |
Seconds_Behind_Master: 0 | |
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: 1 | |
Master_UUID: 07504317-a5d4-11e3-bc32-123150047aa8 | |
Master_Info_File: /var/lib/mysql/master.info | |
SQL_Delay: 0 | |
SQL_Remaining_Delay: NULL | |
Slave_SQL_Running_State: Slave has read all relay log; waiting for the slave I/O thread to update it | |
Master_Retry_Count: 86400 | |
Master_Bind: | |
Last_IO_Error_Timestamp: | |
Last_SQL_Error_Timestamp: | |
Master_SSL_Crl: | |
Master_SSL_Crlpath: | |
Retrieved_Gtid_Set: | |
Executed_Gtid_Set: | |
Auto_Position: 0 | |
1 row in set (0.00 sec) | |
mysqlserver-c> select * from test_table01; | |
+----+---------------------+---------------------------+ | |
| id | time | text | | |
+----+---------------------+---------------------------+ | |
| 1 | 2014-03-10 15:33:42 | cva3fiwqey0owkoosc4c04kk4 | | |
| 2 | 2014-03-10 15:33:42 | 4bbdnnjqxr0gkw48kkgc8k8sc | | |
| 3 | 2014-03-10 15:33:42 | 6515bxq6eyw4w8ksoogogo4wo | | |
+----+---------------------+---------------------------+ | |
3 rows in set (0.00 sec) | |
mysqlserver-c> show slave status\G | |
*************************** 1. row *************************** | |
Slave_IO_State: Waiting for master to send event | |
Master_Host: mysqlserver-a | |
Master_User: repluser | |
Master_Port: 3306 | |
Connect_Retry: 60 | |
Master_Log_File: mysqld-bin.000007 | |
Read_Master_Log_Pos: 22086 | |
Relay_Log_File: mysqlserver-c-relay-bin.000002 | |
Relay_Log_Pos: 7832 | |
Relay_Master_Log_File: mysqld-bin.000007 | |
Slave_IO_Running: Yes | |
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: 21039 | |
Relay_Log_Space: 9063 | |
Until_Condition: None | |
Until_Log_File: | |
Until_Log_Pos: 0 | |
Master_SSL_Allowed: No | |
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: 1 | |
Master_UUID: 07504317-a5d4-11e3-bc32-123150047aa8 | |
Master_Info_File: /mysql/master.info | |
SQL_Delay: 0 | |
SQL_Remaining_Delay: NULL | |
Slave_SQL_Running_State: | |
Master_Retry_Count: 86400 | |
Master_Bind: | |
Last_IO_Error_Timestamp: | |
Last_SQL_Error_Timestamp: | |
Master_SSL_Crl: | |
Master_SSL_Crlpath: | |
Retrieved_Gtid_Set: | |
Executed_Gtid_Set: | |
Auto_Position: 0 | |
1 row in set (0.00 sec) | |
= t3 ------------------------------------------------------------------------------------------------------------------------------------------- | |
mysqlserver-b> stop slave SQL_THREAD; | |
Query OK, 0 rows affected (0.00 sec) | |
mysqlserver-a> select * from test_table01; | |
+----+---------------------+---------------------------+ | |
| id | time | text | | |
+----+---------------------+---------------------------+ | |
| 1 | 2014-03-10 15:33:42 | cva3fiwqey0owkoosc4c04kk4 | | |
| 2 | 2014-03-10 15:33:42 | 4bbdnnjqxr0gkw48kkgc8k8sc | | |
| 3 | 2014-03-10 15:33:42 | 6515bxq6eyw4w8ksoogogo4wo | | |
| 4 | 2014-03-10 15:37:38 | 3zt9uxz3456oww8wccowooo48 | | |
| 5 | 2014-03-10 15:37:38 | awryz2kz30g00cw44o884ss84 | | |
| 6 | 2014-03-10 15:37:38 | ezkr0ccu0pskkc40c4so4kcoo | | |
| 7 | 2014-03-10 15:55:50 | dtokhem4trco8sso448kgkw8s | | |
| 8 | 2014-03-10 15:55:50 | 5cz3ygvhek8wgwkccwwsoss4o | | |
| 9 | 2014-03-10 15:55:50 | 3u81ju0p57i8w0s08c0oow0ks | | |
+----+---------------------+---------------------------+ | |
9 rows in set (0.00 sec) | |
mysqlserver-b> select * from test_table01; | |
+----+---------------------+---------------------------+ | |
| id | time | text | | |
+----+---------------------+---------------------------+ | |
| 1 | 2014-03-10 15:33:42 | cva3fiwqey0owkoosc4c04kk4 | | |
| 2 | 2014-03-10 15:33:42 | 4bbdnnjqxr0gkw48kkgc8k8sc | | |
| 3 | 2014-03-10 15:33:42 | 6515bxq6eyw4w8ksoogogo4wo | | |
| 4 | 2014-03-10 15:37:38 | 3zt9uxz3456oww8wccowooo48 | | |
| 5 | 2014-03-10 15:37:38 | awryz2kz30g00cw44o884ss84 | | |
| 6 | 2014-03-10 15:37:38 | ezkr0ccu0pskkc40c4so4kcoo | | |
+----+---------------------+---------------------------+ | |
6 rows in set (0.00 sec) | |
mysqlserver-b> show slave status\G | |
*************************** 1. row *************************** | |
Slave_IO_State: Waiting for master to send event | |
Master_Host: mysqlserver-a | |
Master_User: repluser | |
Master_Port: 3306 | |
Connect_Retry: 60 | |
Master_Log_File: mysqld-bin.000007 | |
Read_Master_Log_Pos: 23133 | |
Relay_Log_File: mysqlserver-b-relay-bin.000002 | |
Relay_Log_Pos: 8879 | |
Relay_Master_Log_File: mysqld-bin.000007 | |
Slave_IO_Running: Yes | |
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: 22086 | |
Relay_Log_Space: 10110 | |
Until_Condition: None | |
Until_Log_File: | |
Until_Log_Pos: 0 | |
Master_SSL_Allowed: No | |
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: 1 | |
Master_UUID: 07504317-a5d4-11e3-bc32-123150047aa8 | |
Master_Info_File: /var/lib/mysql/master.info | |
SQL_Delay: 0 | |
SQL_Remaining_Delay: NULL | |
Slave_SQL_Running_State: | |
Master_Retry_Count: 86400 | |
Master_Bind: | |
Last_IO_Error_Timestamp: | |
Last_SQL_Error_Timestamp: | |
Master_SSL_Crl: | |
Master_SSL_Crlpath: | |
Retrieved_Gtid_Set: | |
Executed_Gtid_Set: | |
Auto_Position: 0 | |
1 row in set (0.00 sec) | |
mysqlserver-c> select * from test_table01; | |
+----+---------------------+---------------------------+ | |
| id | time | text | | |
+----+---------------------+---------------------------+ | |
| 1 | 2014-03-10 15:33:42 | cva3fiwqey0owkoosc4c04kk4 | | |
| 2 | 2014-03-10 15:33:42 | 4bbdnnjqxr0gkw48kkgc8k8sc | | |
| 3 | 2014-03-10 15:33:42 | 6515bxq6eyw4w8ksoogogo4wo | | |
+----+---------------------+---------------------------+ | |
3 rows in set (0.00 sec) | |
mysqlserver-c> show slave status\G | |
*************************** 1. row *************************** | |
Slave_IO_State: Waiting for master to send event | |
Master_Host: mysqlserver-a | |
Master_User: repluser | |
Master_Port: 3306 | |
Connect_Retry: 60 | |
Master_Log_File: mysqld-bin.000007 | |
Read_Master_Log_Pos: 23133 | |
Relay_Log_File: mysqlserver-c-relay-bin.000002 | |
Relay_Log_Pos: 7832 | |
Relay_Master_Log_File: mysqld-bin.000007 | |
Slave_IO_Running: Yes | |
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: 21039 | |
Relay_Log_Space: 10110 | |
Until_Condition: None | |
Until_Log_File: | |
Until_Log_Pos: 0 | |
Master_SSL_Allowed: No | |
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: 1 | |
Master_UUID: 07504317-a5d4-11e3-bc32-123150047aa8 | |
Master_Info_File: /mysql/master.info | |
SQL_Delay: 0 | |
SQL_Remaining_Delay: NULL | |
Slave_SQL_Running_State: | |
Master_Retry_Count: 86400 | |
Master_Bind: | |
Last_IO_Error_Timestamp: | |
Last_SQL_Error_Timestamp: | |
Master_SSL_Crl: | |
Master_SSL_Crlpath: | |
Retrieved_Gtid_Set: | |
Executed_Gtid_Set: | |
Auto_Position: 0 | |
1 row in set (0.00 sec) | |
= t4 ------------------------------------------------------------------------------------------------------------------------------------------- | |
mysqlserver-c> stop slave IO_THREAD; | |
Query OK, 0 rows affected (0.01 sec) | |
mysqlserver-a> select * from test_table01;show master status; | |
+----+---------------------+---------------------------+ | |
| id | time | text | | |
+----+---------------------+---------------------------+ | |
| 1 | 2014-03-10 15:33:42 | cva3fiwqey0owkoosc4c04kk4 | | |
| 2 | 2014-03-10 15:33:42 | 4bbdnnjqxr0gkw48kkgc8k8sc | | |
| 3 | 2014-03-10 15:33:42 | 6515bxq6eyw4w8ksoogogo4wo | | |
| 4 | 2014-03-10 15:37:38 | 3zt9uxz3456oww8wccowooo48 | | |
| 5 | 2014-03-10 15:37:38 | awryz2kz30g00cw44o884ss84 | | |
| 6 | 2014-03-10 15:37:38 | ezkr0ccu0pskkc40c4so4kcoo | | |
| 7 | 2014-03-10 15:55:50 | dtokhem4trco8sso448kgkw8s | | |
| 8 | 2014-03-10 15:55:50 | 5cz3ygvhek8wgwkccwwsoss4o | | |
| 9 | 2014-03-10 15:55:50 | 3u81ju0p57i8w0s08c0oow0ks | | |
| 10 | 2014-03-10 17:12:36 | 7cdj9wt3fvokko8wsw04s0w8w | | |
| 11 | 2014-03-10 17:12:36 | 9g0k7mwtc3k04s8ookk44c0ww | | |
| 12 | 2014-03-10 17:12:36 | ly8x661v79s80ow4k8gcsskk | | |
+----+---------------------+---------------------------+ | |
12 rows in set (0.00 sec) | |
mysqlserver-a> show master status; | |
+-------------------+----------+--------------+------------------+-------------------+ | |
| File | Position | Binlog_Do_DB | Binlog_Ignore_DB | Executed_Gtid_Set | | |
+-------------------+----------+--------------+------------------+-------------------+ | |
| mysqld-bin.000007 | 24179 | | | | | |
+-------------------+----------+--------------+------------------+-------------------+ | |
1 row in set (0.00 sec) | |
mysqlserver-b> select * from test_table01; | |
+----+---------------------+---------------------------+ | |
| id | time | text | | |
+----+---------------------+---------------------------+ | |
| 1 | 2014-03-10 15:33:42 | cva3fiwqey0owkoosc4c04kk4 | | |
| 2 | 2014-03-10 15:33:42 | 4bbdnnjqxr0gkw48kkgc8k8sc | | |
| 3 | 2014-03-10 15:33:42 | 6515bxq6eyw4w8ksoogogo4wo | | |
| 4 | 2014-03-10 15:37:38 | 3zt9uxz3456oww8wccowooo48 | | |
| 5 | 2014-03-10 15:37:38 | awryz2kz30g00cw44o884ss84 | | |
| 6 | 2014-03-10 15:37:38 | ezkr0ccu0pskkc40c4so4kcoo | | |
+----+---------------------+---------------------------+ | |
6 rows in set (0.00 sec) | |
mysqlserver-b> show slave status\G | |
*************************** 1. row *************************** | |
Slave_IO_State: Waiting for master to send event | |
Master_Host: mysqlserver-a | |
Master_User: repluser | |
Master_Port: 3306 | |
Connect_Retry: 60 | |
Master_Log_File: mysqld-bin.000007 | |
Read_Master_Log_Pos: 24179 | |
Relay_Log_File: mysqlserver-b-relay-bin.000002 | |
Relay_Log_Pos: 8879 | |
Relay_Master_Log_File: mysqld-bin.000007 | |
Slave_IO_Running: Yes | |
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: 22086 | |
Relay_Log_Space: 11156 | |
Until_Condition: None | |
Until_Log_File: | |
Until_Log_Pos: 0 | |
Master_SSL_Allowed: No | |
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: 1 | |
Master_UUID: 07504317-a5d4-11e3-bc32-123150047aa8 | |
Master_Info_File: /var/lib/mysql/master.info | |
SQL_Delay: 0 | |
SQL_Remaining_Delay: NULL | |
Slave_SQL_Running_State: | |
Master_Retry_Count: 86400 | |
Master_Bind: | |
Last_IO_Error_Timestamp: | |
Last_SQL_Error_Timestamp: | |
Master_SSL_Crl: | |
Master_SSL_Crlpath: | |
Retrieved_Gtid_Set: | |
Executed_Gtid_Set: | |
Auto_Position: 0 | |
1 row in set (0.00 sec) | |
mysqlserver-c> select * from test_table01; | |
+----+---------------------+---------------------------+ | |
| id | time | text | | |
+----+---------------------+---------------------------+ | |
| 1 | 2014-03-10 15:33:42 | cva3fiwqey0owkoosc4c04kk4 | | |
| 2 | 2014-03-10 15:33:42 | 4bbdnnjqxr0gkw48kkgc8k8sc | | |
| 3 | 2014-03-10 15:33:42 | 6515bxq6eyw4w8ksoogogo4wo | | |
+----+---------------------+---------------------------+ | |
3 rows in set (0.00 sec) | |
mysqlserver-c> show slave status\G | |
*************************** 1. row *************************** | |
Slave_IO_State: | |
Master_Host: mysqlserver-a | |
Master_User: repluser | |
Master_Port: 3306 | |
Connect_Retry: 60 | |
Master_Log_File: mysqld-bin.000007 | |
Read_Master_Log_Pos: 23133 | |
Relay_Log_File: mysqlserver-c-relay-bin.000002 | |
Relay_Log_Pos: 7832 | |
Relay_Master_Log_File: mysqld-bin.000007 | |
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: 21039 | |
Relay_Log_Space: 10110 | |
Until_Condition: None | |
Until_Log_File: | |
Until_Log_Pos: 0 | |
Master_SSL_Allowed: No | |
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: 1 | |
Master_UUID: 07504317-a5d4-11e3-bc32-123150047aa8 | |
Master_Info_File: /mysql/master.info | |
SQL_Delay: 0 | |
SQL_Remaining_Delay: NULL | |
Slave_SQL_Running_State: | |
Master_Retry_Count: 86400 | |
Master_Bind: | |
Last_IO_Error_Timestamp: | |
Last_SQL_Error_Timestamp: | |
Master_SSL_Crl: | |
Master_SSL_Crlpath: | |
Retrieved_Gtid_Set: | |
Executed_Gtid_Set: | |
Auto_Position: 0 | |
1 row in set (0.00 sec) | |
= t5 ------------------------------------------------------------------------------------------------------------------------------------------- | |
mysqlserver-a> select * from test_table01; | |
+----+---------------------+---------------------------+ | |
| id | time | text | | |
+----+---------------------+---------------------------+ | |
| 1 | 2014-03-10 15:33:42 | cva3fiwqey0owkoosc4c04kk4 | | |
| 2 | 2014-03-10 15:33:42 | 4bbdnnjqxr0gkw48kkgc8k8sc | | |
| 3 | 2014-03-10 15:33:42 | 6515bxq6eyw4w8ksoogogo4wo | | |
| 4 | 2014-03-10 15:37:38 | 3zt9uxz3456oww8wccowooo48 | | |
| 5 | 2014-03-10 15:37:38 | awryz2kz30g00cw44o884ss84 | | |
| 6 | 2014-03-10 15:37:38 | ezkr0ccu0pskkc40c4so4kcoo | | |
| 7 | 2014-03-10 15:55:50 | dtokhem4trco8sso448kgkw8s | | |
| 8 | 2014-03-10 15:55:50 | 5cz3ygvhek8wgwkccwwsoss4o | | |
| 9 | 2014-03-10 15:55:50 | 3u81ju0p57i8w0s08c0oow0ks | | |
| 10 | 2014-03-10 17:12:36 | 7cdj9wt3fvokko8wsw04s0w8w | | |
| 11 | 2014-03-10 17:12:36 | 9g0k7mwtc3k04s8ookk44c0ww | | |
| 12 | 2014-03-10 17:12:36 | ly8x661v79s80ow4k8gcsskk | | |
| 13 | 2014-03-10 17:16:18 | 7du9on5bf0w8ks84g4o8wc0w0 | | |
| 14 | 2014-03-10 17:16:19 | 8orqzsbqbgg0w0skg4cc4k8kk | | |
| 15 | 2014-03-10 17:16:19 | 9pw5mgs9278k48o48c084gw0w | | |
+----+---------------------+---------------------------+ | |
15 rows in set (0.00 sec) | |
mysqlserver-a> show master status; | |
+-------------------+----------+--------------+------------------+-------------------+ | |
| File | Position | Binlog_Do_DB | Binlog_Ignore_DB | Executed_Gtid_Set | | |
+-------------------+----------+--------------+------------------+-------------------+ | |
| mysqld-bin.000007 | 25226 | | | | | |
+-------------------+----------+--------------+------------------+-------------------+ | |
1 row in set (0.00 sec) | |
mysqlserver-b> select * from test_table01; | |
+----+---------------------+---------------------------+ | |
| id | time | text | | |
+----+---------------------+---------------------------+ | |
| 1 | 2014-03-10 15:33:42 | cva3fiwqey0owkoosc4c04kk4 | | |
| 2 | 2014-03-10 15:33:42 | 4bbdnnjqxr0gkw48kkgc8k8sc | | |
| 3 | 2014-03-10 15:33:42 | 6515bxq6eyw4w8ksoogogo4wo | | |
| 4 | 2014-03-10 15:37:38 | 3zt9uxz3456oww8wccowooo48 | | |
| 5 | 2014-03-10 15:37:38 | awryz2kz30g00cw44o884ss84 | | |
| 6 | 2014-03-10 15:37:38 | ezkr0ccu0pskkc40c4so4kcoo | | |
+----+---------------------+---------------------------+ | |
6 rows in set (0.00 sec) | |
mysqlserver-b> show slave status\G | |
*************************** 1. row *************************** | |
Slave_IO_State: | |
Master_Host: mysqlserver-a | |
Master_User: repluser | |
Master_Port: 3306 | |
Connect_Retry: 60 | |
Master_Log_File: mysqld-bin.000007 | |
Read_Master_Log_Pos: 24179 | |
Relay_Log_File: mysqlserver-b-relay-bin.000002 | |
Relay_Log_Pos: 8879 | |
Relay_Master_Log_File: mysqld-bin.000007 | |
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: 22086 | |
Relay_Log_Space: 11156 | |
Until_Condition: None | |
Until_Log_File: | |
Until_Log_Pos: 0 | |
Master_SSL_Allowed: No | |
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: 1 | |
Master_UUID: 07504317-a5d4-11e3-bc32-123150047aa8 | |
Master_Info_File: /var/lib/mysql/master.info | |
SQL_Delay: 0 | |
SQL_Remaining_Delay: NULL | |
Slave_SQL_Running_State: | |
Master_Retry_Count: 86400 | |
Master_Bind: | |
Last_IO_Error_Timestamp: | |
Last_SQL_Error_Timestamp: | |
Master_SSL_Crl: | |
Master_SSL_Crlpath: | |
Retrieved_Gtid_Set: | |
Executed_Gtid_Set: | |
Auto_Position: 0 | |
1 row in set (0.00 sec) | |
mysqlserver-c> select * from test_table01; | |
+----+---------------------+---------------------------+ | |
| id | time | text | | |
+----+---------------------+---------------------------+ | |
| 1 | 2014-03-10 15:33:42 | cva3fiwqey0owkoosc4c04kk4 | | |
| 2 | 2014-03-10 15:33:42 | 4bbdnnjqxr0gkw48kkgc8k8sc | | |
| 3 | 2014-03-10 15:33:42 | 6515bxq6eyw4w8ksoogogo4wo | | |
+----+---------------------+---------------------------+ | |
3 rows in set (0.00 sec) | |
mysqlserver-c> show slave status\G | |
*************************** 1. row *************************** | |
Slave_IO_State: | |
Master_Host: mysqlserver-a | |
Master_User: repluser | |
Master_Port: 3306 | |
Connect_Retry: 60 | |
Master_Log_File: mysqld-bin.000007 | |
Read_Master_Log_Pos: 23133 | |
Relay_Log_File: mysqlserver-c-relay-bin.000002 | |
Relay_Log_Pos: 7832 | |
Relay_Master_Log_File: mysqld-bin.000007 | |
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: 21039 | |
Relay_Log_Space: 10110 | |
Until_Condition: None | |
Until_Log_File: | |
Until_Log_Pos: 0 | |
Master_SSL_Allowed: No | |
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: 1 | |
Master_UUID: 07504317-a5d4-11e3-bc32-123150047aa8 | |
Master_Info_File: /mysql/master.info | |
SQL_Delay: 0 | |
SQL_Remaining_Delay: NULL | |
Slave_SQL_Running_State: | |
Master_Retry_Count: 86400 | |
Master_Bind: | |
Last_IO_Error_Timestamp: | |
Last_SQL_Error_Timestamp: | |
Master_SSL_Crl: | |
Master_SSL_Crlpath: | |
Retrieved_Gtid_Set: | |
Executed_Gtid_Set: | |
Auto_Position: 0 | |
1 row in set (0.00 sec) |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment