MySQL Bugs: #47366: ndb_config --xml --configinfo: Add restart type for config variables

Bug #47366	ndb_config --xml --configinfo: Add restart type for config variables
Submitted:	16 Sep 13:53	Modified:	4 Nov 15:57
Reporter:	Sivert Sorumgard
Status:	Closed
Category:	Server: Cluster	Severity:	S3 (Non-critical)
Version:	mysql-5.1-telco-7.0	OS:	Any
Assigned to:	Magnus Blaudd	Target Version:
Tags:	7.0.6
Triage:	Triaged: D5 (Feature request) / R6 (Needs Assessment) / E6 (Needs Assessment)

Description:
ndb_config should include information about how to restart nodes for a config variable
change to take effect. This could be done with one attribute "restart" with values
"InitialNode", "Node", "InitialSystem" or "System". Or it could be done with two
attributes: "restart" with values "node" or "system", and "initial" with values "true" or
"false". 

Example: <param name="NoOfReplicas" comment="Number of copies of all data in the database
(1-4)" type="unsigned" default="2" mandatory="true" min="1" max="4" restart="system"
initial="true"/>

How to repeat:
Observe ndb_config --configinfo output; information about when to do restart --initial is
not available.

Thank you for the reasonable feature request.

Will make it possible to flag each parameter with the below suggested flags and then add
the resulting tags in the .xml file based in that.

    /*
      Flags  telling how the system must be restarted for a changed
      parameter to take effect

      Default is none of these flags set, which means node restart
      of one node at a time for the setting to take effect

      CS_RESTART_INITIAL
      Each data node need to be restarted one at a time with --initial

      CS_RESTART_SYSTEM
      The whole system need to be stopped and then started up again

      CS_RESTART_SYSTEM + CS_RESTART_INITIAL
      The whole system need to be stopped and then restarted with --initial
      thus destroying any data in the cluster
    */
    CI_RESTART_SYSTEM = 4, // System restart is necessary to apply setting
    CI_RESTART_INITIAL = 8 // Initial restart is necessary to apply setting

A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/89148

Approved on IRC and phone

Pushed to 6.3 and 7.0.10

Documented bugfix in the NDB-6.3.29 and 7.0.10 changelogs as follows:

        The output from ndb_config --xml --configinfo now includes the
        restart type required for resetting each configuration
        parameter.

Closed.