SQL node not run.
Hello, I install cluster mysql and configure with:
http://dev.mysql.com/doc/refman/5.1/en/mysql-cluster-quick.html
But I not work SQL NODE(mysqld(API)).
I disable iptables firewall, I update mysql 4.1 at 5.0 and 5.1.11, simple cluster not work please help me¡¡¡¡ Thanks
LOG and info:
ndb_mgm> show
Connected to Management Server at: localhost:1186
Cluster Configuration
---------------------
[ndbd(NDB)] 1 node(s)
id=2 @127.0.0.1 (Version: 5.0.26, Nodegroup: 0, Master)
[ndb_mgmd(MGM)] 1 node(s)
id=1 @127.0.0.1 (Version: 5.0.26)
[mysqld(API)] 3 node(s)
id=3 (not connected, accepting connect from any host)
id=4 (not connected, accepting connect from any host)
id=5 (not connected, accepting connect from any host)
-------------------------------------------------------------
mysql> USE test;
Database changed
mysql> REATE TABLE ctest (i INT) ENGINE=NDBCLUSTER;
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'REATE TABLE ctest (i INT) ENGINE=NDBCLUSTER' at line 1
mysql> CREATE TABLE ctest (i INT) ENGINE=NDBCLUSTER;
ERROR 1050 (42S01): Table 'ctest' already exists
-------------------------------------------------------------
log in: ndb_1_cluster.log
2006-10-19 21:26:58 [MgmSrvr] INFO -- NDB Cluster Management Server. Version 5.0.26
2006-10-19 21:26:58 [MgmSrvr] INFO -- Id: 1, Command port: 1186
2006-10-19 21:27:00 [MgmSrvr] INFO -- Mgmt server state: nodeid 3 reserved for ip 127.0.0.1, m_reserved_nodes 000000000000000a.
2006-10-19 21:27:00 [MgmSrvr] INFO -- Node 3: mysqld --server-id=0
2006-10-19 21:27:05 [MgmSrvr] INFO -- Mgmt server state: nodeid 2 reserved for ip 127.0.0.1, m_reserved_nodes 000000000000000e.
2006-10-19 21:27:06 [MgmSrvr] INFO -- Node 1: Node 2 Connected
2006-10-19 21:27:06 [MgmSrvr] INFO -- Node 2: Start phase 0 completed
2006-10-19 21:27:06 [MgmSrvr] INFO -- Node 2: Initial start with nodes 0000000000000004 [ missing: 0000000000000000 no-wait: 00000000000$
2006-10-19 21:27:06 [MgmSrvr] INFO -- Node 2: CM_REGCONF president = 2, own Node = 2, our dynamic id = 1
2006-10-19 21:27:06 [MgmSrvr] INFO -- Node 2: Start phase 1 completed
2006-10-19 21:27:06 [MgmSrvr] INFO -- Node 2: Start phase 2 completed (initial start)
2006-10-19 21:27:06 [MgmSrvr] INFO -- Node 2: Start phase 3 completed (initial start)
2006-10-19 21:27:06 [MgmSrvr] INFO -- Mgmt server state: nodeid 2 freed, m_reserved_nodes 000000000000000a.
2006-10-19 21:27:14 [MgmSrvr] INFO -- Node 2: Start phase 4 completed (initial start)
2006-10-19 21:27:15 [MgmSrvr] INFO -- Node 2: Local checkpoint 1 started. Keep GCI = 1 oldest restorable GCI = 1
2006-10-19 21:27:16 [MgmSrvr] INFO -- Node 2: Start phase 5 completed (initial start)
2006-10-19 21:27:16 [MgmSrvr] INFO -- Node 2: Start phase 6 completed (initial start)
2006-10-19 21:27:16 [MgmSrvr] INFO -- Node 2: President restarts arbitration thread [state=1]
2006-10-19 21:27:16 [MgmSrvr] INFO -- Node 2: Start phase 7 completed (initial start)
2006-10-19 21:27:16 [MgmSrvr] INFO -- Node 2: Communication to Node 3 opened
2006-10-19 21:27:16 [MgmSrvr] INFO -- Node 2: Communication to Node 4 opened
2006-10-19 21:27:16 [MgmSrvr] INFO -- Node 2: Communication to Node 5 opened
2006-10-19 21:27:16 [MgmSrvr] INFO -- Node 2: Communication to Node 0 opened
2006-10-19 21:27:16 [MgmSrvr] INFO -- Node 2: Start phase 8 completed (initial start)
2006-10-19 21:27:16 [MgmSrvr] INFO -- Node 2: Start phase 9 completed (initial start)
2006-10-19 21:27:16 [MgmSrvr] INFO -- Node 2: Started (version 5.0.26)
2006-10-19 21:27:16 [MgmSrvr] INFO -- Node 2: Node 3 Connected
2006-10-19 21:27:16 [MgmSrvr] INFO -- Node 2: Node 3: API version 5.1.11
2006-10-19 21:27:17 [MgmSrvr] INFO -- Node 2: Node 1: API version 5.0.26
2006-10-19 21:27:17 [MgmSrvr] INFO -- Node 2: Started arbitrator node 1 [ticket=2c8d0001620aab04]
2006-10-19 21:27:20 [MgmSrvr] WARNING -- Node 2: Node 3 missed heartbeat 2
2006-10-19 21:27:22 [MgmSrvr] WARNING -- Node 2: Node 3 missed heartbeat 3
2006-10-19 21:27:23 [MgmSrvr] WARNING -- Node 2: Node 3 missed heartbeat 4
2006-10-19 21:27:23 [MgmSrvr] ALERT -- Node 2: Node 3 declared dead due to missed heartbeat
2006-10-19 21:27:23 [MgmSrvr] INFO -- Node 2: Communication to Node 3 closed
2006-10-19 21:27:23 [MgmSrvr] ALERT -- Node 2: Node 3 Disconnected
2006-10-19 21:27:27 [MgmSrvr] INFO -- Node 2: Communication to Node 3 opened
2006-10-19 21:27:27 [MgmSrvr] INFO -- Node 2: Node 3 Connected
2006-10-19 21:27:27 [MgmSrvr] INFO -- Node 2: Node 3: API version 5.1.11
2006-10-19 21:27:31 [MgmSrvr] WARNING -- Node 2: Node 3 missed heartbeat 2
2006-10-19 21:27:32 [MgmSrvr] WARNING -- Node 2: Node 3 missed heartbeat 3
2006-10-19 21:27:34 [MgmSrvr] WARNING -- Node 2: Node 3 missed heartbeat 4
2006-10-19 21:27:34 [MgmSrvr] ALERT -- Node 2: Node 3 declared dead due to missed heartbeat
2006-10-19 21:27:34 [MgmSrvr] INFO -- Node 2: Communication to Node 3 closed
2006-10-19 21:27:34 [MgmSrvr] ALERT -- Node 2: Node 3 Disconnected
--------------------------------------------------------------------------------
Actual mysql rpm install:
MySQL-client-5.1.11-0.glibc23.i386.rpm MySQL-ndb-storage-5.1.11-0.glibc23.i386.rpm
MySQL-devel-5.1.11-0.glibc23.i386.rpm MySQL-ndb-tools-5.1.11-0.glibc23.i386.rpm
MySQL-ndb-extra-5.1.11-0.glibc23.i386.rpm MySQL-server-5.1.11-0.glibc23.i386.rpm
MySQL-ndb-management-5.1.11-0.glibc23.i386.rpm MySQL-shared-5.1.11-0.glibc23.i386.rpm
Edited 3 time(s). Last edit at 10/19/2006 01:47PM by David Garcia.