Cluster Configuration
---------------------
[ndbd(NDB)]     2 node(s)
id=2    @192.168.5.13  (mysql-5.1.27 ndb-6.3.17, starting, Nodegroup: 0, Master)
id=3    @192.168.5.14  (mysql-5.1.27 ndb-6.3.17, starting, Nodegroup: 0)

[ndb_mgmd(MGM)] 1 node(s)
id=1   (mysql-5.1.27 ndb-6.3.17)

[mysqld(API)]   2 node(s)
id=4 (not connected, accepting connect from 192.168.5.14)
id=5 (not connected, accepting connect from 192.168.5.13)

[root@RESEARCH-01 ~]# ndb_mgm -e show
Connected to Management Server at: localhost:1186
Cluster Configuration
---------------------
[ndbd(NDB)]     2 node(s)
id=2    @192.168.5.14  (mysql-5.1.27 ndb-6.3.17, Nodegroup: 0, Master)
id=3    @192.168.5.15  (mysql-5.1.27 ndb-6.3.17, Nodegroup: 0)

[ndb_mgmd(MGM)] 1 node(s)
id=1    @192.168.5.12  (mysql-5.1.27 ndb-6.3.17)

[mysqld(API)]   1 node(s)
id=4    @192.168.5.13  (mysql-5.1.27 ndb-6.3.17)

ERROR 1005 (HY000): Can't create table 'dbcluster.aggregator_category_feed' (errno: 157)

mysql> CREATE TABLE IF NOT EXISTS `aggregator_category_feed` (   `fid` int(11) NOT NULL default '0',   `cid` int(11) NOT NULL default '0',   PRIMARY KEY  (`fid`,`cid`) ) ENGINE=NDBCLUSTER

mysql> SHOW ENGINES\G
*************************** 1. row ***************************
      Engine: ndbcluster
     Support: YES
     Comment: Clustered, fault-tolerant tables
Transactions: YES
          XA: NO
  Savepoints: NO
*************************** 2. row ***************************
      Engine: MRG_MYISAM
     Support: YES
     Comment: Collection of identical MyISAM tables
Transactions: NO
          XA: NO
  Savepoints: NO
*************************** 3. row ***************************
      Engine: BLACKHOLE
     Support: YES
     Comment: /dev/null storage engine (anything you write to it disappears)
Transactions: NO
          XA: NO
  Savepoints: NO
*************************** 4. row ***************************
      Engine: CSV
     Support: YES
     Comment: CSV storage engine
Transactions: NO
          XA: NO
  Savepoints: NO
*************************** 5. row ***************************
      Engine: MEMORY
     Support: YES
     Comment: Hash based, stored in memory, useful for temporary tables
Transactions: NO
          XA: NO
  Savepoints: NO
*************************** 6. row ***************************
      Engine: InnoDB
     Support: YES
     Comment: Supports transactions, row-level locking, and foreign keys
Transactions: YES
          XA: YES
  Savepoints: YES
*************************** 7. row ***************************
      Engine: ARCHIVE
     Support: YES
     Comment: Archive storage engine
Transactions: NO
          XA: NO
  Savepoints: NO
*************************** 8. row ***************************
      Engine: MyISAM
     Support: DEFAULT
     Comment: Default engine as of MySQL 3.23 with great performance
Transactions: NO
          XA: NO
  Savepoints: NO
8 rows in set (0.01 sec)

mysql> show errors;
+-------+------+----------------------------------------------------------------------+
| Level | Code | Message                                                                           |
+-------+------+----------------------------------------------------------------------+
| Error | 1005 | Can't create table 'dbcluster.aggregator_category_feed' (errno: 157) | 
+-------+------+----------------------------------------------------------------------+
1 row in set (0.00 sec)

mysql> SHOW PROCESSLIST\G
*************************** 1. row ***************************
     Id: 1
   User: system user
   Host: 
     db: NULL
Command: Daemon
   Time: 1356
  State: [color=#FF0000]Waiting for ndbcluster to start[/color]
   Info: NULL
*************************** 2. row ***************************
     Id: 3
   User: root
   Host: localhost
     db: dbcluster
Command: Query
   Time: 0
  State: NULL
   Info: SHOW PROCESSLIST
2 rows in set (0.00 sec)

[root@RESEARCH-01 ~]# ndb_mgm -e show
Connected to Management Server at: localhost:1186
Cluster Configuration
---------------------
[ndbd(NDB)]     2 node(s)
id=2    @192.168.5.14  (mysql-5.1.27 ndb-6.3.17, Nodegroup: 0, Master)
id=3    @192.168.5.15  (mysql-5.1.27 ndb-6.3.17, Nodegroup: 0)

[ndb_mgmd(MGM)] 1 node(s)
id=1    @192.168.5.12  (mysql-5.1.27 ndb-6.3.17)

[mysqld(API)]   1 node(s)
id=4    @192.168.5.13  (mysql-5.1.27 ndb-6.3.17)

081111 23:24:50 [ERROR] NDB: CREATE TABLE IF NOT EXISTS mysql.ndb_apply_status ( server_id INT UNSIGNED NOT NULL, epoch BIGINT UNSIGNED NOT NULL,  log_name VARCHAR(255) BINARY NOT NULL,  start_pos BIGINT UNSIGNED NOT NULL,  end_pos BIGINT UNSIGNED NOT NULL,  PRIMARY KEY USING HASH (server_id) ) ENGINE=NDB CHARACTER SET latin1: error Can't create table 'mysql.ndb_apply_status' (errno: 157) 1005(ndb: 0) 1 1
081111 23:24:50 [Note] /usr/local/mysql/bin/mysqld: Normal shutdown

081111 23:24:50 [Note] Event Scheduler: Purging the queue. 0 events
081111 23:24:50 [Note] Stopping Cluster Utility thread
081111 23:24:53 [Note] Stopping Cluster Binlog
081111 23:24:56  InnoDB: Starting shutdown...
081111 23:24:58  InnoDB: Shutdown completed; log sequence number 0 46419
081111 23:24:58 [Note] /usr/local/mysql/bin/mysqld: Shutdown complete

081111 23:24:58 mysqld_safe mysqld from pid file /usr/local/mysql/data/RESEARCH-02.pid ended
081111 23:31:49 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/data
081111 23:31:50  InnoDB: Started; log sequence number 0 46419
081111 23:31:50 [Note] NDB: NodeID is 4, management server '192.168.5.12:1186'
081111 23:31:51 [Note] NDB[0]: some storage nodes connected
081111 23:31:51 [Warning] NDB: server id set to zero will cause any other mysqld with bin log to log with wrong server id
081111 23:31:51 [Note] Starting Cluster Binlog Thread
081111 23:31:51 [Note] Event Scheduler: Loaded 0 events
081111 23:31:51 [Note] /usr/local/mysql/bin/mysqld: ready for connections.
Version: '5.1.27-ndb-6.3.17-cluster-gpl'  socket: '/tmp/mysql.sock'  port: 3306  MySQL Cluster Server (GPL)

081111 23:47:31 [ERROR] NDB Binlog: ndbevent->execute failed for REPL$mysql/ndb_schema; 1427 Api node died, when SUB_START_REQ reached node 
081111 23:47:31 [ERROR] NDB Binlog:FAILED CREATE (DISCOVER) EVENT OPERATIONS Event: REPL$mysql/ndb_schema

drwxr-x---  5 mysql mysql  4096 Nov 12 08:16 data

[root@RESEARCH-01 mysql-cluster]# tail ndb_1_cluster.log 
2008-11-13 01:04:50 [MgmSrvr] INFO     -- Node 2: Local checkpoint 8 started. Keep GCI = 9798 oldest restorable GCI = 3
2008-11-13 02:02:36 [MgmSrvr] INFO     -- Node 2: Local checkpoint 9 started. Keep GCI = 11431 oldest restorable GCI = 3
2008-11-13 03:00:19 [MgmSrvr] INFO     -- Node 2: Local checkpoint 10 started. Keep GCI = 13079 oldest restorable GCI = 3
2008-11-13 03:58:05 [MgmSrvr] INFO     -- Node 2: Local checkpoint 11 started. Keep GCI = 14725 oldest restorable GCI = 3
2008-11-13 04:55:54 [MgmSrvr] INFO     -- Node 2: Local checkpoint 12 started. Keep GCI = 16392 oldest restorable GCI = 3
2008-11-13 05:53:39 [MgmSrvr] INFO     -- Node 2: Local checkpoint 13 started. Keep GCI = 18032 oldest restorable GCI = 3
2008-11-13 06:51:24 [MgmSrvr] INFO     -- Node 2: Local checkpoint 14 started. Keep GCI = 19674 oldest restorable GCI = 3
2008-11-13 07:49:10 [MgmSrvr] INFO     -- Node 2: Local checkpoint 15 started. Keep GCI = 21333 oldest restorable GCI = 3
2008-11-13 08:45:13 [MgmSrvr] WARNING  -- Node 2: Node 4 missed heartbeat 2
2008-11-13 08:46:54 [MgmSrvr] INFO     -- Node 2: Local checkpoint 16 started. Keep GCI = 22986 oldest restorable GCI = 3