Description:
I have a 2 node cluster with DiskBased tables.
We made a sucsesfull backup with : start backup.
We stopped all ndbd en mysql processes
removed the datafiles as suggested by Jonathan's Blog
When we start the restore we get the following error:
Backup version in files: ndb-6.3.11 ndb version: mysql-5.1.30 ndb-6.3.20
Failed to connect to ndb!!
Failed to initialize consumers
NDBT_ProgramExit: 1 - Failed
--------------------------------------
MGT_NODE config.ini
[NDBD DEFAULT]
# No of replicas
NoOfReplicas=2
BackupDataDir=/data
DataMemory=1024M
IndexMemory=128M
[MYSQLD DEFAULT]
[NDB_MGMD DEFAULT]
[TCP DEFAULT]
SendBufferMemory=128M
# Managment Server
[NDB_MGMD]
# the IP of THIS SERVER
Id=1
Hostname=172.19.4.39
ArbitrationRank=1
# Storage Engines
[NDBD]
# the IP of the FIRST SERVER (STORAGE NODE)
HostName=172.19.4.37
DataDir=/data/mysql
MaxNoOfOrderedIndexes = 4096
MaxNoOfAttributes = 5000
[NDBD]
# the IP of the SECOND SERVER (STORAGE NODE)
HostName=172.19.4.38
DataDir=/data/mysql
MaxNoOfOrderedIndexes = 4096
MaxNoOfAttributes = 5000
# 2 MySQL Clients
# I personally leave this blank to allow rapid changes of the mysql clients;
# you can enter the hostnames of the above two servers here. I suggest you dont.
[MYSQLD]
[MYSQLD]
[MYSQLD]
[MYSQLD]
How to repeat:
started ndbd --initial
root 19203 1 0 11:12 ? 00:00:00 ndbd --initial
root 19204 19203 0 11:12 ? 00:00:02 ndbd --initial
start the restore:
ndb_restore -b2 -c 172.19.4.39:1186 -n 3 --backup_path=/data/mysql/BACKUP/BACKUP-2 -r
output:
Backup Id = 2
Nodeid = 3
backup path = /data/mysql/BACKUP/BACKUP-2
Opening file '/data/mysql/BACKUP/BACKUP-2/BACKUP-2.3.ctl'
Backup version in files: ndb-6.3.11 ndb version: mysql-5.1.30 ndb-6.3.20
Failed to connect to ndb!!
Failed to initialize consumers
NDBT_ProgramExit: 1 - Failed