Hi all,
The best way to do this(to implement load balancing and fail over automatically) is to use
a software loadbalancer like Ldirectord, coupled with a failover mechanism such as
heartbeat.
My Operating system is Solaris 10 sparc but not Linux. So there no LVS on it.
I want to know if there is a counterpart software like LVS on Solaris 10 operating system?
If not, I think I can't use this solution.
Expect your answer, thanks.
Peter
-----Original Message-----
From: Richard McCluskey [mailto: Richard McCluskey]
Sent: 2010年1月13
To: Peter Chen
Cc: cluster@stripped
Subject: RE: about how to implement load balancing and fail over automatically
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.
-----Original Message-----
From: Andrew.Morgan@stripped [mailto:Andrew.Morgan@stripped]
Sent: 2010年1月12日 16:54
To: Peter Chen
Cc: cluster@stripped
Subject: RE: about how to implement load balancing and fail over automatically
Hi Peter,
I've yet to try setting it up myself but if you're using MySQL's JDBC
connector then it can handle the failover for you.
Regards, Andrew.
> -----Original Message-----
> From: Peter Chen [mailto:peter.chen@stripped]
> Sent: 12 January 2010 08:50
> To: cluster@stripped
> Subject: about how to implement load balancing and fail over
> automatically
>
>
>
> Now in my software system, I used MySQL as the backend DB server.
> Because of the performance problem, I want to upgrade to MySQL Cluster.
>
> I want to use MySQL Cluster NDB 7.0
> <https://code.launchpad.net/%7Emysql/mysql-server/mysql-cluster-7.0> ,
> I
> have read this article: A.10. MySQL 5.1 FAQ - MySQL Cluster
> <http://dev.mysql.com/doc/refman/5.1/en/faqs-mysql-
> cluster.html#qandaite
> m-23-10-1-17> , and I know this:
>
>
>
> 23.10.14: How do I continue to send queries in the event that one of
> the
> SQL nodes fails?
>
> MySQL Cluster does not provide any sort of automatic failover between
> SQL nodes. Your application must be prepared to handle the loss of SQL
> nodes and to fail over between them.
>
>
>
> My question is that I don't know how to modify my code to implement
> load
> balancing and handle the loss of SQL nodes and to fail over between
> them.
>
> Just modify the configuration of JDBC or use some third-party software
> to implement load balancing and fail over automatically?
>
> Expect your help, thanks.
>
>
