Re: LBPool, or alternatives?

On Feb 18, 2010, at 2:40 PM, Kevin Fries wrote:

> Hi all,
> Is anyone using lbpool, and is it available anywhere for download?  All the links I followed lead to dead servers or wrong files.
> 
> I'm considering lbpool based on its description, because I'm looking for an alternative to the replication driver, which seems too brittle.  If one slave in the list goes down, the pool can't operate.  I'd also like a dynamic way to stop the driver from connecting to certain slaves (say, during maintenance.)
> 
> Thanks for your help,
> Kevin Fries

Kevin,

You might take a look at the replication driver in 5.1.11 or newer. It doesn't have this issue, because the list of slaves is now held by a jdbc:mysql:loadbalance connection, which does have black/white listing of downed hosts.

If you want to try it, you probably want to pull a copy of the nightly build from http://downloads.mysql.com/snapshots.php tomorrow, as we just pushed a bug fix that does fix some configurations of jdbc:mysql:loadbalance connections.

I looked into the LBPool code at one time, but I was concerned about its reliance on DNS to make things work. jdbc:mysql:loadbalance connections are somewhat more resilient in the face of DNS failures, and the load balancing mechanism is extensible, so if you wanted to pull the list of active slaves from somewhere, it would be easy to do.

	-Mark
-- 
Mark Matthews, Architect - Enterprise Tools
MySQL @ Sun Microsystems, Inc., http://www.sun.com/mysql/





-- 
MySQL Java Mailing List
For list archives: http://lists.mysql.com/java
To unsubscribe:    http://lists.mysql.com/[email protected]