Bug #48502 Several configuration parameters should not differ between DB nodes

• Submitted: 3 Nov 2009 13:18
• Reporter: Magnus Blåudd
• Status: Verified
• Category: MySQL Cluster: Cluster (NDB) storage engine
• Severity: S3 (Non-critical)
• Version: mysql-5.1-telco-6.3
• OS: Any
• CPU Architecture: Any
• Tags: 6.3.28

[3 Nov 2009 13:18] Magnus Blåudd

Description:
There are quite a few configuration parameters for MySQL Cluster that can be set different for each DB node  but in fact should not be allowed to differ between nodes.

They are quite easily identified since their help text follow the pattern "Total number of XXX that can be defined in the system"

MaxNoOfTables
MaxNoOfOrderedIndexes
MaxNoOfUniqueHashIndexes
MaxNoOfIndexes
MaxNoOfConcurrentIndexOperations
MaxNoOfTriggers
and so on...

How to repeat:
MCI

Suggested fix:
Check that all of the idenitifed parameters are defined the same on all DB nodes. In case a value that differs found print a warning describing the problem, it should probably also be possible to turn on "Strict" more where the above warning is turned into an error.

[3 Nov 2009 13:21] Magnus Blåudd

We could probably also upgrade the values to the highest specified value.