ayo_gago
Newbie | Редактировать | Профиль | Сообщение | Цитировать | Сообщить модератору конфиг имеет следующий вид: ========================================================== [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.' люди поскажите плз что сделать с этим, где ощибка? |