Currently I have two servers:
- appbe - linux server with apache web server.
- db0 - linux server with mysql server.
I want to add another linux server with another mysql server and and to use mysql-cluster server instead.
I created a new linux server called db1 and i installed on both db0 and db1 that mysql cluster server.
my first question is:
I noticed the that MySQL Cluster Management Server Daemon be installed and running on one of the nodes. so I decided to install the Mysql Cluster management server on the appbe server as well. is it a good idea? will the cluster management server take too much resources and it shouldn't reside on the same server that supplies web pages? and if so doesn't it mean that I must have 3 different servers minimum to run mysql as a cluster ?
so it means that I'll have the following configuration:
appbe - tomcat web server with mysql management node
- db1 - data node
- db2 - data node
by reading http://en.wikipedia.org/wiki/MySQL_Cluster I understood that running that SQL node (running mysql server) is optional and is not needed if I use the NDB API. I read that clusterJ connector uses that API.
is that an optimal configuration ? if db1 and db2 are data nodes doesn't it mean that the management node is the brain and all the sql parsing will happen there?
any information would be greatly appreciated!