两台机子做复制,在slave server中,IO和SQL进程都显示正在运行。但是实际上在master server 修改数据后没有复制到slave server中,下面是*.ver中的log:091013 15:38:44 [ERROR] Error reading packet from server: Lost connection to MySQL server during query ( server_errno=2013)
091013 15:38:44 [Note] Slave I/O thread killed while reading event
091013 15:38:44 [Note] Slave I/O thread exiting, read up to log 'mysql-bin-2kgames.000015', position 927660
091013 15:38:44 [Note] Error reading relay log event: slave SQL thread was killed
091013 15:39:42 [Note] Slave SQL thread initialized, starting replication in log 'mysql-bin-2kgames.000015' at position 927660, relay log '.\boon-relay-bin.000001' position: 4
091013 15:39:43 [Note] Slave I/O thread: connected to master '[email protected]:3306',replication started in log 'mysql-bin-2kgames.000015' at position 927660请大家帮帮忙。
091013 15:38:44 [Note] Slave I/O thread killed while reading event
091013 15:38:44 [Note] Slave I/O thread exiting, read up to log 'mysql-bin-2kgames.000015', position 927660
091013 15:38:44 [Note] Error reading relay log event: slave SQL thread was killed
091013 15:39:42 [Note] Slave SQL thread initialized, starting replication in log 'mysql-bin-2kgames.000015' at position 927660, relay log '.\boon-relay-bin.000001' position: 4
091013 15:39:43 [Note] Slave I/O thread: connected to master '[email protected]:3306',replication started in log 'mysql-bin-2kgames.000015' at position 927660请大家帮帮忙。
select version();最好贴出你的my.ini(windows下)或my.cnf(linux下)还有,你的这个复制以前是正常运行的吗?上面的故障是不是运行过程中出现的?
貌似M-S两台数据库通信有问题
-------------------------------
server-id=1
binlog_format=mixed
log-bin=mysql-bin.log
binlog-do-db=testwait_timeout=604800interactive_timeout=604800
max_allowed_packet=32Mslave server MySQL 6.0.5 my.ini
------------------------------------
server-id=6
replicate-do-table='test.ta'
replicate-do-table='test.tb'
replicate-do-table='test.tc'其它都是默认的
估计这个是master与slave不同版本引起的,你试下换成master与slave同一版本试看一下
如果可以正常操作的话,那你再试下统一master-slave的mysql版本试下吧