Skip to content

Instantly share code, notes, and snippets.

@s-tajima

s-tajima/command_log.txt

Created March 11, 2014 10:25
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save s-tajima/9483097 to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save s-tajima/9483097 to your computer and use it in GitHub Desktop.
Download ZIP
Command log of test for MHA failover.
Raw
command_log.txt
= 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