Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

The Setup
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.

The Problem
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.

The Solution?
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.

share|improve this question
    
Well, this is SF, not SO, but close enough ;) –  Mark Henderson Oct 22 '10 at 5:33
    
Oh darn, you're right my bad, I'm more active on SO that's why ;) –  CharlesLeaf Oct 22 '10 at 5:33
    
Have you considered using mysql-proxy instead? –  pauska Oct 22 '10 at 5:59
    
I have, and might still switch.. (altho it is nice to have 1 allpurpose loadbalancer) but when I was searching the Googles for my problem I found several people using MySQL-Proxy having the same problem.. –  CharlesLeaf Oct 22 '10 at 6:38
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.