PDA

View Full Version : MySQL cluster backup through internet



chanduyadavk
January 19th, 2009, 11:24 PM
Hai,

I have a group of MySQL cluster datanodes behind public-IP address.Please help me how to configure ZRM to copy backup from all data nodes using single public-IP address.

I could connect to management node using port 1186.
Backup is started and stored in data nodes.
But while copying i could copy only from single data node as i could not do port forwarding in my router for SSH-COPY for more than one private-ip for data node.

Iam using SUSE linux in all ZRM server, Management node, Data node1 and Data node2.

Iam using ZRM Enterprise 3.0 version.Is there any other parameter in mysql-zrm.conf other than ndb-connectstring to taker backup of MySQL Cluster.

In the management node config.ini file, i have configured data nodes using hostnames rather than giving private-ip.So that when ZRM server contacts management node, it gets information about all data nodes in the form of hostnames.

Now i have only one public-ip.So in the ZRM /etc/hosts file for data nodes i gave same public-ip.Because of this it is copying backup from only one node.


Regards,
Chandu

chanduyadavk
February 1st, 2009, 08:26 PM
Hey it is solved by creating /root/.ssh/config file with following information
Host data-node1
Hostname public-ip)
Port 22
User mysql

Host data-node2
Hostname with public-ip)
Port 8722
User mysql

adaliabarclay
May 18th, 2009, 09:20 PM
Hey it is solved by creating /root/.ssh/config file with following information
Host data-node1
Hostname public-ip)
Port 22
User mysql

Host data-node2
Hostname with public-ip)
Port 8722
User mysql

Its Really Work Thanks For sharing