Thanks Nitin. I specied the location of my.ini while starting the SQL node and it worked fine.
I have anothe rquestion : How to connect the cluster and reomte host. And i have to copy a schema from one Mysql clsuter to another. How do i do that. Regards, On Sun, Sep 23, 2012 at 3:13 AM, Nitin Mehta <ntn...@yahoo.com> wrote: > Hi Aastha, > > I'm not 100% sure but you could try defining the full connectstring using: > > ndb-connectstring = localhost:1186 > > See if that helps. > > Regards, > > > ________________________________ > From: Aastha <aast...@gmail.com> > To: mysql@lists.mysql.com > Sent: Sunday, September 23, 2012 7:51 AM > Subject: Mysql cluster installation error > > Hello, > > I am trying to install MySQL cluster on three physical machines. > Management Node on one machine. > Data Node on two machines. > SQL node on the same machine as Management Node. > > Management node started > Data Nodes started > *SQL node started but not connected to Management NOde and it gives no > error * > > C:\mysql\bin>ndb_mgm -e show > Connected to Management Server at: localhost:1186 > Cluster Configuration > --------------------- > [ndbd(NDB)] 2 node(s) > id=8 @172.16.56.8 (mysql-5.5.25 ndb-7.2.7, Nodegroup: 0, Master) > id=9 @172.16.56.9 (mysql-5.5.25 ndb-7.2.7, Nodegroup: 0) > > [ndb_mgmd(MGM)] 1 node(s) > id=6 @172.16.56.7 (mysql-5.5.25 ndb-7.2.7) > > [mysqld(API)] 1 node(s) > id=7 (not connected, accepting connect from 172.16.56.7) > > > *config.ini* > > [ndbd default] > # Options affecting ndbd processes on all data nodes: > NoOfReplicas=2 # Number of replicas > DataDir=C:/mysql/bin/cluster-data # Directory for each data node's data > files > DataMemory=80M # Memory allocated to data storage > IndexMemory=18M # Memory allocated to index storage > > [ndb_mgmd] > # Management process options: > HostName=172.16.56.7 # Hostname or IP address of management > node > DataDir=C:/mysql/bin/cluster-logs # Directory for management node log > files > NodeId=5 > > [ndbd] > # Options for data node "A": > HostName=172.16.56.8 # Hostname or IP address > NodeId=8 > MaxNoOfOrderedIndexes=1024 > MaxNoOfAttributes=3000 # added 2012.8.08 > > [ndbd] > # Options for data node "B": > HostName=172.16.56.9 # Hostname or IP address > NodeId=9 > MaxNoOfOrderedIndexes=1024 > MaxNoOfAttributes=3000 # added 2012.8.08 > > > > [mysqld] > # SQL node options: > HostName=172.16.56.7 # Hostname or IP address > NodeId=7 > > *my.ini* > * > * > [mysql_cluster] > # Options for management node process > config-file=c:/mysql/bin/config.ini > configdir=c:/mysql/bin/cluster-cache/ > > > [mysqld] > # Options for mysqld process: > ndbcluster # run NDB storage engine > ndb-connectstring=172.16.56.7 # location of management server > ndb-nodeid=7 > server-id=7 > default-storage-engine=ndbcluster > > > Could anyone help to identify/ > > > Aastha Gupta >
