MySQL Forums
Forum List  »  NDB clusters

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
1518
November 15, 2012 04:08PM


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.