DB更改logbin目录后,DR会不正常,需要重新change master

080204 16:02:24  Error reading packet from server: Could not find first log file name in binary log index file (server_errno=1236)
080204 16:02:24  Got fatal error 1236: 'Could not find first log file name in binary log index file' from master when reading data from binary log
080204 16:02:24  Slave I/O thread exiting, read up to log 'DB9_ph-bin.001', position 64382992
080204 16:08:17  Slave I/O thread: connected to master 'repl@172.17.12.188:3306',  replication started in log 'DB9_ph-bin.003' at position 79

我今天更改一台业务DB的logbin目录,更改后DR报上边的错误,再Index找不到那个logbin文件。

原来是因为我将原来log目录下的binlog移动到/db/logbin下边,而之前DR读到的DB 的 logbin文件还是第一个,然后引起上边报错,这个应该是因为绝对路径的问题,后来重新做了change master 更改master_log_file和master_log_pos,就好了

[root@DB9_ph logbin]# more DB9_ph-bin.index
/log/DB9_ph-bin.001
/db/logbin/DB9_ph-bin.002
/db/logbin/DB9_ph-bin.003

请使用浏览器的分享功能分享到微信等