|
|
Mark, thanks. I'll check that out. Sounds very interesting, and sounds like
it addresses exactly what I want.
--- On Thu, 2/18/10, Mark Matthews <markm@xxxxxxx> wrote:
From: Mark Matthews <markm@xxxxxxx>
Subject: Re: LBPool, or alternatives?
To: "Kevin Fries" <kelfink@xxxxxxxxx>
Cc: java@xxxxxxxxxxxxxxx
Date: Thursday, February 18, 2010, 12:46 PM
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/java?unsub=mailarch@xxxxxxx
|
|