5 messages in com.mysql.lists.clusterRe: FreeBSD 5.4 - Forced node shutdow...
FromSent OnAttachments
Matthew Horoschun21 Dec 2005 14:28 
Alex Davies21 Dec 2005 15:50 
Stewart Smith21 Dec 2005 16:16 
Matthew Horoschun21 Dec 2005 16:39 
Mikael Ronström22 Dec 2005 01:16 
Subject:Re: FreeBSD 5.4 - Forced node shutdown completed. Initiated by signal 0. Caused by error 2305
From:Mikael Ronström (mik@mysql.com)
Date:12/22/2005 01:16:58 AM
List:com.mysql.lists.cluster

Hi,

2005-12-22 kl. 01.40 skrev Matthew Horoschun:

Hi Stewart,

Thanks for the response.

What do you mean by "add a third machine at a different site"? Are you trying to add a node to your existing cluster? A DB node? An API node?

Sorry: A ndb node.

Essentially starting a new three-node cluster.

If a DB node, you realise that you have to backup and restore to do this?

Yes. I'm doing an --initial on all the ndb nodes.

Also, I hope you're also aware of the bandwidth and relatively low latency requirements for cluster. What link do you have between the machines? Anything less than 100MBit ethernet is probably going to give you problems.

Yep. We have gigabits of bandwidth between the two sites (and the machines are gigabit-connected). That said, there is about 13 ms of latency between the two sites. I appreciate that this will have a deleterious impact on performance -- but should it cause the nodes to fail like this?

It should hopefully work ok, but WAN are known to sometimes stop working for a short time and then get back up again and if this happens it is likely to cause issues with the cluster.

Also, 3 datanodes is not a common setup - 2 or 4 (namely, 2^n) is much more common hence better supported and tested.

Yep. My plan is four nodes total (two at each site) -- but I'm building things up bit by bit so I understand how everything fits together.

This is certainly not a recommended set-up. So if you try it out, please report any findings on how it works. We never test scenarios where we have WAN communication in the cluster.

Rgrds Mikael

Thanks for your help.

Matthew.

-- MySQL Cluster Mailing List For list archives: http://lists.mysql.com/cluster To unsubscribe: http://lists.mysql.com/cluster?unsub=mik@mysql.com

Mikael Ronstrom, Senior Software Architect MySQL AB, www.mysql.com

Jumpstart your cluster: http://www.mysql.com/consulting/packaged/cluster.html My blog: http://mikaelronstrom.blogspot.com