DB更改logbin目錄後,DR會不正常,需要重新change master

bulletming發表於2019-01-26

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 ,  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

來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/82392/viewspace-168342/,如需轉載,請註明出處,否則將追究法律責任。

相關文章