Bug #24880 Removing or replacing the 'Master'-word from SHOW output
Submitted: 7 Dec 2006 11:14 Modified: 6 Nov 2013 16:33
Reporter: Geert Vanderkelen Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Cluster: Cluster (NDB) storage engine Severity:S4 (Feature request)
Version:mysql-5.1 OS:Any
Assigned to: Lakshmi Narayanan Sreethar CPU Architecture:Any
Tags: master, NDB_MGM, show

[7 Dec 2006 11:14] Geert Vanderkelen 
Description:

Currently the output of the SHOW command in the ndb_mgm CLI is showing the Master node. This is fine, though it might confuse people with Master/Slave for example or make people believe that this is the only node getting transactions.

It's not really useful to show what node the Master is, only for debugging. So totally removing any marking is also not good.

A problem changing this might be applications which rely on this output.

How to repeat:
shell> ndb_mgm -e "SHOW"
Connected to Management Server at: localhost:1186
Cluster Configuration
---------------------
[ndbd(NDB)]     1 node(s)
id=3    @10.100.9.6  (Version: 5.1.14, Nodegroup: 0, Master)

[ndb_mgmd(MGM)] 1 node(s)
id=1    @10.100.9.6  (Version: 5.1.14)

[mysqld(API)]   3 node(s)
id=7 (not connected, accepting connect from ndbsup-priv-1)
id=8 (not connected, accepting connect from any host)
id=9 (not connected, accepting connect from any host)

Suggested fix:

Replace 'Master' with a '*' somewhere, like:

shell> ndb_mgm -e "SHOW"
Connected to Management Server at: localhost:1186
Cluster Configuration
---------------------
[ndbd(NDB)]     1 node(s)
id=3    @10.100.9.6  (Version: 5.1.14, Nodegroup: 0, *)
[7 Dec 2006 11:15] Geert Vanderkelen 
It is worth considering this change and cluster devs tent to agree, so setting it to 'Verified'.
[6 Nov 2013 16:33] Jon Stephens 
Documented fix int he NDB 7.0.39, 7.1.29, 7.2.14, and 7.3.3 changelogs, as follows:

        Formerly, the node used as the coordinator or leader for
        distributed decision making between nodes (also known as the
        DICT manager--see the /NDB Internals Guide/) was
        indicated in the output of the ndb_mgm client SHOW command as
        the master node, although this has no relationship to a master
        server in MySQL Replication. (It should also be noted that it is
        not necessary to know which node is the leader except when
        debugging NDBCLUSTER source code.) To avoid possible confusion,
        this label has been removed, and the leader node is now
        indicated in SHOW command output using an asterisk (*)
        character.

Also updated relevant examples in the Manual, and Cluster FAQ.

Closed.