MySQL Replication :: Recovering from corrupted relay logs

Recently, due to a unknown problem, mysql replication in our server was stopped. Checking the log, we found the following error 130225 21:17:32 [ERROR] Error in Log_event::read_log_event(): ‘read error’, data_len: 261, event_type: 2 130225 21:17:32 [ERROR] Error reading relay log event: slave SQL thread aborted because of I/O error 130225 […]

MySQL Replication :: Migrate master database to another server/host

In a MySQL Replication based┬ásystem, How to┬ámigrate a master database to another server/host?┬áScenario in short goes: dump out master databases, import data on the new master server and point slave to the new master server. If you follow this simple steps, master migration should proceed without problems. Export databases from […]