Q:一开始是因为

mysql Got a packet bigger than 'slave_max_allowed_packet' bytes错误

A:改大 max_allowed_packet
1: set global max_allowed_packet=16384000;(16M)
2:vi /etc/my.cnf 修改:max_allowed_packet=16M
Q:start slave后,show slave status\G,
  Slave_IO_Running: Connecting(一直卡在这)
A:查看mysql错误日志找到出错的地方
再 change master to master_host='221.4.223.112', master_user='sync_user', master_password='mysql2012',MASTER_LOG_FILE='mysql-bin.000185', MASTER_LOG_POS=4174698;
在start slave,show slave status\G;显示正常
Logo

更多推荐