List:General Discussion« Previous MessageNext Message »
From:Nitin Mehta Date:September 23 2012 8:13am
Subject:Re: Mysql cluster installation error
View as plain text  
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 <aastha3@stripped>
To: mysql@stripped 
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
Thread
Mysql cluster installation errorAastha23 Sep
  • Re: Mysql cluster installation errorNitin Mehta23 Sep
    • Re: Mysql cluster installation errorAastha23 Sep
      • Re: Mysql cluster installation errorMichael Dykman23 Sep
        • Re: Mysql cluster installation errorAastha23 Sep
Re: Mysql cluster installation errorMichael Dykman23 Sep
RE: Mysql cluster installation errorMartin Gainty24 Sep