Re: Initial cluster setup

[Jonathan Miller]

Only if the application starts talking to the mysqld process that is on the box that is left up and running.

So you have 2 boxes that truly make up the cluster. Box 1 has 2 ndbd and 1 mysqld and box 2 had 2 ndbd and 1 mysqld.

The mysqld process are how you get into the cluster, so box 1 goes down, then the mysqld on box 2 will still be talking to the cluster. The application would need to fail over and start talking to the mysqld process that is still alive.

Make sense?

Not sure what all will be running on box 3, but the ndb_mgmd takes very little over head, you might want to consider adding it into the cluster with 2 more data nodes (ndbd).

Thanks,

Jonathan Miller
Austin, Texas USA
Senior QA Developer

MySQL AB www.mysql.com

Jumpstart your cluster!
http://www.mysql.com/consulting/packaged/cluster.html

Get training on clusters
http://www.mysql.com/training/courses/mysql_cluster.html

All-in-one Enterprise-grade Database, Support and Services
http://www.mysql.com/network/