怎么样去掉master中的slave设置?
MASTER: my.cnf
[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
default-character-set = gb2312
server-id=1
log-bin=/var/lib/mysql/log/bin_log
binlog-do-db=book
binlog-do-db=xtdb
[mysql.server]
user=mysql
basedir=/var/lib
[safe_mysqld]
err-log=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
SLAVE;my.cnf
[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
server-id=2
master-host=192.168.0.101
master-user=backup
master-password=backup
master-port=3306
master-connect-retry=60
replicate-do-db=book
replicate-do-db=xtdb
[mysql.server]
user=mysql
basedir=/var/lib
[safe_mysqld]
err-log=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
这样配置之后,可以实现Replication,但是在master中始终存在一个连接,
mysql> show processlist;
+----+-------------+-----------------+-------+-------------+------+---------------------------------------------+------------------+
| Id | User | Host | db | Command | Time | State | Info |
+----+-------------+-----------------+-------+-------------+------+---------------------------------------------+------------------+
| 1 | system user | none | NULL | Connect | 1018 | connecting to master | NULL |
不停得connection to the master ,由于没有设置,所以按照默认的每60秒连接一次,之后就产生一error,记录到了/var/log/mysqld.log 中:形式如下
031226 13:03:51 Slave thread: error connecting to master: Unknown MySQL Server Host '' (4) (107), retry in 60 sec
请问这个问题该怎么解决啊?