MySQL5.6 Replication主从复制(读写分离) 配置完整版(二)

2014-11-24 17:18:23 · 作者: · 浏览: 1
show slave status \G


*************************** 1. row ***************************


Slave_IO_State: Waiting for master to send event


Master_Host: 192.168.1.100


Master_User: repl


Master_Port: 3306


Connect_Retry: 60


Master_Log_File: mysqlmaster-bin.000004


Read_Master_Log_Pos: 327


Relay_Log_File: slave-relay-bin.000002


Relay_Log_Pos: 289


Relay_Master_Log_File: mysqlmaster-bin.000004


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: 327


Relay_Log_Space: 462


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: 2e5e1b22-f0a9-11e3-bbac-000c297799e0


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)



如果Slave_IO_Running和Slave_SQL_Running两项都为yes,就表示主从复制配置成功了.


下面可以开始测试配置是否成功了,首先在主数据库的test数据库中新建一张表,然后插入几条数据,然后到从数据库看看是否同步过来了。


注意:当从数据库有大量的查询时,可以暂时将从数据库的复制线程关闭掉,等查询量降下来了,再打开,这样也不会丢失数据。