Why MySQL says the server is not configured as a replica
Posted in Databases on Aug 1, 2007
Is MySQL giving you the error message “ERROR 1200 (HY000): The server is not configured as replica; fix in config file or with CHANGE MASTER TO” when you try to run START SLAVE? There are a few simple troubleshooting steps to take, but I always forget what to do. This article is to help me remember in the future!
SHOW VARIABLES LIKE 'server_id'on both servers. If the value is zero or one, check the configuration file for an explicit setting, because zero or one is often the default value when nothing is specified. I have seen this cause the replica to fail, even in cases where the master’s ID is 1, which ought to work okay but sometimes doesn’t.
You should now be able to run START SLAVE and start your replica replicating from the master.
Did I miss anything? Let me know, and I’ll add it!