MYSQL主从复制配置遇到的问题
在进行配置从服务器时遇到的错误。mysql> change master to master_host='192.168.136.129',master_user='repl',master_password='123456',master_log_file='mysql-bin.000003',master_log_pos=2610;
ERROR 1201 (HY000): Could not initialize master info structure; more error messages can be found in the MySQL error log
查看日志
# ls -a
. ib_logfile0relay-log.info slave-relay-bin.000002slave-relay-bin.000006slave-relay-bin.000010slave-relay-bin.000014
.. ib_logfile1slave.err slave-relay-bin.000003slave-relay-bin.000007slave-relay-bin.000011slave-relay-bin.index
discuz master.infoslave.pid slave-relay-bin.000004slave-relay-bin.000008slave-relay-bin.000012test
ibdata1mysql slave-relay-bin.000001slave-relay-bin.000005slave-relay-bin.000009slave-relay-bin.000013
# tail /data/mysql/slave.err
Version: '5.1.40'socket: '/tmp/mysql.sock'port: 3306MySQL Community Server (GPL)
141103 15:42:29 mysqld_safe A mysqld process already exists
141103 16:48:32 Failed to open the>
141103 16:48:32 Could not find target log during>
141103 16:49:51 Failed to open the>
141103 16:49:51 Could not find target log during>
141103 16:49:52 Failed to open the>
141103 16:49:52 Could not find target log during>
141103 16:49:53 Failed to open the>
141103 16:49:53 Could not find target log during> 解决：
由于之前配置过，生成了一些*relay*，使得再次配置无法生成，删除掉之前生成的文件就可以。
# rm *bin*
rm：是否删除 一般文件 “slave-relay-bin.000001”? y
rm：是否删除 一般文件 “slave-relay-bin.000002”? y
rm：是否删除 一般文件 “slave-relay-bin.000003”? y
rm：是否删除 一般文件 “slave-relay-bin.000004”? y
rm：是否删除 一般文件 “slave-relay-bin.000005”? y
rm：是否删除 一般文件 “slave-relay-bin.000006”? y
rm：是否删除 一般文件 “slave-relay-bin.000007”? y
rm：是否删除 一般文件 “slave-relay-bin.000008”? y
rm：是否删除 一般文件 “slave-relay-bin.000009”? y
rm：是否删除 一般文件 “slave-relay-bin.000010”? y
rm：是否删除 一般文件 “slave-relay-bin.000011”? y
rm：是否删除 一般文件 “slave-relay-bin.000012”? y
rm：是否删除 一般文件 “slave-relay-bin.000013”? y
rm：是否删除 一般文件 “slave-relay-bin.000014”? y
rm：是否删除 一般文件 “slave-relay-bin.index”? y
# ls -a
...discuzibdata1ib_logfile0ib_logfile1master.infomysqlrelay-log.infoslave.errslave.pidtest
# rm> rm：是否删除 一般文件 “relay-log.info”? y
# rm master.info
rm：是否删除 一般文件 “master.info”? y
# ls -a
...discuzibdata1ib_logfile0ib_logfile1mysqlslave.errslave.pidtest
# /usr/local/mysql/bin/mysql -uroot
Welcome to the MySQL monitor.Commands end with ; or \g.
Your MySQL connection> Server version: 5.1.40 MySQL Community Server (GPL)
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
mysql> slave stop;
Query OK, 0 rows affected, 1 warning (0.00 sec)
mysql> change master to master_host='192.168.136.129',master_user='repl',master_password='123456',master_log_file='mysql-bin.000003',master_log_pos=2610;
Query OK, 0 rows affected (0.06 sec)
mysql> slave start;
Query OK, 0 rows affected (0.03 sec)
不再报错，配置成功！
另计，发现master.info 文件里面记录的是自己配置的选项。
页:
[1]