2 messages in com.mysql.lists.clusterRe: recommended minimum cluster confi...
FromSent OnAttachments
Maynard-Zhang, Pedrito25 Apr 2006 11:35 
Stewart Smith25 Apr 2006 12:34 
Subject:Re: recommended minimum cluster configuration
From:Stewart Smith (stew@mysql.com)
Date:04/25/2006 12:34:22 PM
List:com.mysql.lists.cluster

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