Mysql Load Balancer Reccomendation

[tfunky]

Hi All,

I just built and tested the master-master mysql5 pair on Etch (whoohoo) !

I was going to put a load balancer pair in front of them so I could use a VIP, etc.

I went to follow the directions for ultra monkey on debian like I did in the past, but it's for sarge. After snooping around the ultramonkey website I don't see a etch version.

All that being said...

What's the easiest way to do the equivalent with etch?

Or is there a better way to go about doing this? (ie just install haproxy or ldirector, or heartbeat, etc)

I'm love to hear your recommendations!

Thanks!

Tfunk

[falko]

You can use haproxy and heartbeat (or keepalived) for this.

[tfunky]

Hey Falko!

I took your advice and setup a HAProxy/heartbeat pair.

It took some considerable reading to pull it off as it's not really made for that and most people use it for web proxying.

That being said, I thought I'd paste the revelent part of the config here to save others some time if they attempt it This may not be the best way, but it is working.

listen db_proxy 192.168.1.190:3306
        mode tcp
       stats enable
       stats auth someuser:somepassword
       balance roundrobin
     #  cookie JSESSIONID prefix
     #  option httpclose
     #  option forwardfor
     #  option httpchk HEAD /check.txt HTTP/1.0
       server c1 192.168.1.191
       server c2 192.168.1.192

I can't seem to get the stats to work though. I'm not sure what I have messed up. I thought stats enabled and the password was all that was needed, but apparently I'm missing something.

Hopefully that helps someone!

Thanks for your help Falko!

[falko]

I think the problem is that you've enabled the stats for a MySQL connection, not a web connection, but that's just a guess. I haven't tried this myself...

[tfunky]

I've played with the stats thing some more and I've got it working...I don't know if this is the best way...but at least it's working....

I added a "new" proxy

    # catches any URI and returns the status page.
listen stats :8080
        mode http
        balance roundrobin
        stats uri /

and moved the stats enable to the defaults section.

With that stanza you can access the http://<your virtual ip>:8080 and see the stats.

Thanks for getting me to look in the right place