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