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