20 messages in com.mysql.lists.clusterMySQL Cluster HA Setup
FromSent OnAttachments
Marco Wertejuk19 Jan 2005 16:38 
Ted Schundler21 Jan 2005 11:54 
Marco Wertejuk21 Jan 2005 13:43 
Mikael Ronström21 Jan 2005 14:46 
Marco Wertejuk21 Jan 2005 15:55 
Casto, Robert21 Jan 2005 16:33 
Alex Davies22 Jan 2005 00:06 
Stewart Smith23 Jan 2005 16:47 
Jesse Erlbaum23 Jan 2005 18:00 
Casto, Robert24 Jan 2005 08:23 
Stewart Smith24 Jan 2005 16:59 
pek...@mysql.com25 Jan 2005 11:45 
Jesse Erlbaum25 Jan 2005 13:59 
Stewart Smith26 Jan 2005 15:37 
pek...@mysql.com27 Jan 2005 00:53 
Per Andreas Buer02 Feb 2005 12:43 
Stewart Smith02 Feb 2005 18:07 
Per Buer03 Feb 2005 00:31 
Eugen Leitl03 Feb 2005 02:40 
Robert Heinzmann03 Feb 2005 10:52 
Subject:MySQL Cluster HA Setup
From:Marco Wertejuk (wert@mwcis.com)
Date:01/19/2005 04:38:13 PM
List:com.mysql.lists.cluster

I'd like to setup two servers to have a clustered data source, I've seen different documentation telling me that I'll need at least three servers because I would also need a management server. I've also read that the management server is not neccessary after the cluster has been started or even after initialization.

My test setup includes two vmware virtual machines running on a private lan. I've also setup one of them to be the management server and of course I get the warning that running the arbitrator and one cluster node on the same host is not a good idea.

Now when I reboot the vm with the ndb_mgmd the other node gets an error and shuts down due to a cluster failure. This is not cleanly reproducable but happens at least in 75% of all reboots.

The logfile tells: Date/Time: Tuesday 18 January 2005 - 07:37:58 Type of error: error Message: Arbitrator shutdown Fault ID: 2305 Problem data: Arbitrator decided to shutdown this node Object of reference: QMGR (Line: 3796) 0x0000000a ProgramName: /usr/local/libexec/ndbd ProcessID: 4220 TraceFile: /var/cluster/db1/ndb_2_trace.log.4 ***EOM***

The tracefile is available here: http://www.hayai.de/misc/ndb_2_trace.log.4.bz2

Any help would be appreciated, regards, Marco