From: Nitin Mehta Date: September 23 2012 8:13am Subject: Re: Mysql cluster installation error List-Archive: http://lists.mysql.com/mysql/228230 Message-Id: <1348387986.52264.YahooMailNeo@web120004.mail.ne1.yahoo.com> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="1265908415-771836445-1348387986=:52264" --1265908415-771836445-1348387986=:52264 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: quoted-printable Hi Aastha,=0A=A0=0AI'm not 100% sure but you could try defining the full co= nnectstring using:=0A=A0=0Andb-connectstring =3D localhost:1186=0A=A0=0ASee= if that helps.=0A=A0=0ARegards,=0A =0A=0A________________________________= =0A From: Aastha =0ATo: mysql@stripped =0ASent: S= unday, September 23, 2012 7:51 AM=0ASubject: Mysql cluster installation err= or=0A =0AHello,=0A=0AI am trying to install MySQL cluster on three physica= l machines.=0AManagement Node on one machine.=0AData Node on two machines.= =0ASQL node on the same machine as Management Node.=0A=0AManagement node st= arted=0AData Nodes started=0A*SQL node started but not connected to Managem= ent NOde and it gives no=0Aerror *=0A=0AC:\mysql\bin>ndb_mgm -e show=0AConn= ected to Management Server at: localhost:1186=0ACluster Configuration=0A---= ------------------=0A[ndbd(NDB)]=A0 =A0 2 node(s)=0Aid=3D8=A0 =A0 @172.16.= 56.8=A0 (mysql-5.5.25 ndb-7.2.7, Nodegroup: 0, Master)=0Aid=3D9=A0 =A0 @172= .16.56.9=A0 (mysql-5.5.25 ndb-7.2.7, Nodegroup: 0)=0A=0A[ndb_mgmd(MGM)] 1 n= ode(s)=0Aid=3D6=A0 =A0 @172.16.56.7=A0 (mysql-5.5.25 ndb-7.2.7)=0A=0A[mysql= d(API)]=A0 1 node(s)=0Aid=3D7 (not connected, accepting connect from 172.1= 6.56.7)=0A=0A=0A*config.ini*=0A=0A[ndbd default]=0A# Options affecting ndbd= processes on all data nodes:=0ANoOfReplicas=3D2=A0 =A0 =A0 =A0 =A0 =A0 =A0= =A0 =A0 =A0 # Number of replicas=0ADataDir=3DC:/mysql/bin/cluster-data=A0 = # Directory for each data node's data=0Afiles=0ADataMemory=3D80M=A0 =A0 # = Memory allocated to data storage=0AIndexMemory=3D18M=A0 # Memory allocated= to index storage=0A=0A[ndb_mgmd]=0A# Management process options:=0AHostNam= e=3D172.16.56.7=A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 # Hostname or IP address of = management=0Anode=0ADataDir=3DC:/mysql/bin/cluster-logs=A0 # Directory for= management node log=0Afiles=0ANodeId=3D5=0A=0A[ndbd]=0A# Options for data = node "A":=0AHostName=3D172.16.56.8=A0 =A0 =A0 =A0 =A0 # Hostname or IP addr= ess=0ANodeId=3D8=0AMaxNoOfOrderedIndexes=3D1024=0AMaxNoOfAttributes=3D3000 = # added 2012.8.08=0A=0A[ndbd]=0A# Options for data node "B":=0AHostName=3D1= 72.16.56.9=A0 =A0 =A0 =A0 =A0 # Hostname or IP address=0ANodeId=3D9=0AMaxN= oOfOrderedIndexes=3D1024=0AMaxNoOfAttributes=3D3000 # added 2012.8.08=0A=0A= =0A=0A[mysqld]=0A# SQL node options:=0AHostName=3D172.16.56.7=A0 =A0 =A0 = =A0 =A0 # Hostname or IP address=0ANodeId=3D7=0A=0A*my.ini*=0A*=0A*=0A[mysq= l_cluster]=0A# Options for management node process=0Aconfig-file=3Dc:/mysql= /bin/config.ini=0Aconfigdir=3Dc:/mysql/bin/cluster-cache/=0A=0A=0A[mysqld]= =0A# Options for mysqld process:=0Andbcluster=A0 =A0 =A0 =A0 =A0 =A0 =A0 = =A0 =A0 =A0 =A0 # run NDB storage engine=0Andb-connectstring=3D172.16.56.7= =A0 # location of management server=0Andb-nodeid=3D7=0Aserver-id=3D7=0Adefa= ult-storage-engine=3Dndbcluster=0A=0A=0ACould anyone help to identify/=0A= =0A=0AAastha Gupta --1265908415-771836445-1348387986=:52264--