MySQLのレプリケーションが何故か失敗してしまう。
|
mysql> start slave; |
| # tail -n 20 /var/log/messages 090628 20:36:54 mysqld started 090628 20:36:55 [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=/var/run/mysqld/mysqld-relay-bin’ to avoid this problem. 090628 20:36:55 [ERROR] Failed to open the relay log ‘/var/run/mysqld/mysqld-relay-bin.000002’ (relay_log_pos 429) 090628 20:36:55 [ERROR] Could not find target log during relay log initialization 090628 20:36:55 [ERROR] Failed to initialize the master info structure 090628 20:36:55 [Note] /usr/libexec/mysqld: ready for connections. Version: ‘5.0.45’ socket: ‘/var/lib/mysql/mysql.sock’ port: 3306 Source distribution |
スレーブサーバでマスターサーバのIPアドレス、ユーザ名等から再設定しても失敗したが、色々と調べたところリセットするだけで復旧するらしい。
| mysql> reset slave; |
実際、リセットするだけで復旧。悩み抜いた1時間は一体…。