Bug #7733 [mysql_cluster] section connect-string confusion
Submitted: 7 Jan 2005 16:36 Modified: 7 Jan 2005 23:09
Reporter: Dan Gruhn Email Updates:
Status: Not a Bug Impact on me:
None 
Category:MySQL Cluster: Cluster (NDB) storage engine Severity:S3 (Non-critical)
Version:4.1.9 OS:Linux (Fedora Core 1)
Assigned to: Tomas Ulin CPU Architecture:Any

[7 Jan 2005 16:36] Dan Gruhn
Description:
I've been trying to set up a cluster such that I can run the management server on one machine and the NDB and mysqld on another.

Configuration:

mysqlcluster-ndb = NDB and mysqld machine
mysqlcluster-mgm = Cluster manager

It would seem simple as each type of function has it's own section.  However, I've run into a problem.

Here is the my.cnf file:
[mysqld_safe]
err-log=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid

[mysql.server]
user=mysql
basedir=/usr/local/mysql

# The following options will be passed to all MySQL clients
[client]
#password	= your_password
port		= 3306
socket		= /tmp/mysql.sock

# Here follows entries for some specific programs

# The MySQL server
[mysqld]
port = 3306
socket = /tmp/mysql.sock
datadir = /var/lib/mysql

# Start cluster information
ndbcluster
ndb-connectstring=mysqlcluster-mgm.group-w-inc.com

# MySQL cluster management
[ndbd]
connect-string=mysqlcluster-ndb1.group-w-inc.com

[mysql_cluster]
connect-string=mysqlcluster-mgm.group-w-inc.com

[ndb_mgmd]
config-file=/var/lib//mysql-cluster/config.ini

According to the example in http://dev.mysql.com/doc/mysql/en/MySQL_Cluster_Config_Example.html,

the parameter in the [mysql_cluster] section should be ndb-connect-string.  However, this doesn't work, neither the ndbd nor the mysqld like it, giving the following error:

unknown variable 'ndb-connect-string=mysqlcluster-mgm.group-w-inc.com'

By accident, I tried using "connect-string=mysqlcluster-mgm.group-w-inc.com'" and find that the ndbd likes this, but mysqld fails with:

unknown variable 'connect-string=mysqlcluster-mgm.group-w-inc.com'

So, shouldn't they both accept this?  I want to run the ndbd and mysqld on the same machine for testing purposes and I can't do that with the mgmd on another machine.

How to repeat:
Use my my.cnf file and try to run both the NDB and the mysqld on the same machine with a separate machine for the manager.

Suggested fix:
Get mysqld to either recognize the connect-string parameter or ignore the entire [mysql_cluster] section.
[7 Jan 2005 23:09] Tomas Ulin
Thank you for taking the time to write to us, but this is not
a bug. Please double-check the documentation available at
http://www.mysql.com/documentation/ and the instructions on
how to report a bug at http://bugs.mysql.com/how-to-report.php

Additional info:

mysqld accepts:
--ndb-connectstring

ndb_mgmd,ndbd,ndb_mgm etc accepts:
--ndb-connectstring
--connect-string  (kept for backward compliance)

so you can use:
[mysql_cluster]
--ndb-connectstring=...

from the bug-report it seems --ndb-connect-string is used, i.e. a dash "-" to much
[10 Jan 2005 13:30] Dan Gruhn
Tomas,

Thank you for pointing out my mistake.  Please accept my apology for using the bug reporting system for this.

Dan