Bug #23547 Please make default ArbitrationRank = 2 for MySQLD nodes

• Submitted: 23 Oct 2006 9:31
• Modified: 23 Oct 2006 11:30
• Reporter: Roland Bouman
• Status: Verified
• Category: MySQL Cluster: Cluster (NDB) storage engine
• Severity: S4 (Feature request)
• Version: mysql-5.1
• OS: Any
• CPU Architecture: Any
• Tags: 5.1.13 bk, ArbitrationRank, mysqld
• Triage: Triaged: D5 (Feature request)

[23 Oct 2006 9:31] Roland Bouman

Description:
Currently, the default arbitrationrank for MySQLD nodes is 0. 

This means that a cluster without custom configuration of ArbitratonRank that loses it's last management node only needs to suffer a crash of one datanode before the cluster goes down as whole, because there will be no arbitrators left.

How to repeat:
Please start a cluster using a default setup such as the one appearing in http://dev.mysql.com/doc/refman/5.1/en/mysql-cluster-config-example.html

First, take down the management server. The cluster will remain up and running.

Then, take down one of the datanodes. The other node will suffer forced close down because there are no arbitrators. 

Suggested fix:
Please make the default ArbitrationRank for MySQLD nodes 2 or 1, not 0