- 论坛徽章:
- 0
|
我单向复制已经成功,然后我启动双向复制之后,在从服务器上用show master status;显示为空,而主服务器上的日志为:
081020 21:21:34 [Note] /usr/libexec/mysqld: ready for connections.
Version: '5.0.45-log' socket: '/var/lib/mysql/mysql.sock' port: 3306 Source distribution
081020 21:21:34 [Note] Slave SQL thread initialized, starting replication in log 'FIRST' at position 0, relay log '/var/run/mysqld/mysqld-relay-bin.000005' position: 98
081020 21:21:34 [Note] Slave I/O thread: connected to master 'bakup@192.168.0.85:3306', replication started in log 'FIRST' at position 4
081020 21:21:34 [ERROR] Error reading packet from server: Binary log is not open ( server_errno=1236)
081020 21:21:34 [ERROR] Got fatal error 1236: 'Binary log is not open' from master when reading data from binary log
081020 21:21:34 [Note] Slave I/O thread exiting, read up to log 'FIRST', position 4
主服务器的配置文件:
[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
user=mysql
skip-innodb
server-id=1
log-bin=/var/run/mysqld/mysqld-bin
binlog-do-db=test
#relay-log
master-host=192.168.0.85
master-user=bakup
master-password=000000
master-port=3306
replicate-do-db=sc
master-connect-retry=10
# Default to using old password format for compatibility with mysql 3.x
# clients (those using the mysqlclient10 compatibility package).
sync-binlog=1
old_passwords=1
[mysqld_safe]
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
从服务器的配置文件:
[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
user=mysql
skip-innodb
server-id=2
master-host=192.168.0.86
master-user=bakup
master-password=000000
master-port=3306
master-connect-retry=10
replicate-do-db=test
binlog-do-db=sc
relay-log
log-bin
sync-binlog=1
# Default to using old password format for compatibility with mysql 3.x
# clients (those using the mysqlclient10 compatibility package).
old_passwords=1
[mysqld_safe]
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
也就说从服务器的master功能并没有启动起来!!请高手指点一下 |
|