mysql 主备同步报错

litianshu

Could not initialize master info structure; more error messages can be found in the MySQL error log

litianshu

日志 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=backup-relay-bin' to avoid this problem

litianshu

Error counting relay log space
091125 17:05:08 [ERROR] Error reading master configuration
091125 17:10:24 [ERROR] log ./backup-relay-bin.000012 listed in the index, but failed to stat
091125 17:10:24 [ERROR] Error counting relay log space
091125 17:23:24 [ERROR] Error reading master configuration
091125 18:07:52 [ERROR] Error reading master configuration
091125 18:08:18 [ERROR] Error reading master configuration
091125 18:11:15 [ERROR] Error reading master configuration
091126 11:05:35 [Note] /usr/local/mysql/libexec/mysqld: Normal shutdown

091126 11:05:35 [Note] Event Scheduler: Purging the queue. 0 events
091126 11:05:37 [Note] /usr/local/mysql/libexec/mysqld: Shutdown complete

091126 11:05:37 mysqld_safe mysqld from pid file /usr/local/mysql/var/backup.pid ended
091126 11:05:58 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/var
091126 11:05:58 [Note] Event Scheduler: Loaded 0 events
091126 11:05:58 [Note] /usr/local/mysql/libexec/mysqld: ready for connections.
Version: '5.1.34-log'  socket: '/tmp/mysql.sock'  port: 3306  Source distribution
091126 11:07:04 [Warning] 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=backup-relay-bin' to avoid this problem.
091126 11:07:04 [ERROR] Failed to open log (file './backup-relay-bin.000010', errno 2)
091126 11:07:04 [ERROR] Failed to open the relay log 'FIRST' (relay_log_pos 4)
091126 11:07:04 [ERROR] Could not open log file
091126 11:09:51 [ERROR] Error reading master configuration
091126 11:25:29 [ERROR] Failed to open log (file './backup-relay-bin.000010', errno 2)
091126 11:25:29 [ERROR] Failed to open the relay log 'FIRST' (relay_log_pos 4)
091126 11:25:29 [ERROR] Could not open log file
091126 11:51:29 [Note] /usr/local/mysql/libexec/mysqld: Normal shutdown

091126 11:51:29 [Note] Event Scheduler: Purging the queue. 0 events
091126 11:51:31 [Note] /usr/local/mysql/libexec/mysqld: Shutdown complete

091126 11:51:31 mysqld_safe mysqld from pid file /usr/local/mysql/var/backup.pid ended
091126 11:51:48 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/var
091126 11:51:48 [Note] Event Scheduler: Loaded 0 events
091126 11:51:48 [Note] /usr/local/mysql/libexec/mysqld: ready for connections.
Version: '5.1.34-log'  socket: '/tmp/mysql.sock'  port: 3306  Source distribution
091126 12:02:30 [Warning] 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=backup-relay-bin' to avoid this problem.
091126 12:02:30 [ERROR] Error reading slave log configuration