Ru-Board.club
← Вернуться в раздел «UNIX»

» Проблемма с mysql-cluster-ом

Автор: ayo_gago
Дата сообщения: 14.10.2011 19:03
конфиг имеет следующий вид:
==========================================================
[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.'

люди поскажите плз что сделать с этим, где ощибка?

Страницы: 1

Предыдущая тема: start squid....


Форум Ru-Board.club — поднят 15-09-2016 числа. Цель - сохранить наследие старого Ru-Board, истории становления российского интернета. Сделано для людей.