I am putting my post here as there is more traffic in this section than Database.
Anyone use replication with MySQL V5.1?
I have it set up and working with no issues in a redundant Mission Critical application. Only issue I have is whenever the Master Database PC reboots after a power failure, the binary log file created and used by the master increments and the slave has no idea of this.
Is there anyway to get the slave become aware of the new bin log file and file postion?
This question has been posted by others on the MySQL forum but no one has answered.
So far the only solution is to connect to slave MySQL and re-enter all the master configuration data.