Mysql
設置 MySQL 主從複製
我正在嘗試在 MySQL 5.6 上設置主從複製。
當我在主伺服器中更新我的數據庫時,更改不會反映在從伺服器上。當我在從站上顯示程序列表時,它會顯示以下消息:
mysql> show processlist; +----+-------------+-----------+------+---------+------+-----------------------------------------------------------------------------+------------------+ | Id | User | Host | db | Command | Time | State | Info | +----+-------------+-----------+------+---------+------+-----------------------------------------------------------------------------+------------------+ | 1 | system user | | NULL | Connect | 6440 | Slave has read all relay log; waiting for the slave I/O thread to update it | NULL | | 2 | system user | | NULL | Connect | 5730 | Waiting for master to send event | NULL | | 42 | root | localhost | NULL | Query | 0 | NULL | show processlist | +----+-------------+-----------+------+---------+------+-----------------------------------------------------------------------------+-------------
有什麼建議?
如果需要 查看,請參閱MySQL 文件或逐步複製設置部落格。
如果這些沒有幫助,請分享
show slave status\G
(因為它看起來是連接的)的輸出以及my.cnf
主/從的輸出。主要是您需要擔心伺服器 ID、複製過濾器(複製到數據庫/表等)
在配置其主伺服器時,此命令可能無法在從伺服器上正常執行
CHANGE MASTER TO MASTER_HOST='xx.xx.xx.xx', MASTER_USER='replication', MASTER_PASSWORD='xxxxxxxxxxx', MASTER_PORT=3306, MASTER_LOG_FILE='mysql-bin.00xxxx', MASTER_LOG_POS=xxx