Help, I seem to be running into a problem with replication which up until now has served us well.
We run mysql servers in pairs, with each server in a pair mastering off the other. So for example mysql1 masters off mysql2, which masters off mysql1. Friday morning one server stopped accepting connections for replication, let's call it mysql2. It's partner, called mysql1, has some log entries which seem on the face of it self explanatory... 040221 15:35:40 Slave I/O thread: error connecting to master '[EMAIL PROTECTED]:3306': Error: 'Access denied for user: '[EMAIL PROTECTED]' (Using password: YES)' errno: 1045 retry-time: 60 retries: 86400 Now even I can read that it doesn't like the username/password combination. Let's just settle for the fact that I can change the username/password combination to any set of usernames/passwords that are valid for replication connections and I still get the same error. In cases where that username/password are enabled to logon for other purposes, say my personal sysadmin account which has all access enabled, I can log in fine using the mysql client, but when trying that username/password in replication I get the same error as above. So one of my server pairs has fallen way behind in what is current data... I have moved all my application servers to point to the fully up to date server. I can't point them to mysql1 and bounce mysql2, the data is a day and a half out of date. So far I've tried everything I know to get replication working short of bouncing mysql2... the seemingly problematic master. Clearly bouncing the only server we have will cause me some heartache with the application servers and I will have to co-ordinate the timing to such an action with all our clients... Our next scheduled maintenance window isn't till Friday morning, I don't want to run on one server for a week here. Anyone got any ideas or suggestions on how I can resolve this issue? Will bouncing even help me? Best Regards, Bruce -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
