config.ini file

[Stephen Brown]

I am trying to set up MySQL as a cluster for the first time (on Fedora Linux).
I have downloaded the generic max rpm files and installed them.
I have copied the config.ini file from the example in the documentation, making modifications to match my my network configuration.
When I try to start the management server with:
ndb_mgmd -f /var/lib/mysql-cluster/config.ini

I get the following error:
Error line 25: [DB] Unknown parameter: [MYSQLD] # SQL node options
Error line 25: Could not parse name-value pair in config file.

I presume that I have made a mistake in the config.ini file. Can anybody point me in the right direction to get this up and running?

Thanks,

Stephen Brown.


My config.ini file reads:
[NDBD DEFAULT] # Options affecting ndbd processes on all data nodes:
NoOfReplicas=1 # Number of replicas
DataMemory=80M # How much memory to allocate for data storage
IndexMemory=52M # How much memory to allocate for index storage
# For DataMemory and IndexMemory, we have used the
# default values. Since the "world" database takes up
# only about 500KB, this should be more than enough for
# this example Cluster setup.
[TCP DEFAULT] # TCP/IP options:
portnumber=2202 # This the default; however, you can use any
# port that is free for all the hosts in cluster
# Note: It is recommended beginning with MySQL 5.0 that
# you do not specify the portnumber at all and simply allow
# the default value to be used instead
[NDB_MGMD DEFAULT] # Management process options:
hostname=192.168.0.35 # Hostname or IP address of MGM node
datadir=/var/lib/mysql-cluster # Directory for MGM node logfiles
[NDBD DEFAULT] # Options for data node "A":
# (one [NDBD] section per data node)
hostname=192.168.0.37 # Hostname or IP address
datadir=/var/lib/mysql # Directory for this data node's datafiles
#[NDBD] # Options for data node "B":
#hostname=192.168.0.40 # Hostname or IP address
#datadir=/var/lib/mysql # Directory for this data node's datafiles
[MYSQLD] # SQL node options:
hostname=192.168.0.36 # Hostname or IP address
datadir=/var/lib/mysql # Directory for SQL node's datafiles
# (additional mysqld connections can be
# specified for this node for various
# purposes such as running ndb_restore)