MySQL Load Balancer
April 23, 2008 – 5:43 pmI’m not sure how I didn’t see this earlier, but it looks like MySQL 5.1 is coming with a load balancer for replicated servers. I’m absolutely pumped about this - we’ve got a few sites running with multiple db slaves and it’s so annoying having to check if they’re behind the master.
It looks like the load balancer will automatically pull slaves out if they fall behind, and route connections to the ones that are the most up to date. It is based on MySQL Proxy, which is currently in Alpha.
2 Responses to “MySQL Load Balancer”
this is EXACTLY what i’ve been waiting for.
it is getting damn close to allowing for transparent replication! sweet. i’ve been hoping someone uses mysql proxy and then adds some replication smarts on top of it. now if they can just make replication heal itself on the failed nodes, pass healthcheck and be put back into the pool… we’ve got an awesome solution…
By mike on Apr 23, 2008
you’ve had it for more than two years now
http://code.tailrank.com/lbpool
… at least if you use Java.
By Kevin Burton on Apr 25, 2008