Re: stopping sql node - Kishore Jalleda - com.mysql.lists.cluster

15 messages in com.mysql.lists.clusterRe: stopping sql node

From	Sent On	Attachments
pare	03 May 2006 03:54
Ross McFarland	03 May 2006 07:20
pare	04 May 2006 02:43
Jacob Becker	04 May 2006 07:19
Arne Hueggenberg	04 May 2006 07:49
pare	04 May 2006 08:43
Ross McFarland	04 May 2006 08:50
pare	08 May 2006 09:34
Kishore Jalleda	08 May 2006 10:01
pare	08 May 2006 10:30
Kishore Jalleda	08 May 2006 10:46
Geert Vanderkelen	08 May 2006 11:00
pare	08 May 2006 12:17
Geert Vanderkelen	08 May 2006 14:17
Stewart Smith	08 May 2006 21:51

Subject:	Re: stopping sql node
From:	Kishore Jalleda (kjal...@gmail.com)
Date:	05/08/2006 10:46:31 AM
List:	com.mysql.lists.cluster

On 5/8/06, pare <pare...@yahoo.com> wrote:

Thanks a lot.

Basically, if I want to stop the SQL node, I use "kill <pid>" signal to kill the process? There is no other way of doing this?

Thanks, pare

Kishore Jalleda <kjal...@gmail.com> wrote: On 5/8/06, pare wrote:

Hi,

Is it possible to stop an sql node (that is connected to ndb cluster) via

management node or any other CLI gracefully? By gracefully I am trying to avoid "kill -9 "? Stop and start commands in the ndb_mgm is only for data nodes, wonder if there is something for sql nodes as well? Would anyone know?

Thanks, P.

No you cannot start/stop SQL nodes via the MGM node using any native cluster commands (i.e. node_id stop/start), but if you have a lot of SQL nodes you want to manage remotely, you can setup passwordless logins via SSH using keys and then issue shell commands remotely )

The best way to shutdown an SQL node is using mysqladmin like this #mysqladmin -uroot -p shutdown

This would terminate mysqld gracefully .....