摘要:
基本的M-S结构现在master与slave主机数据一致:mysql> select * from t1;+------+| id |+------+| 1 || 2 || 4 |+------+3 rows in set (0.00 sec)我们来模拟故障现象:在master上,通过设置sql_l... 阅读全文
摘要:
主服务器上的相关命令:show master status;mysql> show master status\G*************************** 1. row *************************** File: host2-bin.00... 阅读全文
摘要:
官网说明: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... 阅读全文