views:

256

answers:

0

Hi All,

I have configred mysql cluster management node and data nodes and mysqld on two server's.

Everything is working fine but when i shutdown my first management server then all the nodes get disconnected.

Here's the Cofig.ini

[NDBD DEFAULT] NoOfReplicas=2 # Number of replicas DataMemory=3500M # How much memory to allocate for data storage IndexMemory=1000M # How much memory to allocate for index storage datadir=/usr/local/mysql/data # Directory for this data node's datafiles [TCP DEFAULT] portnumber=2202 # This the default; however, you can use any

Management process options:

[NDB_MGMD DEFAULT] datadir=/var/lib/mysql-cluster # Directory for MGM node logfiles

[NDB_MGMD] id=1 hostname=192.168.1.107 # Hostname or IP address of MGM node

[NDB_MGMD] id=2 hostname=192.168.1.125 # Hostname or IP address of MGM node

Options for data node "A":

[NDBD] id=3 # (one [NDBD] section per data node) hostname=192.168.1.107 # Hostname or IP address

Options for data node "B":

[NDBD] id=4 hostname=192.168.1.125 # Hostname or IP address

SQL node options:

[MYSQLD] id=5 hostname=192.168.1.107

Options for data node "B":

[MYSQLD] id=6 hostname=192.168.1.125 # Hostname or IP address

and this is my.cnf

Options for mysqld process:

[mysqld] ndbcluster # run NDB storage engine ndb-connectstring=192.168.1.107,192.168.1.125 # location of management server

Options for ndbd process:

[mysql_cluster] ndb-connectstring=nodeid=1,192.168.1.107,192.168.1.125 # location of management server