[ Thanks to Sushila
for this link. ]
“MySQL Cluster is used to provide high-availability,
high-redundancy for the distributed computing environment. You
might know that beginning with MySQL 5.1.24, support for the
NDBCLUSTER storage engine was removed from the standard MySQL
server binaries built by MySQL. Therefore, here I’m using
MySQL Cluster edition instead of MySQL Community edition. I’m
using 3 servers (1 Management and 2 data) to setup cluster in
CentOS 5.4 Linux box. The steps mentioned here can be used for
quickly deploying a cluster and worked out for me but no guarantee
that this will work for you, So its always advisable to go through
official MySQL guide as well for production environment. In case
you are also riding on cloud computing wave, I’ve already
blogged way to setup MySQL cluster in Amazon EC2 environment.“1 server will play role of Management server (Example IP:
10.17.250.130) having AMD Opetron 2Ghz with 2 GB of RAM. The load
on this server will not be any significant, so a server with low
configuration will do the job decently. You can install some
monitoring software here to monitor you cluster.“2 data/sql servers (Example IPs: 10.12.248.66, 10.8.75.70)
having Intel Xeon 5335 4×2.00GHz with 16 GB of RAM each.
These servers will store/replicate data.“I want to say here that we can also set both cluster management
service and MySQL service in a single server, even management
service with 2 mysql instance in a single box (for more info refer:
how to run multiple instances of MySQL in single server) but
that’s definitely NOT recommended and apparently have no use
here. Please note that I’m using only IP addresses while
referencing the hosts, you can use the host name as well if you
want.”