mysql 主从复制报错，不知道是什么原因
2013-09-22 15:51:09 2150 [ERROR] Error reading packet from server: Lost connection to MySQL server during query ( server_errno=2013)
2013-09-22 15:51:09 2150 [Note] Slave I/O thread killed while reading event
2013-09-22 15:51:09 2150 [Note] Slave I/O thread exiting, read up to log 'mysql-bin.000011', position 1991
2013-09-22 15:51:15 2150 [Warning] Storing MySQL user name or password information in the master.info repository is not secure and is therefore not recommended. Please see the MySQL Manual for more about this issue and possible alternatives.
2013-09-22 15:51:15 2150 [Note] Slave I/O thread: connected to master 'master@192.168.254.46:3306',replication started in log 'mysql-bin.000011' at position 1991
2013-09-22 15:51:15 2150 [Warning] Slave SQL: If a crash happens this configuration does not guarantee that the relay log info will be consistent, Error_code: 0
2013-09-22 15:51:15 2150 [Note] Slave SQL thread initialized, starting replication in log 'mysql-bin.000011' at position 1991, relay log './wordpress-relay-bin.000002' position: 1944
2013-09-22 16:09:58 2150 [Note] Slave: received end packet from server, apparent master shutdown:
2013-09-22 16:09:58 2150 [Note] Slave I/O thread: Failed reading log event, reconnecting to retry, log 'mysql-bin.000011' at position 2174
2013-09-22 16:09:58 2150 [Warning] Storing MySQL user name or password information in the master.info repository is not secure and is therefore not recommended. Please see the MySQL Manual for more about this issue and possible alternatives.
2013-09-22 16:09:58 2150 [ERROR] Slave I/O: error reconnecting to master 'master@192.168.254.46:3306' - retry-time: 60 retries: 1, Error_code: 2003
3 个解决方案
#1
这两台机器之间丢包很严重吗
#2
先查查两台数据库的同步状态
#3
1、网络不通
2、密码不对
.3、pos不对
2、密码不对
.3、pos不对
智能推荐
注意！
本站转载的文章为个人学习借鉴使用，本站对版权不负任何法律责任。如果侵犯了您的隐私权益，请联系我们删除。