MySQL Forums
Forum List  »  NDB clusters

How to shorten the time after data node switchover
Posted by: XIELEI YANG
Date: January 08, 2025 04:33AM

Host A, a management node, data node and SQL node. The main data node.
Host B, a management node, data node and SQL node.

Reboot host A.
Host B accessing mysql reports error ERROR 1296 (HY000): Got error 4009 'Cluster Failure' from NDBCLUSTER
Wait about 40s for normal access.


/usr/local/app/mysql-cluster/config.ini
[tcp default]
SendBufferMemory=2M
ReceiveBufferMemory=2M

[ndbd default]
NoOfReplicas=2 ## data num
DataMemory=2048M
IndexMemory=640M

LockPagesInMainMemory=1
NoOfFragmentLogFiles=300
SchedulerSpinTimer=400
SchedulerExecutionTimer=100
RealTimeScheduler=1
TimeBetweenGlobalCheckpoints=1000
TimeBetweenEpochs=200
RedoBuffer=32M
TimeBetweenLocalCheckpoints=6

MaxNoOfOrderedIndexes=512
MaxNoOfConcurrentOperations=100000

## mng
[ndb_mgmd]
NodeId=1
hostname=10.188.68.45
datadir=/usr/local/app/mysql-cluster/

[ndb_mgmd]
NodeId=2
hostname=10.188.68.46
datadir=/usr/local/app/mysql-cluster/


## data
[ndbd]
NodeId=11
hostname=10.188.68.45
datadir=/usr/local/app/mysql/data
StopOnError=0
StartPartialTimeout=1000
StartPartitionedTimeout=1000
TransactionDeadLockDetectionTimeOut=60000
[ndbd]
NodeId=12
hostname=10.188.68.46
datadir=/usr/local/app/mysql/data
StopOnError=0
StartPartialTimeout=1000
StartPartitionedTimeout=1000
TransactionDeadLockDetectionTimeOut=60000

## sql
[mysqld]
NodeId=21
hostname=10.188.68.45
[mysqld]
NodeId=22
hostname=10.188.68.46
[mysqld]

[mysqld]

Options: ReplyQuote


Subject
Views
Written By
Posted
How to shorten the time after data node switchover
58
January 08, 2025 04:33AM


Sorry, only registered users may post in this forum.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.