PDA

View Full Version : Port through which ZRM restore cluster backup



chanduyadavk
January 28th, 2009, 11:25 PM
Hai i took backup of MySQL Cluster 6.3.20 using ZRM Enterprise edition 3.0 through internet.I have forwarded the following two ports

ssh port 22
Management node port 1186


When i try to retore the cluster backup through internet , it is failing.Here below i give the output


DailyBackup_SSH:restore:INFO: Mail address: ofi.blr.managed.srvc@opticalfusion.net is ok
DailyBackup_SSH:restore:INFO: ZRM Temporary configuration file = /etc/mysql-zrm/DailyBackup_SSH/tmpkcj3Z.conf
DailyBackup_SSH:restore:INFO: {
DailyBackup_SSH:restore:INFO: verbose=1
DailyBackup_SSH:restore:INFO: encrypt-plugin=/usr/share/mysql-zrm/plugins/encrypt.pl
DailyBackup_SSH:restore:INFO: ndb-connectstring=10.0.0.111:1186
DailyBackup_SSH:restore:INFO: all-databases=1
DailyBackup_SSH:restore:INFO: decrypt-option=-d
DailyBackup_SSH:restore:INFO: source-directory=/var/lib/mysql-zrm/DailyBackup_SSH/20090129232852
DailyBackup_SSH:restore:INFO: password=******
DailyBackup_SSH:restore:INFO: backup-mode=raw
DailyBackup_SSH:restore:INFO: backup-type=regular
DailyBackup_SSH:restore:INFO: compress-plugin=/usr/bin/gzip
DailyBackup_SSH:restore:INFO: user=mysql_backup_usr
DailyBackup_SSH:restore:INFO: copy-plugin=/usr/share/mysql-zrm/plugins/ssh-cop
DailyBackup_SSH:restore:INFO: backup-level=0
DailyBackup_SSH:restore:INFO: encrypt=/usr/share/mysql-zrm/plugins/encrypt.pl
DailyBackup_SSH:restore:INFO: mailto=ofi.blr.managed.srvc@opticalfusion.net
DailyBackup_SSH:restore:INFO: ssh-user=mysql
DailyBackup_SSH:restore:INFO: compress=/usr/bin/gzip
DailyBackup_SSH:restore:INFO: }
DailyBackup_SSH:restore:INFO: Getting ndb version
DailyBackup_SSH:restore:INFO: Command used is ndb_mgm --ndb-connectstring=10.0.0
DailyBackup_SSH:restore:INFO: ndb version = MySQL distrib mysql-5.1.30 ndb-6.3.2 NFO: Getting ndb data node details
DailyBackup_SSH:restore:INFO: Command used is ndb_config --ndb-connectstring=10. rows='\n'
DailyBackup_SSH:restore:INFO: output = 10,data-node,/var/lib/mysql-cluster/backu
20,Data-node2,/var/lib/mysql-cluster/backup
DailyBackup_SSH:restore:INFO: Command used is 'cat "/var/lib/mysql-zrm/DailyBack lugins/encrypt.pl" -d | "/usr/bin/gzip" -d | tar --same-owner -xpsC "/var/li d'
DailyBackup_SSH:restore:INFO: from-node-id = all
Failed to connect to ndb!!
Failed to initialize consumers
DailyBackup_SSH:restore:ERROR: Output of command: 'ndb_restore' is {
Nodeid = 10
Backup Id = 9
backup path = /var/lib/mysql-zrm/DailyBackup_SSH/20090129232852/10/BACKUP-9
Opening file '/var/lib/mysql-zrm/DailyBackup_SSH/20090129232852/10/BACKUP-9/BAC KUP-9.10.ctl'
Backup version in files: ndb-6.3.11 ndb version: mysql-5.1.30 ndb-6.3.20

NDBT_ProgramExit: 1 - Failed

}
DailyBackup_SSH:restore:ERROR: ndb_restore from '10' failed
DailyBackup_SSH:restore:INFO: Output of command: 'ndb_restore' is {
Nodeid = 10
Backup Id = 9
backup path = /var/lib/mysql-zrm/DailyBackup_SSH/20090129232852/10/BACKUP-9
Opening file '/var/lib/mysql-zrm/DailyBackup_SSH/20090129232852/10/BACKUP-9/BAC KUP-9.10.ctl'
Backup version in files: ndb-6.3.11 ndb version: mysql-5.1.30 ndb-6.3.20

NDBT_ProgramExit: 1 - Failed

}
Failed to connect to ndb!!
Failed to initialize consumers
DailyBackup_SSH:restore:ERROR: Output of command: 'ndb_restore' is {
Nodeid = 20
Backup Id = 9
backup path = /var/lib/mysql-zrm/DailyBackup_SSH/20090129232852/20/BACKUP-9
Opening file '/var/lib/mysql-zrm/DailyBackup_SSH/20090129232852/20/BACKUP-9/BAC KUP-9.20.ctl'
Backup version in files: ndb-6.3.11 ndb version: mysql-5.1.30 ndb-6.3.20

NDBT_ProgramExit: 1 - Failed

}
DailyBackup_SSH:restore:ERROR: ndb_restore from '20' failed
DailyBackup_SSH:restore:INFO: Output of command: 'ndb_restore' is {
Nodeid = 20
Backup Id = 9
backup path = /var/lib/mysql-zrm/DailyBackup_SSH/20090129232852/20/BACKUP-9
Opening file '/var/lib/mysql-zrm/DailyBackup_SSH/20090129232852/20/BACKUP-9/BAC KUP-9.20.ctl'
Backup version in files: ndb-6.3.11 ndb version: mysql-5.1.30 ndb-6.3.20

NDBT_ProgramExit: 1 - Failed

}
DailyBackup_SSH:restore:INFO: Removing all of the uncompressed/unencrypted data
DailyBackup_SSH:restore:ERROR: Restore failed


Thanks in Advance

Regards,
chandu

kulkarni_mangesh
January 29th, 2009, 08:20 PM
Failed to connect to ndb!!
Failed to initialize consumers
DailyBackup_SSH:restore:ERROR: Output of command: 'ndb_restore' is {
Nodeid = 20
Backup Id = 9
backup path = /var/lib/mysql-zrm/DailyBackup_SSH/20090129232852/20/BACKUP-9
Opening file '/var/lib/mysql-zrm/DailyBackup_SSH/20090129232852/20/BACKUP-9/BAC KUP-9.20.ctl'
Backup version in files: ndb-6.3.11 ndb version: mysql-5.1.30 ndb-6.3.20

NDBT_ProgramExit: 1 - Failed

}


Can you please check whether ndb_cluster is running on 1186 or not and open mysql port as well.

chanduyadavk
February 1st, 2009, 08:24 PM
Failed to connect to ndb!!
Failed to initialize consumers
DailyBackup_SSH:restore:ERROR: Output of command: 'ndb_restore' is {
Nodeid = 20
Backup Id = 9
backup path = /var/lib/mysql-zrm/DailyBackup_SSH/20090129232852/20/BACKUP-9
Opening file '/var/lib/mysql-zrm/DailyBackup_SSH/20090129232852/20/BACKUP-9/BAC KUP-9.20.ctl'
Backup version in files: ndb-6.3.11 ndb version: mysql-5.1.30 ndb-6.3.20

NDBT_ProgramExit: 1 - Failed

}


I have opened two ports 1186 and 3306.but the problem here is both the sql nodes/data nodes are listening on 3306.So i could not open 3306 for two data nodes.

Can any one suggest how to restore MySQL cluster backup to all data nodes which are listening on port 3306 through internet.

Thanks in Advance

Regards,
chandu

adaliabarclay
May 18th, 2009, 09:18 PM
It is Running Very Successfully At my side , You haven't any problem with that