On Solaris platform, you could look for Solaris cluster to provide HA of
SQL server in Active-Active mode and also use the Solaris cluster to
distribute the load among the 2 HA SQL servers.
For more details on the same, probably Detlef could share his thoughts,
I have copied him on this thread.
regards
Yousuf
Peter Chen wrote:
> 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.
>>
>>
>>
>
>
>
> --
> MySQL Cluster Mailing List
> For list archives: http://lists.mysql.com/cluster
> To unsubscribe: http://lists.mysql.com/cluster?unsub=1
>
>
