I have used the configuration which Alex Davies has posted in this link :
http://dev.mysql.com/tech-resources/articles/mysql-cluster-for-two-servers.html.
I was able to successfully setup the cluster for mysql 4.1.9, using 64bit versions for the DB and SQL nodes, and a 32bit version for the MGM node. The SQL nodes runs on solaris 9, while the MGM node runs on solaris 8.
However, I've tried upgrading to 5.0.3, and unfortunately I can't seem to get the cluster to work. It seems that the DB nodes can't start completely. When I used the ndb_mgm client and issue SHOW command, here's what I see :
-- NDB Cluster -- Management Client --
ndb_mgm> show
Connected to Management Server at: 10.110.60.10:1186
Cluster Configuration
---------------------
[ndbd(NDB)] 2 node(s)
id=2 @10.110.61.244 (Version: 5.0.3, starting, Nodegroup: 0, Master)
id=3 @10.110.61.245 (Version: 5.0.3, starting, Nodegroup: 0, Master)
[ndb_mgmd(MGM)] 1 node(s)
id=1 @10.110.60.10 (Version: 5.0.3)
[mysqld(API)] 2 node(s)
id=4 (not connected, accepting connect from any host)
id=5 (not connected, accepting connect from any host)
If I issue this command "2 STATUS" command, here's what is displayed :
Node 2: starting (Phase 2) (Version 5.0.3)
Upon checking the logs for the MGM node, I see these statements :
2005-04-08 10:53:34 [MgmSrvr] INFO -- Node 1: Node 3 Connected
2005-04-08 10:53:35 [MgmSrvr] INFO -- Mgmt server state: nodeid 3 freed, m_reserved_nodes 0000000000000002.
2005-04-08 10:53:48 [MgmSrvr] INFO -- Node 3: Start phase 0 completed
2005-04-08 10:53:48 [MgmSrvr] INFO -- Node 3: Communication to Node 2 opened
2005-04-08 10:54:20 [MgmSrvr] INFO -- Node 3: Start phase 1 completed
2005-04-08 10:55:50 [MgmSrvr] INFO -- Mgmt server state: nodeid 4 reserved for ip 10.116.61.245, m_reserved_nodes 0000000000000012.
2005-04-08 13:49:08 [MgmSrvr] INFO -- Mgmt server state: nodeid 4 freed, m_reserved_nodes 0000000000000002.
2005-04-08 13:52:48 [MgmSrvr] INFO -- Mgmt server state: nodeid 4 reserved for ip 10.116.61.245, m_reserved_nodes 0000000000000012.
2005-04-08 15:16:00 [MgmSrvr] INFO -- Mgmt server state: nodeid 2 reserved for ip 10.116.61.244, m_reserved_nodes 0000000000000016.
2005-04-08 15:16:01 [MgmSrvr] INFO -- Node 1: Node 2 Connected
2005-04-08 15:16:02 [MgmSrvr] INFO -- Mgmt server state: nodeid 2 freed, m_reserved_nodes 0000000000000012.
2005-04-08 15:16:18 [MgmSrvr] INFO -- Node 2: Start phase 0 completed
2005-04-08 15:16:18 [MgmSrvr] INFO -- Node 2: Communication to Node 3 opened
2005-04-08 15:16:48 [MgmSrvr] INFO -- Node 2: Start phase 1 completed
2005-04-08 15:18:32 [MgmSrvr] INFO -- Mgmt server state: nodeid 5 reserved for ip 10.116.61.244, m_reserved_nodes 0000000000000032.
At first, I thought that the nodes just took some time before starting up. I let a couple of minutes passed, but the nodes still don't start. Hours had passed but still the nodes are not up yet.
What could be causing these problems? Any info would be much appreciated.
Regards,
Julius