Load Balancing MySQL Cluster SQL Nodes
I've been researching for a "best solution" for applying a load balancer in front of the sql nodes in our cluster; open source.
Our application requires many writes so it is important to have the following if possible 1)everything in sync at all times (that's why we choose cluster instead of master-slave) -- currently using 5.0 since 5.1 is still beta 2)load balancing and automatic failover for reads and writes
Some of the products I've looked at are 1) HAProxy - no automatic failover 2) MySQL Proxy - doesn't like cluster technology from what I gather (haven't actually tried it) 3) Sequoia - In order to get the write balancing you have to know table column names and their uniqueness (time consuming and info not readily available) 4) SQL Relay - no failover built in 5) Balance - currently looking at and testing.
Is there anyone that is currently doing this successfully with an open source solution? If so, what are you using or how are you doing it? What are your thoughts?
I'm fairly new to all this so if I'm on the wrong track, speak up. :-)
Thank you!
Subject
Views
Written By
Posted
Load Balancing MySQL Cluster SQL Nodes
21461
October 30, 2007 11:20AM
9109
October 30, 2007 11:26AM
7688
October 31, 2007 01:59AM
7527
October 31, 2007 09:21AM
7273
December 05, 2007 02:38PM
7206
November 05, 2007 03:02PM
6322
November 08, 2007 03:54AM
5791
December 09, 2007 11:43PM
5680
December 12, 2007 09:16AM
4480
February 08, 2009 11:42PM
4421
February 16, 2009 07:07PM
4142
March 19, 2009 01:04AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.