Bug #53008 ndb_mgmd should have a way to switch off the config cache and communications
Submitted: 20 Apr 2010 21:01 Modified: 17 May 2010 12:25
Reporter: Andrew Hutchings Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Cluster: Cluster (NDB) storage engine Severity:S4 (Feature request)
Version:mysql-5.1-telco-7.0 OS:Any
Assigned to: John David Duncan CPU Architecture:Any
Tags: config cache

[20 Apr 2010 21:01] Andrew Hutchings 
Description:
In some cases it is preferable to specify a config.ini in each management node.  This does not always work out so well in 7.0 due to the configuration caching and transmission between data nodes.

I propose a new option to disable this behaviour

How to repeat:
.

Suggested fix:
Add a setting such as --no-config-cache
[24 Apr 2010 2:55] Bugs System 
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/106456

3506 John David Duncan	2010-04-23
      This is a possible fix for bug#53008 -- it needs a review by Magnus plus 
      verification by support
[24 Apr 2010 2:55] Bugs System 
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/106457

3506 John David Duncan	2010-04-23
      This is a possible fix for bug#53008 -- it needs a review by Magnus plus      
      verification by support
[27 Apr 2010 18:09] Bugs System 
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/106720

3509 John David Duncan	2010-04-27
      bug#53008 -- support new option, --config-mode=shared (default) or --config-mode=local
[27 Apr 2010 21:48] Bugs System 
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/106740

3509 John David Duncan	2010-04-27
      Another alternative for bug#53008.  This one actually implements --skip-config-cache, --disable-config-cache, etc., as requested in the bug report.
[28 Apr 2010 19:57] Bugs System 
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/106870

3509 John David Duncan	2010-04-28
      bug#53008 -- revised version of the previous patch.  This time the default value is for the config cache to be enabled.
[10 May 2010 19:36] Bugs System 
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/107886

3509 John David Duncan	2010-05-10
      bug#53008: implement --skip-config-cache option to ndb_mgmd, causing the ConfigManager thread to exit on startup; create a test case in testMgmd.  (In the previous patch, the thread went to sleep rather than exiting).
[11 May 2010 6:56] Magnus Blåudd 
Approved by email, one minor comment to fix when merging into 7.0
[12 May 2010 11:03] Jon Stephens 
I'm concerned that the name for this option could be confusing to MySQL users who might assume that a --skip-config-cache option implies that there's a --config-cache option as well.

Suggestions:

1. Name the option --config-cache : default true|1; set to false|0 to disable the cache (me).

2. Name the option --ignore-config-cache but use the same behaviour as already set for --skip-config.cache (BOcklin).

I think BOcklin's suggestion (#2) is probably better.

After discussing with him, I've set bug status back to Open so this can be changed before documenting.
[12 May 2010 12:12] Magnus Blåudd 
We added --config-cache=true as default. That automatically measn you get support for --skip-config-cache, --config-cache=0, --config-cache=false as aliases to turn it off.
[12 May 2010 15:54] Jon Stephens 
Fantastic, thanks for the clarification.
[17 May 2010 12:25] Jon Stephens 
Documented feature addition in the NDB-7.0.15 and 7.1.4 changelogs as follows:

        Added the MySQL Cluster management server option --config-cache,
        which makes it possible to enable and disable configuration
        caching. This option is turned on by default; to disable
        configuration caching, start ndb_mgmd with --config-cache=0 (or
        OFF), or with --skip-config-cache.

Also updated Manual section covering ndb_mgmd with new option info.

Closed.