On Tue, 2006-04-25 at 11:36 -0700, Maynard-Zhang, Pedrito wrote:
The documentation says that 3 hosts are required for HA, but 4 are
recommended -- one for a management node, one for an SQL node, and two
node for two storage nodes (one each). In what ways is this
configuration superior to a 3-host configuration where one host is for
the management node and each of the other two nodes contains both an
SQL node and a storage node? They seem to have similar HA properties.
We wouldn't recommend only 1 SQL node. If this is anywhere in our docs,
please give us a URL to it and we'll fix it up.
a four node cluster with a configuration similar to:
- mgmd, mysqld
- ndbd
- ndbd
- mysqld
would be better as then you have redundant mysqld nodes.
Jumpstart your cluster:
http://www.mysql.com/consulting/packaged/cluster.html