29 January 2011

Troubleshooting mysql replication

PROTIP: When you're stuck on "Waiting to reconnect after a failed master event read" or some other equally unhelpful error message, start the slave mysqld on the console. You'll get much more useful error mesages that Ubuntu appears to be to be filtering from syslog, like:

110130 0:41:25 [ERROR] Error reading packet from server: Access denied; you need the REPLICATION SLAVE privilege for this operation ( server_errno=1227)

PROTIP 2: Note that the replication will start as soon as you fix the problem, so you might want to run it using 'screen' so you can wait for an opportune time to kill the slave mysqld and restart it using /etc/init.d/mysql start or start mysql or whathaveyou.

No comments:

Post a Comment

About Me

blog at barillari dot org Older posts at http://barillari.org/blog