Re: Mysql cluster installation error

2012-09-23 Thread Nitin Mehta
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

Re: Mysql cluster installation error

2012-09-23 Thread Aastha
, 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

Re: Mysql cluster installation error

2012-09-23 Thread Michael Dykman
If all you need to transfer is schema, do it the same way you would any other table type: use mysqldump with the - - no-data option. On 2012-09-23 1:29 PM, Aastha aast...@gmail.com wrote: Thanks Nitin. I specied the location of my.ini while starting the SQL node and it worked fine. I have

Re: Mysql cluster installation error

2012-09-23 Thread Aastha
Thanks! And how do i connect the cluster from the remote host. When i try to connect one of the SQL node through remote host it says access denied. WHile the same is working fine from local host. Kindly help. Thanks! On Sun, Sep 23, 2012 at 12:35 PM, Michael Dykman mdyk...@gmail.com wrote: If

Re: Mysql cluster installation error

2012-09-23 Thread Michael Dykman
If your remote host is not configured as a sql node to your cluster, you don't need to just to import the schema. Run mysqldump on any client machine specifying any of your configured sql nodes via -host=. On 2012-09-23 1:40 PM, Aastha aast...@gmail.com wrote: Thanks! And how do i connect the

RE: Mysql cluster installation error

2012-09-23 Thread Martin Gainty
uebernehmen. Date: Sun, 23 Sep 2012 12:40:17 -0500 Subject: Re: Mysql cluster installation error From: aast...@gmail.com To: mdyk...@gmail.com CC: mysql@lists.mysql.com Thanks! And how do i connect the cluster from the remote host. When i try to connect one of the SQL node through remote host

Mysql cluster installation error

2012-09-22 Thread Aastha
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