ITPub博客

首页 > Linux操作系统 > Linux操作系统 > mysql replication复制错误(zt)

mysql replication复制错误(zt)

原创 Linux操作系统 作者:season0891 时间:2009-02-17 15:08:54 0 删除 编辑
 本文转自:http://www.hiadmin.com/mysql-replication%C3%A5%C2%A4%C2%8D%C3%A5%C2%88%C2%B6%C3%A9%C2%94%C2%99%C3%A8%C2%AF%C2%AF/


Q. No argument was provided to –log-bin, and –log-bin-index was not used; so replication may break when this MySQL server acts as a master and has his hostname changed!! Please use ‘–log-bin=mysql-bin’ to avoid this problem.
A: 在my.cnf 的[mysqld]中加入 log-bin=mysql-bin

Q. Neither –relay-log nor –relay-log-index were used; so replication may break when this MySQL server acts as a slave and has his hostname changed!! Please use ‘–relay-log=mysql-relay-bin’ to avoid this problem.
A: 在my.cnf 的[mysqld]中加入 relay-log=mysql-relay-bin

Q. [ERROR] The slave I/O thread stops because master and slave have equal MySQL server ids; these ids must be different for replication to work (or the –replicate-same-server-id option must be used on slave but this does not always make sense; please check the manual before using it).
A: 在my.cnf 的[mysqld]中加入 replicate-same-server-id

Q.[Note] Slave I/O thread: connected to master ‘test@:3306′,replication started in log ‘FIRST’ at position 4
[ERROR] Error reading packet from server: Access denied; you need the REPLICATION SLAVE privilege for this operation ( server_errno=1227)
A: 可能原来使用过slave链接.需要将mysql库中的master.info删除重新



来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/90618/viewspace-553552/,如需转载,请注明出处,否则将追究法律责任。

上一篇: Oracle写日志问题
请登录后发表评论 登录
全部评论

注册时间:2008-06-10

  • 博文量
    791
  • 访问量
    1933557