Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

Currently I have two servers:

  1. appbe - linux server with apache web server.
  2. 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!

thanks!

share|improve this question
    
Have you ever read the documentation or books about that topic beside a broad Wikipedia article? –  mailq Oct 2 '11 at 19:19
    
From your question I assume you don't want to use MySQL Cluster, but maybe some MySQL replication, if really needed. –  johannes Oct 2 '11 at 20:32
add comment

1 Answer

It's worth taking a look at the MySQL Cluster evaluation guide to get an overview of the technology and recommended deployment: http://mysql.com/why-mysql/white-papers/mysql_cluster_eval_guide.php

share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.