root@DBA:\/home\/shiv\/sakila# vi \/etc\/mysql\/my.cnf<\/pre>\n[mysqld]\r\n\r\nserver-id=901\r\n\r\nlog-bin = mysql-bin\r\n\r\nbind-address = 192.168.56.23\r\n\r\nbinlog-do-db = sakila\r\n<\/pre>\nRestart MySQL on both instances (192.168.56.13 and 192.168.56.23)<\/p>\n
We need to create a pseudo-user that will be used for replicating data between our two VPS (192.168.56.13 and 192.168.56.23). The examples in this article will assume that you name this user “repl” and password used here is “repl” .<\/p>\n
User created in 192.168.56.13\u00a0<\/strong><\/p>\nmysql> create user 'repl'@'192.168.56.23' identified by 'repl' ;\r\n\r\nQuery OK, 0 rows affected (0.01 sec)\r\n\r\nmysql> grant replication slave on *.* to 'repl'@'192.168.56.23';\r\n\r\nQuery OK, 0 rows affected (0.01 sec)\r\n\r\nmysql> flush privileges;\u00a0\r\n\r\nQuery OK, 0 rows affected (0.00 sec)\r\n<\/pre>\nUser created in 192.168.56.23<\/strong><\/p>\nmysql> create user 'repl'@'192.168.56.13' identified by 'repl';\r\n\r\nQuery OK, 0 rows affected (0.01 sec)\r\n\r\nmysql> grant replication slave on *.* to 'repl'@'192.168.56.13';\r\n\r\nQuery OK, 0 rows affected (0.01 sec)\r\n\r\nmysql> flush privileges;\u00a0\r\n\r\nQuery OK, 0 rows affected (0.01 sec)<\/pre>\nThe last thing we have to do before we complete the mysql master-master replication is to make note of the master log file and position. We need this data to hook both MySQL instances on each other, We are doing an Master-Master replication so we need details of both the MySQL instances, 192.168.56.13 and 192.168.56.23<\/p>\n
Master log file and position of 192.168.56.13\u00a0<\/strong><\/p>\nmysql> show master status;\r\n\r\n+------------------+----------+--------------+------------------+-------------------+\r\n\r\n| File \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 | Position | Binlog_Do_DB | Binlog_Ignore_DB | Executed_Gtid_Set |\r\n\r\n+------------------+----------+--------------+------------------+-------------------+\r\n\r\n| mysql-bin.000002 |\u00a0 \u00a0 \u00a0 154 | sakila \u00a0 \u00a0 \u00a0 |\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 | \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 |\r\n\r\n+------------------+----------+--------------+------------------+-------------------+\r\n\r\n1 row in set (0.00 sec)<\/pre>\nMaster log file and position of 192.168.56.23<\/strong><\/p>\nmysql> show master status;\r\n\r\n+------------------+----------+--------------+------------------+-------------------+\r\n\r\n| File \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 | Position | Binlog_Do_DB | Binlog_Ignore_DB | Executed_Gtid_Set |\r\n\r\n+------------------+----------+--------------+------------------+-------------------+\r\n\r\n| mysql-bin.000001 |\u00a0 \u00a0 \u00a0 771 | sakila \u00a0 \u00a0 \u00a0 |\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 | \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 |\r\n\r\n+------------------+----------+--------------+------------------+-------------------+\r\n\r\n1 row in set (0.00 sec)<\/pre>\nCompleting MySQL Master-Master replication\u00a0<\/strong><\/p>\nThe following steps will start replicating data between both MySQL instances (192.168.56.13 and 192.168.56.23)<\/p>\n
Run this command on MySQL instance in 192.168.56.13 (confirm replication is successful and no error is reported with command “show slave status\\G” command)<\/strong><\/p>\nmysql> stop slave;\r\n\r\nmysql> change master to\u00a0\r\n\r\n\u00a0 \u00a0 -> MASTER_HOST='192.168.56.23',\r\n\r\n\u00a0 \u00a0 -> MASTER_USER='repl',\u00a0\r\n\r\n\u00a0 \u00a0 -> MASTER_PASSWORD='repl',\r\n\r\n\u00a0 \u00a0 -> MASTER_LOG_FILE='mysql-bin.000001',\r\n\r\n\u00a0 \u00a0 -> MASTER_LOG_POS=\u00a0 771;\r\n\r\nQuery OK, 0 rows affected, 2 warnings (0.04 sec)\r\n\r\nmysql> start slave;\r\n\r\nQuery OK, 0 rows affected (0.02 sec)\r\n\u00a0\r\nmysql> show slave status\\G;\r\n\r\n*************************** 1. row ***************************\r\n\r\n\u00a0\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 Slave_IO_State: Waiting for master to send event\r\n\r\n\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 Master_Host: 192.168.56.23\r\n\r\n\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 Master_User: repl\r\n\r\n\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 Master_Port: 3306\r\n\r\n\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 Connect_Retry: 60\r\n\r\n\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 Master_Log_File: mysql-bin.000001\r\n\r\n\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 Read_Master_Log_Pos: 771\r\n\r\n\u00a0\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 Relay_Log_File: DA-relay-bin.000002\r\n\r\n\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 Relay_Log_Pos: 320\r\n\r\n\u00a0 \u00a0 \u00a0 \u00a0 Relay_Master_Log_File: mysql-bin.000001\r\n\r\n\u00a0\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 Slave_IO_Running: Yes\r\n\r\n\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 Slave_SQL_Running: Yes\r\n\r\n\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 Replicate_Do_DB:\u00a0\r\n\r\n\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 Replicate_Ignore_DB:\u00a0\r\n\r\n\u00a0\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 Replicate_Do_Table:\u00a0\r\n\r\n\u00a0\u00a0 \u00a0 \u00a0 Replicate_Ignore_Table:\u00a0\r\n\r\n\u00a0 \u00a0 \u00a0 Replicate_Wild_Do_Table:\u00a0\r\n\r\n\u00a0 Replicate_Wild_Ignore_Table:\u00a0\r\n\r\n\u00a0\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 Last_Errno: 0\r\n\r\n\u00a0\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 Last_Error:\u00a0\r\n\r\n\u00a0\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 Skip_Counter: 0\r\n\r\n\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 Exec_Master_Log_Pos: 771\r\n\r\n\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 Relay_Log_Space: 524\r\n\r\n\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 Until_Condition: None\r\n\r\n\u00a0\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 Until_Log_File:\u00a0\r\n\r\n\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 Until_Log_Pos: 0\r\n\r\n\u00a0\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 Master_SSL_Allowed: No\r\n\r\n\u00a0\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 Master_SSL_CA_File:\u00a0\r\n\r\n\u00a0\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 Master_SSL_CA_Path:\u00a0\r\n\r\n\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 Master_SSL_Cert:\u00a0\r\n\r\n\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 Master_SSL_Cipher:\u00a0\r\n\r\n\u00a0\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 Master_SSL_Key:\u00a0\r\n\r\n\u00a0 \u00a0 \u00a0 \u00a0 Seconds_Behind_Master: 0\r\n\r\nMaster_SSL_Verify_Server_Cert: No\r\n\r\n\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 Last_IO_Errno: 0\r\n\r\n\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 Last_IO_Error:\u00a0\r\n\r\n\u00a0\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 Last_SQL_Errno: 0\r\n\r\n\u00a0\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 Last_SQL_Error:\u00a0\r\n\r\n\u00a0 Replicate_Ignore_Server_Ids:\u00a0\r\n\r\n\u00a0\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 Master_Server_Id: 901\r\n\r\n\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 Master_UUID: cd1eedbe-fed3-11e7-a414-08002720a95a\r\n\r\n\u00a0\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 Master_Info_File: \/var\/lib\/mysql\/master.info\r\n\r\n\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 SQL_Delay: 0\r\n\r\n\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 SQL_Remaining_Delay: NULL\r\n\r\n\u00a0 \u00a0 \u00a0 Slave_SQL_Running_State: Slave has read all relay log; waiting for more updates\r\n\r\n\u00a0\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 Master_Retry_Count: 86400\r\n\r\n\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 Master_Bind:\u00a0\r\n\r\n\u00a0 \u00a0 \u00a0 Last_IO_Error_Timestamp:\u00a0\r\n\r\n\u00a0\u00a0 \u00a0 Last_SQL_Error_Timestamp:\u00a0\r\n\r\n\u00a0\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 Master_SSL_Crl:\u00a0\r\n\r\n\u00a0\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 Master_SSL_Crlpath:\u00a0\r\n\r\n\u00a0\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 Retrieved_Gtid_Set:\u00a0\r\n\r\n\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 Executed_Gtid_Set:\u00a0\r\n\r\n\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 Auto_Position: 0\r\n\r\n\u00a0\u00a0 \u00a0 \u00a0 \u00a0 Replicate_Rewrite_DB:\u00a0\r\n\r\n\u00a0\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 Channel_Name:\u00a0\r\n\r\n\u00a0\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 Master_TLS_Version:\u00a0\r\n\r\n1 row in set (0.00 sec)\r\n\r\nERROR:\u00a0\r\n\r\nNo query specified\r\n<\/pre>\nRun this command on MySQL instance in 192.168.56.23\u00a0(confirm replication is successful and no error is reported with command “show slave status\\G” command)<\/strong><\/p>\nmysql> stop slave;\r\n\r\nQuery OK, 0 rows affected (0.01 sec)\r\n\r\nmysql> change master to\u00a0\r\n\r\n\u00a0 \u00a0 ->\u00a0 MASTER_HOST='192.168.56.13',\u00a0\r\n\r\n\u00a0 \u00a0 -> MASTER_USER='repl',\r\n\r\n\u00a0 \u00a0 -> MASTER_PASSWORD='repl',\r\n\r\n\u00a0 \u00a0 ->\u00a0 MASTER_LOG_FILE='mysql-bin.000002',\r\n\r\n\u00a0 \u00a0 -> MASTER_LOG_POS=\u00a0 154;\r\n\r\nQuery OK, 0 rows affected, 2 warnings (0.01 sec)\r\n\r\nmysql> start slave;\r\n\r\nQuery OK, 0 rows affected (0.01 sec)\r\n\r\nmysql> show slave status\\G;\r\n\r\n*************************** 1. row ***************************\r\n\r\n\u00a0\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 Slave_IO_State: Waiting for master to send event\r\n\r\n\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 Master_Host: 192.168.56.13\r\n\r\n\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 Master_User: repl\r\n\r\n\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 Master_Port: 3306\r\n\r\n\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 Connect_Retry: 60\r\n\r\n\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 Master_Log_File: mysql-bin.000002\r\n\r\n\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 Read_Master_Log_Pos: 154\r\n\r\n\u00a0\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 Relay_Log_File: DBA-relay-bin.000002\r\n\r\n\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 Relay_Log_Pos: 320\r\n\r\n\u00a0 \u00a0 \u00a0 \u00a0 Relay_Master_Log_File: mysql-bin.000002\r\n\r\n\u00a0\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 Slave_IO_Running: Yes\r\n\r\n\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 Slave_SQL_Running: Yes\r\n\r\n\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 Replicate_Do_DB:\u00a0\r\n\r\n\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 Replicate_Ignore_DB:\u00a0\r\n\r\n\u00a0\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 Replicate_Do_Table:\u00a0\r\n\r\n\u00a0\u00a0 \u00a0 \u00a0 Replicate_Ignore_Table:\u00a0\r\n\r\n\u00a0 \u00a0 \u00a0 Replicate_Wild_Do_Table:\u00a0\r\n\r\n\u00a0 Replicate_Wild_Ignore_Table:\u00a0\r\n\r\n\u00a0\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 Last_Errno: 0\r\n\r\n\u00a0\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 Last_Error:\u00a0\r\n\r\n\u00a0\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 Skip_Counter: 0\r\n\r\n\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 Exec_Master_Log_Pos: 154\r\n\r\n\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 Relay_Log_Space: 525\r\n\r\n\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 Until_Condition: None\r\n\r\n\u00a0\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 Until_Log_File:\u00a0\r\n\r\n\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 Until_Log_Pos: 0\r\n\r\n\u00a0\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 Master_SSL_Allowed: No\r\n\r\n\u00a0\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 Master_SSL_CA_File:\u00a0\r\n\r\n\u00a0\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 Master_SSL_CA_Path:\u00a0\r\n\r\n\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 Master_SSL_Cert:\u00a0\r\n\r\n\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 Master_SSL_Cipher:\u00a0\r\n\r\n\u00a0\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 Master_SSL_Key:\u00a0\r\n\r\n\u00a0 \u00a0 \u00a0 \u00a0 Seconds_Behind_Master: 0\r\n\r\nMaster_SSL_Verify_Server_Cert: No\r\n\r\n\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 Last_IO_Errno: 0\r\n\r\n\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 Last_IO_Error:\u00a0\r\n\r\n\u00a0\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 Last_SQL_Errno: 0\r\n\r\n\u00a0\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 Last_SQL_Error:\u00a0\r\n\r\n\u00a0 Replicate_Ignore_Server_Ids:\u00a0\r\n\r\n\u00a0\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 Master_Server_Id: 900\r\n\r\n\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 Master_UUID: a1546678-febf-11e7-9618-080027275ccc\r\n\r\n\u00a0\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 Master_Info_File: \/var\/lib\/mysql\/master.info\r\n\r\n\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 SQL_Delay: 0\r\n\r\n\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 SQL_Remaining_Delay: NULL\r\n\r\n\u00a0 \u00a0 \u00a0 Slave_SQL_Running_State: Slave has read all relay log; waiting for more updates\r\n\r\n\u00a0\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 Master_Retry_Count: 86400\r\n\r\n\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 Master_Bind:\u00a0\r\n\r\n\u00a0 \u00a0 \u00a0 Last_IO_Error_Timestamp:\u00a0\r\n\r\n\u00a0\u00a0 \u00a0 Last_SQL_Error_Timestamp:\u00a0\r\n\r\n\u00a0\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 Master_SSL_Crl:\u00a0\r\n\r\n\u00a0\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 Master_SSL_Crlpath:\u00a0\r\n\r\n\u00a0\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 Retrieved_Gtid_Set:\u00a0\r\n\r\n\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 Executed_Gtid_Set:\u00a0\r\n\r\n\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 Auto_Position: 0\r\n\r\n\u00a0\u00a0 \u00a0 \u00a0 \u00a0 Replicate_Rewrite_DB:\u00a0\r\n\r\n\u00a0\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 Channel_Name:\u00a0\r\n\r\n\u00a0\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 Master_TLS_Version:\u00a0\r\n\r\n1 row in set (0.00 sec)\r\n\r\nERROR:\u00a0\r\n\r\nNo query specified\r\n<\/pre>\nTest MySQL Master-Master replication<\/p>\n
create this table in 192.168.56.13 \u00a0MySQL instance<\/strong><\/p>\nmysql> create table tab1 (\r\n\r\n\u00a0 \u00a0 -> col1 \u00a0 integer);\r\n\r\nQuery OK, 0 rows affected (0.02 sec)<\/pre>\nconfirm this table replicated to the MySQL instance in 192.168.56.23 successfully<\/p>\n
mysql> show tables like 'tab1%';\r\n\r\n+--------------------------+\r\n\r\n| Tables_in_sakila (tab1%) |\r\n\r\n+--------------------------+\r\n\r\n| tab1 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 |\r\n\r\n+--------------------------+\r\n\r\n1 row in set (0.00 sec)<\/pre>\ncreate this table in 192.168.56.23 MySQL instance<\/strong><\/p>\nmysql> create table tab11\r\n\r\n -> ( col11 integer);\r\n\r\nQuery OK, 0 rows affected (0.02 sec)\r\n<\/pre>\nconfirm this table replicated to the MySQL instance in 192.168.56.13 successfully<\/p>\n
mysql> show tables like 'tab11%';\r\n\r\n+---------------------------+\r\n\r\n| Tables_in_sakila (tab11%) |\r\n\r\n+---------------------------+\r\n\r\n| tab11 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 |\r\n\r\n+---------------------------+\r\n\r\n1 row in set (0.00 sec)<\/pre>\n