Right now I've got set up 3 MySQL Servers (5.1.x, on RHEL5), one Master and two Slaves. Last week I added a load balancer (HAProxy) for some services, and thought I'd experiment with using it for MySQL as well. So I added the MySQL Slave servers to HAProxy and started using that in my test environment. I've got several services automated in the background, most of which need MySQL connections. I also have a custom notification system that notifies me if something doesn't work.
Sometimes I wake up to find a warning in my mailbox (from the custom service) that a MySQL connection failed. I can't make sense of it, as it only happens on some random occasions it seems.. but I have no clue what causes it.
Lost connection to MySQL server at 'reading initial communication packet'
Which I didn't see happening until I added the load balancer in the mix. I've tried to search a bit on the interwebs but I couldn't find anything that helped either explain or solve this problem.
So now I bring this problem to SF, with great hope that someone here can help me out.
Alright, it looks like using old passwords seems to solve this. I'm not quite sure why it would matter, but I'll roll with it if it works, which so far it appears to be doing.