MySQL Forums
Forum List  »  NDB clusters

Load Balancing Cluster?
Posted by: Kirk
Date: November 09, 2004 11:32AM

We are currently reviewing different load balancing options for our growing MySQL installation. A few questions have come up that, and since I am not a mysql specialist by any means, I am struggling with possible answers. Hopefully someone here can shed some light on these issues and help me find a solution.

The original code/database was never written to be distributed. Consequently we have had trouble setting up any kind of distributed services. We have a single master that replicates to several slaves. These slaves are not used except as a backup/hot spare. Since we have not been able to split up the updates and the queries, and we can't update to a slave, we are stuck using just the master. We are rewriting the code/database structure to allow that kind of modularity, but it is a long process. Hence , the interest in a cluster approach.

The alternatives I am considering are:
-A native MySQL cluster. This is pretty new and I doubt we will adopt it because of the memory/size limitation. But if someone has some input I would really appreciate it, as my knowledge here is especially limited.
-A third party layer to provide MySQL clustering ie. Emic Networks, or similar. I have no experience with these either, and I don't know what kind of caveats there might be with such a product.

I posted a similar post in the replication section hoping to get some feedback on the multi-master approach. Hopefully someone here can provide some insight into these clustering options.

Any input is appreciated,
Kirk

Options: ReplyQuote


Subject
Views
Written By
Posted
Load Balancing Cluster?
3960
November 09, 2004 11:32AM


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.