节点切换后,数据节点不能立刻访问,需要等待近40秒,如何解决
mysql-5.7.29 ndb-7.5.17
主机A,一个管理节点,数据节点和SQL节点。主用数据节点。
主机B,一个管理节点,数据节点和SQL节点。
将主机A重启,
主机B访问mysql报错 ERROR 1296 (HY000): Got error 4009 'Cluster Failure' from NDBCLUSTER
需要等待 40s左右,才可以正常访问
/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]
Subject
Views
Written By
Posted
节点切换后,数据节点不能立刻访问,需要等待近40秒,如何解决
65
January 08, 2025 04:40AM
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.