Skip navigation links

MySQL Forums :: Cluster :: I need some insight about a new Cluster setup


Advanced Search

I need some insight about a new Cluster setup
Posted by: Sebastien Lavoie ()
Date: November 15, 2012 04:08PM

I am in the process of deploying a Load Balancer and I would like some advice. It is the first I will be deploying a MySQL Cluster so please tell me if I say anything that make no sense.

The traffic is not very high, but the requests are pretty slow, mostly on reads.
Databases have about 1GB of data, but not all databases are used completely.

I will be deploying on http://www.linode.com/

My plan:

• 1 Load Balancer
• 1 Manager on 512MB: Puppet + NDB Master
• 2 Web nodes on 512MB
• 2 NDB SQL nodes on 512MB, each connected to their Web node
• 2 NDB Data nodes on 1024MB

The idea is that I can later upgrade any of those, depending on their usage.

Do I need the SQL nodes on another server or they can be on the Web nodes? Do I need more RAM on the SQL nodes ?

I mean, I could do this:
• 2 Web + NDB SQL nodes on 1024MB
• 2 NDB Data nodes on 1024MB

Thank you very much for your time

Options: ReplyQuote


Subject Views Written By Posted
I need some insight about a new Cluster setup 850 Sebastien Lavoie 11/15/2012 04:08PM
Re: I need some insight about a new Cluster setup 437 Benjamin J. 11/16/2012 06:44AM
Re: I need some insight about a new Cluster setup 371 Sebastien Lavoie 11/16/2012 10:59AM


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.