Hello,

I've been reading the various configuration examples, but I'm still not quite sure which settings need to go on which nodes. I understand that the config.ini should go in the management server, but the data nodes and mysql nodes, which settings should they have?

I'm trying to build a 6 server cluster. 1 for management, 2 data nodes and 3 mysql nodes. I'm on a Fedora 5 system, and I have these packages installed in the 6 servers:

MySQL-ndb-extra-5.0.22-0.glibc23 libdbi-dbd-mysql-0.8.1a-1.2.1 mysql-connector-odbc-3.51.12-1.2.1 MySQL-Max-5.0.22-0.glibc23 MySQL-ndb-tools-5.0.22-0.glibc23 mysql-5.0.22-1.FC5.1 MySQL-ndb-management-5.0.22-0.glibc23 mysql-server-5.0.22-1.FC5.1 MySQL-ndb-storage-5.0.22-0.glibc23

I'm using the following hostnames (defined in /etc/hosts)

db_mgr, ndb1, ndb2, mysql1, mysql2, mysql3

I have this in /etc/my.cnf in each of the ndb* and mysql* servers:

[MYSQLD] ndbcluster # run NDB engine ndb-connectstring=db_mgr # location of MGM node

# Options for ndbd process: [MYSQL_CLUSTER] ndb-connectstring=db_mgr # location of MGM node

In the db_mgr node I have the following config.ini:

[NDBD DEFAULT] NoOfReplicas= 2 DataDir= /var/lib/mysql-cluster

[NDB_MGMD] Hostname= db_mgr DataDir= /var/lib/mysql-cluster

[NDBD] HostName= ndb1

[NDBD] HostName= ndb2

[MYSQLD] HostName= mysql1 [MYSQLD] HostName= mysql2 [MYSQLD] HostName= mysql3

I have run ndb_mgmd on db_mgr, and ran ndbd on the ndb nodes.

But when I attempt to startup mysqld on the mysql nodes, I get the following:

# /etc/init.d/mysqld start Timeout error occurred trying to start MySQL Daemon. Starting MySQL: [FAILED]

The mysqld.log shows: 060731 13:23:55 mysqld started 060731 13:23:55 [ERROR] /usr/libexec/mysqld: unknown variable 'ndb-connectstring=db_mgr'

060731 13:23:55 mysqld ended

Even though I do have mysqld-max installed, I can only guess that the initscript is attempting to run mysqld and not mysqld-max.

If I run mysqld-max -u mysql & I get this:

# mysqld-max -u mysql & [1] 13643 [root@mysql3 ~]# 060731 13:25:43 InnoDB: Started; log sequence number 0 43655

[root@mysql3 ~]# 060731 13:25:54 [Note] mysqld-max: ready for connections. Version: '5.0.22-max' socket: '/var/lib/mysql/mysql.sock' port: 3306 MySQL Community Edition - Experimental (GPL)

which _seems_ to be running ok... but I don't see the mysql node as connected to the management node:

[mysqld(API)] 3 node(s) id=4 (not connected, accepting connect from mysql1) id=5 (not connected, accepting connect from mysql2) id=6 (not connected, accepting connect from mysql3)

The mysql console does show ndbcluster as a supported engine, do I need to do something else to get the mysql node to register with the management node?

Thanks Ricardo