Re: Cluster Configuration 2 MGMD nodes

[Chandra Vanipenta]

Hi,
Please find the config.ini and my.cnf files used in my configuration below.
Tried with only two machines(1 mgm node+1 data node + 1 SQL node) on each.
This works with problems :-). When one mgmt server goes down(crash, kill processes etc..) the cluster goes for a forced shutdown and the ndbd process on the other machine is killed. Can anyone give a working redundant management server configuration example files with 2 (I guess Smith don't like this :-) or 3 machine configuration.
Any ideas on using the cluster with only 2 machines in the near future cluster versions or can we do something for the existing versions.

config.ini
========
# Options affecting ndbd processes on all data nodes:
[NDBD DEFAULT]
NoOfReplicas=2
DataMemory=80M
IndexMemory=18M
Diskless= Y


[COMPUTER]
Id= 1
Hostname= 192.168.57.105

[COMPUTER]
Id= 2
Hostname= 192.168.57.106

# Management process 1
[NDB_MGMD]
Id= 1
ExecuteOnComputer= 1
ArbitrationRank= 1
PortNumber=10001
Datadir=/var/lib/mysql-cluster

# Management process 1
[NDB_MGMD]
Id= 2
ExecuteOnComputer= 2
ArbitrationRank= 2
PortNumber=10002
Datadir=/var/lib/mysql-cluster

# Options for Data node process 1
[NDBD]
Id= 3
ExecuteOnComputer= 1
Datadir=/var/lib/mysql-cluster

# Options for data node process 2
[NDBD]
Id= 4
ExecuteOnComputer= 2
Datadir=/var/lib/mysql-cluster

# SQL node process 1
[MYSQLD]
Id= 5
ExecuteOnComputer= 1
ArbitrationRank= 0

# SQL node process 2
[MYSQLD]
Id= 6
ExecuteOnComputer= 2
ArbitrationRank= 0

Datadir=/var/lib/mysql-cluster

# Options for data node process 2
[NDBD]
Id= 4
ExecuteOnComputer= 2
Datadir=/var/lib/mysql-cluster

# SQL node process 1
[MYSQLD]
Id= 5
ExecuteOnComputer= 1
ArbitrationRank= 0

# SQL node process 2
[MYSQLD]
Id= 6
ExecuteOnComputer= 2
ArbitrationRank= 0

my.cnf
======

# Additions to my.cnf for MySQL Cluster
# Enable ndbcluster storage engine, and provide connectstring for
# management server host

# Options for mysqld process:
[MYSQLD]
ndbcluster # run NDB engine
ndb-connectstring="192.168.57.105:10001,192.168.57.106:10002" # location of MGM nodes

[NDBD]
connect-string="nodeid=3;host=192.168.57.105:10001,host=192.168.57.106:10002"

[NDB_MGM]
connect-string="nodeid=3;host=192.168.57.105:10001,host=192.168.57.106:10002"

# Options for ndbd process:
#[MYSQL_CLUSTER]
#ndb-connectstring="192.168.57.105:10001, 192.168.57.106:10002" # location of MGM nodes