- 论坛徽章:
- 0
|
这段时间在做mysql双机备份,查了网上相关资料!!但是仍然不能备份!相关配置信如下:
在mysql 目录下面已经建立logs目录
master主机:
server-id=1
log-bin=D:/mysql/logs/sync
sql-bin-update-same
binlog-do-db=ScanSealDB
slave主机:
server-id=2
master-host=200.20.7.17
master-user=dbuser
master-password=dbuser
master-port=3306
master-connect-retry=60
replicate-do-db=ScanSealDB
log-slave-updates
当插入数据后备机没有相应增加记录
报错信息如下:
070429 14:05:29 InnoDB: Started
MySql: ready for connections.
Version: '4.0.13-nt' socket: '' port: 3306
070429 14:05:30 Slave I/O thread: error connecting to master 'dbuser@200.20.7.18:3306': Error: 'Can't connect to MySQL server on '200.20.7.18' (10061)' errno: 2003 retry-time: 60 retries: 86400
070429 14:07:32 Slave I/O thread: connected to master 'dbuser@200.20.7.18:3306', replication started in log 'sync.001' at position 79
070429 14:11:36 Slave: received 0 length packet from server, apparent master shutdown:
070429 14:11:36 Slave I/O thread: Failed reading log event, reconnecting to retry, log 'sync.001' position 79
070429 14:11:37 Slave I/O thread: error reconnecting to master 'dbuser@200.20.7.18:3306': Error: 'Can't connect to MySQL server on '200.20.7.18' (10061)' errno: 2003 retry-time: 60 retries: 86400
哪位有相关经验的啊,指示一下: |
|