How to Display the connected MySQL Node using the NDB Cluster Management Client

Posted on

Introduction

This is an article where the content is presenting on how to display MySQL Node Database Management Client. The main information about the tool where it is also a command executed in the command lin interface is available in this link. According to the link, the tool or the command ‘ndb_mgm’ The ndb_mgm management client process is actually not needed to run the cluster. Its value lies in providing a set of commands for checking the cluster’s status, starting backups, and performing other administrative functions. The management client accesses the management server using a C API. Advanced users can also employ this API for programming dedicated management processes to perform tasks similar to those performed by ndb_mgm.

Actually, the ‘ndb_mgm’ is one of the available part of the NDB Cluster program according in this link.

The following steps will show how to achieve it. Those steps are exist as follows :

1. First of all, just make sure that the ‘ndb_mgm’ tool or command available in the operating system. The following steps will show how to achieve it. Those steps are exist as follows :

[user@hostname ~]$ ndb_mgm
-- NDB Cluster -- Management Client --
ndb_mgm>

2. Next, don’t forget to execute the command for presenting or displaying the connected node. Just type the command ‘show’ in the NDB Cluster Management Client as follows :

[user@hostname ~]$ ndb_mgm
-- NDB Cluster -- Management Client --
ndb_mgm> show
Unable to connect with connect string: nodeid=0,localhost:1186
Retrying every 5 seconds. Attempts left: 2 1, failed.
ndb_mgm> 

From the output above, there is no connected node exist or available to the NDB Cluster. The output of the above command execution, in this context the ‘show’ command in the NDB Cluster Management Console will be different from one machine with another machine. It depends on the environment of the machine. The following is another output which is slightly different with the above one :

ndb_mgm> show
Cluster Configuration
---------------------
[ndbd(NDB)] 2 node(s)
id=1    @127.0.0.1  (mysql-5.7.27 ndb-7.6.11, starting, Nodegroup: 0)
id=2 (not connected, accepting connect from localhost)

[ndb_mgmd(MGM)] 1 node(s)
id=3    @127.0.0.1  (mysql-5.7.27 ndb-7.6.11)

[mysqld(API)]   3 node(s)
id=4 (not connected, accepting connect from localhost)
id=5 (not connected, accepting connect from localhost)
id=6 (not connected, accepting connect from localhost)

ndb_mgm> 

The output above is different. It has a node connected.

Leave a Reply