| List: | Cluster | « Previous MessageNext Message » | |
| From: | Richard McCluskey | Date: | January 13 2010 3:58pm |
| Subject: | RE: about how to implement load balancing and fail over automatically | ||
| View as plain text | |||
On Wed, 2010-01-13 at 09:10 -0500, Jeff Sturm wrote: > > I searched on the Internet with Google,and got the introduction of > > ldirectord. This is the detail information: > > <snip> > > > In my opinion, it's not used for accessing MySQL. And it can't solver > my > > problem. Thanks all the same. > > Sure it is. Here's a snippet from our ldirectord.cf: > > I second that, we use it to load balance the two SQL nodes in our mysql-cluster, and in the last 42 hours it has handled : <snippet from STATUS > Questions: 78,708,953 Slow queries: 102 Opens: 1,487,485 Flush tables: 2 Open tables: 64 Queries per second avg: 508.850 </snippet> We have also watched it 'failover' recently when one of the SQL nodes wedged (faulty memory). The failover happened seamlessly, and without interrupting service. > > HTTP is perhaps the most common use of ldirectord, but not the only one. > It can handle failover or load balancing of essentially any TCP service. > > That said, I don't see any problem with handling load balancing within > the JDBC driver. (It wasn't an option for us because we don't use JDBC > exclusively.) > > -Jeff > > > -- Richard McCluskey Senior Engineer go2Media, Inc. rmccluskey@stripped (617) 671-0057 http://go2.com - The best entertainment guide on mobile.