конфиг имеет следующий вид:
==========================================================
[NDBD DEFAULT]
NoOfReplicas=2
DataMemory=30G
IndexMemory=15G
MaxNoOfTables=1600
MaxNoOfAttributes=10000
MaxNoOfOrderedIndexes=1600
MaxNoOfUniqueHashIndexes=1600
TimeBetweenWatchDogCheck=900000
NoOfFragmentLogFiles=1294967296
FragmentLogFileSize = 114572800
MaxNoOfConcurrentOperations =655360
TransactionDeadlockDetectionTimeout=1073741820
DiskSyncSize=53687091
DiskCheckpointSpeed=107374182
DiskCheckpointSpeedInRestart=214748365
RedoBuffer =107374182
TimeBetweenLocalCheckpoints=6
TransactionDeadlockDetectionTimeout=2073741820
[MYSQLD DEFAULT]
[NDB_MGMD DEFAULT]
[TCP DEFAULT]
[NDB_MGMD]
NodeId: 1
HostName=192.168.0.88 # the IP of THIS SERVER
# Storage Engines
[NDBD]
NodeId: 3
HostName=192.168.0.89 # the IP of the FIRST SERVER
DataDir= /data/mysql-cluster
BackupDataDir= /data/Backup
DataMemory=30G
IndexMemory=15G
MaxNoOfTables=1600
MaxNoOfAttributes=10000
MaxNoOfOrderedIndexes=1600
MaxNoOfUniqueHashIndexes=1600
TimeBetweenWatchDogCheck=900000
NoOfFragmentLogFiles=1294967296
FragmentLogFileSize = 114572800
MaxNoOfConcurrentOperations =655360
TransactionDeadlockDetectionTimeout=1073741820
DiskSyncSize=53687091
DiskCheckpointSpeed=107374182
DiskCheckpointSpeedInRestart=214748365
RedoBuffer =1073741824
TimeBetweenLocalCheckpoints=6
[NDBD]
NodeId: 2
HostName=192.168.0.90 # the IP of the SECOND SERVER
DataDir=/data/mysql-cluster
BackupDataDir= /data/Backup
DataMemory=30G
IndexMemory=15G
MaxNoOfTables=1600
MaxNoOfAttributes=10000
MaxNoOfOrderedIndexes=1600
MaxNoOfUniqueHashIndexes=1600
FragmentLogFileSize = 114572800
TimeBetweenWatchDogCheck=900000
NoOfFragmentLogFiles=1294967296
MaxNoOfConcurrentOperations =655360
TransactionDeadlockDetectionTimeout=2073741820
DiskSyncSize=53687091
DiskCheckpointSpeed=107374182
DiskCheckpointSpeedInRestart=214748365
RedoBuffer =1073741824
TimeBetweenLocalCheckpoints=6
# 2 MySQL Clients
# I personally leave this blank to allow rapid changes of the mysql clients;
# you can enter the hostnames of the above two servers here. I suggest you dont.
[MYSQLD]
NodeId: 9
HostName=192.168.0.91
#DataDir=/data/mysql-cluster
[MYSQLD]
[MYSQLD]
[MYSQLD]
===========================================================
на API при наборе
#ndbd --initial
даёт сообщение
[ndbd] ERROR -- Failed to allocate nodeid, error:
'Error : Could not alloc node id at 192.168.0.88 port 1186: Connection done from wrong host ip 192.168.0.91.'
люди поскажите плз что сделать с этим, где ощибка?
==========================================================
[NDBD DEFAULT]
NoOfReplicas=2
DataMemory=30G
IndexMemory=15G
MaxNoOfTables=1600
MaxNoOfAttributes=10000
MaxNoOfOrderedIndexes=1600
MaxNoOfUniqueHashIndexes=1600
TimeBetweenWatchDogCheck=900000
NoOfFragmentLogFiles=1294967296
FragmentLogFileSize = 114572800
MaxNoOfConcurrentOperations =655360
TransactionDeadlockDetectionTimeout=1073741820
DiskSyncSize=53687091
DiskCheckpointSpeed=107374182
DiskCheckpointSpeedInRestart=214748365
RedoBuffer =107374182
TimeBetweenLocalCheckpoints=6
TransactionDeadlockDetectionTimeout=2073741820
[MYSQLD DEFAULT]
[NDB_MGMD DEFAULT]
[TCP DEFAULT]
[NDB_MGMD]
NodeId: 1
HostName=192.168.0.88 # the IP of THIS SERVER
# Storage Engines
[NDBD]
NodeId: 3
HostName=192.168.0.89 # the IP of the FIRST SERVER
DataDir= /data/mysql-cluster
BackupDataDir= /data/Backup
DataMemory=30G
IndexMemory=15G
MaxNoOfTables=1600
MaxNoOfAttributes=10000
MaxNoOfOrderedIndexes=1600
MaxNoOfUniqueHashIndexes=1600
TimeBetweenWatchDogCheck=900000
NoOfFragmentLogFiles=1294967296
FragmentLogFileSize = 114572800
MaxNoOfConcurrentOperations =655360
TransactionDeadlockDetectionTimeout=1073741820
DiskSyncSize=53687091
DiskCheckpointSpeed=107374182
DiskCheckpointSpeedInRestart=214748365
RedoBuffer =1073741824
TimeBetweenLocalCheckpoints=6
[NDBD]
NodeId: 2
HostName=192.168.0.90 # the IP of the SECOND SERVER
DataDir=/data/mysql-cluster
BackupDataDir= /data/Backup
DataMemory=30G
IndexMemory=15G
MaxNoOfTables=1600
MaxNoOfAttributes=10000
MaxNoOfOrderedIndexes=1600
MaxNoOfUniqueHashIndexes=1600
FragmentLogFileSize = 114572800
TimeBetweenWatchDogCheck=900000
NoOfFragmentLogFiles=1294967296
MaxNoOfConcurrentOperations =655360
TransactionDeadlockDetectionTimeout=2073741820
DiskSyncSize=53687091
DiskCheckpointSpeed=107374182
DiskCheckpointSpeedInRestart=214748365
RedoBuffer =1073741824
TimeBetweenLocalCheckpoints=6
# 2 MySQL Clients
# I personally leave this blank to allow rapid changes of the mysql clients;
# you can enter the hostnames of the above two servers here. I suggest you dont.
[MYSQLD]
NodeId: 9
HostName=192.168.0.91
#DataDir=/data/mysql-cluster
[MYSQLD]
[MYSQLD]
[MYSQLD]
===========================================================
на API при наборе
#ndbd --initial
даёт сообщение
[ndbd] ERROR -- Failed to allocate nodeid, error:
'Error : Could not alloc node id at 192.168.0.88 port 1186: Connection done from wrong host ip 192.168.0.91.'
люди поскажите плз что сделать с этим, где ощибка?