摘要: 基本的M-S结构现在master与slave主机数据一致:mysql> select * from t1;+------+| id |+------+| 1 || 2 || 4 |+------+3 rows in set (0.00 sec)我们来模拟故障现象:在master上,通过设置sql_l... 阅读全文
posted @ 2015-07-18 16:49 泽锦 阅读(1259) 评论(0) 推荐(0) 编辑
摘要: 主服务器上的相关命令:show master status;mysql> show master status\G*************************** 1. row *************************** File: host2-bin.00... 阅读全文
posted @ 2015-07-18 16:40 泽锦 阅读(431) 评论(0) 推荐(0) 编辑
摘要: 官网说明:Normally, a slave does not log to its own binary log any updates that are received from a master server. This option tells the slave to log the u... 阅读全文
posted @ 2015-07-18 09:42 泽锦 阅读(3906) 评论(0) 推荐(1) 编辑