异地数据库同步的问题
想要实现 A局域网中一台机器PC1 与 B局域网中的一台机器PC2 实时同步。
如今已实现PC1同步PC2,当实现PC2同步PC1时,总是同步不了。
使用show processlist命令,发现PC1始终没有发送二进制文件内容的进程,这是为什么呢?
请教原因!
下面是slave端的错误日志内容:
120810 9:36:01 [Note] Error reading relay log event: slave SQL thread was killed
120810 9:36:37 [Note] Slave SQL thread initialized, starting replication in log 'master_bin.000001' at position 107, relay log '.\slave-relay-bin.000001' position: 4
120810 9:36:38 [Note] Slave I/O thread: connected to master 'pxx@228.92.172.234:3306', replication started in log 'master_bin.000001' at position 107
120810 9:37:07 [ERROR] While trying to obtain the list of slaves from the master '228.92.172.234:3306', user 'pxx' got the following error: 'the master returned an invalid number of fields for SHOW SLAVE HOSTS'
120810 9:37:07 [Note] Slave I/O thread exiting, read up to log 'master_bin.000001', position 107
------解决方案--------------------
5.0和5.5差了2个大版本了,出现同步异常也算是正常情况。
把两端的版本换成一致的吧。
你第二个问题,查看下账户密码,看起来是登陆不上造成的。
------解决方案--------------------
120810 13:51:28 [ERROR] Slave I/O thread: error connecting to master 'pxx@228.92.172.234:3306': Error: 'Access denied for user 'pxx'@'211.6.106.190' (using password: YES)' errno: 1045 retry-time: 60 retries: 86400
检查你的权限。