How to fix problems in the replications dataservers infrastructure
When you get an error like this:
[ERROR] Got fatal error 1236: ‘Could not find first log file name in binary log index file’ from master when reading data from binary log[Note] Slave I/O thread exiting, read up to log ‘mysql_binary_log.000004’, position 465
The solutions is simple…let’s see:
In server1:
FLUSH TABLES WITH READ LOCK;
SHOW MASTER STATUS; (remember the result)
In other console:
mysqldump -u root -p –extended-insert –all-databases > /tmp/backup.sql
and again in the MySQL promt:
unlock tables
On the server2 we copy the backup, and :
stop slave ;
mysql -u root -p-h localhost< backup.sql CHANGE MASTER TO MASTER_HOST='ip_server1', MASTER_USER='replica_user', MASTER_PASSWORD='password_replica_user', MASTER_LOG_FILE='log_file_showned_in_the_status_of_the_server1', MASTER_LOG_POS='position_showned_in_the_status_of_the_server1'; start slave; And the problem is solved. You need to to the same but in viceversa. References: http://forums.mysql.com/read.php?26,223923,224042#msg-224042
Cloud ComputingMay 19th, 20130 comments
-
Categories
-
Latest Posts