List:General Discussion« Previous MessageNext Message »
From:Aastha Date:September 23 2012 5:28pm
Subject:Re: Mysql cluster installation error
View as plain text  
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 <ntnmht@stripped> 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 <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