Re: ndb_restore error.....
Hi,
It means that you already had 2 MySQL Servers connected to the cluster. Also the ndb_restore
requires a MYSQLD section in the configuration file. So add one more MYSQLD section and
perform rolling upgrade of your cluster to make the nodes aware of the new MYSQLD section.
Rgrds Mikael
kim sungtae wrote:
> hi...
>
> i am testing mysql cluster with 3 linux machine(1
> ndb_mgm , 2 api).
>
> i want to know how to restore after backup.
>
> error message
>
> ndb_restore -b 1 -r -n 2
> --ndb-connectstring=192.168.0.1:1186
> Ndb version in backup files: Version 4.1.11
> Configuration error: Could not alloc node id at
> 192.168.0.1 port 1186: No free node id found for
> mysqld(API).
> Failed to connect to ndb!!
>
> what's mean that error message.....
>
> my config.ini
>
>
> NoOfReplicas=2
> DataMemory=140M
> IndexMemory=40M
> MaxNoOfAttributes=2000
> TransactionDeadlockDetectionTimeout=12000
>
>
>
> portnumber=2202
>
> HostName=192.168.0.1
>
> HostName=192.168.0.2
> DataDir= /home/mysql
>
> HostName=192.168.0.3
> DataDir=/home/ndb
>
>
>
> Thanks for your help,
>
> sungtae.
Mikael Ronstrom
Senior Software Architect, MySQL AB
My blog:
http://mikaelronstrom.blogspot.com