Re: Clean way to remove server from cluster, and more

[Stewart Smith]

Sam Lalonde wrote:
> But I cannot stop the API:
>
> ndb_mgm> 5 stop
> Shutdown failed.
> * 2002: Stop failed
> * The process has wrong type. Expected a DB
> process.
>
> Is this normal?

Yes, use the normal method to shut down the API node. Assuming it's a mysql server, you can do 'mysqladmin -u root shutdown' on that machine.

> Also, should I be able to restart the NDB from the
> management server?

there is a parameter to pass to ndbd to start the process, but not start the storage node (so the start command in ndb_mgm will work). Check the manual... the name of the parameter escapes me at the moment.

> Also, to clarify backups -- when I issue the
> backup command, is ALL of the data backed up and
> stored on every (NDB?) server, or is it spread
> across?

Spread across. Copy the backup directory from all your nodes to a central location.

> In the case of restore, does it need to run on
> each server or would it be the same to run the
> restore on ONE server, then do ndbd --initial on
> the other?

the restore program will transfer the data around in the right way.

> Is there a way to script a backup without manually
> doing it in ndb_mgm?

ndb_mgm -e show
ndb_mgm -e shutdown

the -e option means 'evaluate' or 'execute' this command. you can put whatever you like there. for example, backup.