hostname degisikliginde slave calismiyor (mysql master / slave)

September 14th, 2009

bugün yeni bir sugarcrm kurarken fark ettimki slave durmus calismiyor hemen loglara baktim ve bu hatalari gördüm:

PLAIN TEXT

CODE:

090914 16:14:33 [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.
090914 16:14:33 [ERROR] Failed to open the relay log '/var/run/mysqld/mysqld-relay-bin.000492' (relay_log_pos 35994)
090914 16:14:33 [ERROR] Could not find target log during relay log initialization
090914 16:14:33 [ERROR] Failed to initialize the master info structure

hata slave in hostname i degistigi ve yeniden baslatildigi icin geliyordu,

slave i durdurup yeniden baslatmayi denedim ama bu hata ile karsilastim:

PLAIN TEXT

CODE:

ERROR 1201 (HY000): Could not initialize master info structure; more error messages can be found in the MySQL error log

biraz google de aradikdan sonra bu yaziyi buldum:

kisaca yapilanlari anlatmaya caliscagim, öncelikle slave i durduralim:

PLAIN TEXT

CODE:

mysql> stop Slave;

ardindan

PLAIN TEXT

CODE:

mysql> SHOW SLAVE STATUS\G
yazip su bes satira dikkat ediyoruz
*************************** 1. row ***************************
Master_Host: localhost
Master_User: root
Master_Port: 3306
Relay_Master_Log_File: gbichot-bin.005
Exec_Master_Log_Pos: 79

Simdi slave i resetleyip, kaldigi yerden devam etmesini söyliyecegiz.

PLAIN TEXT

CODE:

mysql> RESET SLAVE;
mysql> CHANGE MASTER TO MASTER_HOST="localhost", MASTER_USER="root", MASTER_PASSWORD="test", MASTER_LOG_FILE="gbichot-bin.005", MASTER_LOG_POS=79;

*ikinci satiri yukardaki kendi verilerinizle degistirin (sifrenizi /etc/my.cnf de bula bilirsiniz)

simdi slave i yeniden baslatalim:

PLAIN TEXT

CODE:

mysql> START SLAVE;
ardindan
mysql> SHOW SLAVE STATUS\G
*************************** 1. row ***************************
Slave_IO_Running: Yes
Slave_SQL_Running: Yes
Seconds_Behind_Master: 8

ve bu üc satira dikkat ediyoruz, Slave* ile basliyan satirlarin ikiside Yes olmali,
Seconds_Behind_Master: 0 yazdigi zaman master slave le ayni demek, eger sizde cok büyük bir sayi yaziyorsa zamanla o gecicekdir, sifir olana kadar

PLAIN TEXT

CODE: