Description:
2 nodes, each running 1 API and 1 NDB
config.ini:
[NDBD DEFAULT]
NoOfReplicas=2
MaxNoOfConcurrentOperations=200000
DataMemory=3000M
IndexMemory=256M
TimeBetweenWatchDogCheck=3000
TransactionDeadlockDetectionTimeout=500
MaxNoOfOrderedIndexes=2048
MaxNoOfUniqueHashIndexes=2048
MaxNoOfAttributes=10000
MaxNoOfTables=2500
NoOfDiskPagesToDiskAfterRestartTUP=125
NoOfDiskPagesToDiskAfterRestartACC=23
NoOfFragmentLogFiles=32
TimeBetweenLocalCheckpoints=20
[MYSQLD DEFAULT]
[NDB_MGMD DEFAULT]
[TCP DEFAULT]
[NDB_MGMD]
HostName=xxx.xxx.xxx.xxx
[NDBD]
HostName=xxx.xxx.xxx.xxx # the IP of the FIRST SERVER
DataDir= /var/lib/mysql-cluster
[NDBD]
HostName=xxx.xxx.xxx.xxx # the IP of the SECOND SERVER
DataDir=/var/lib/mysql-cluster
# 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]
[MYSQLD]
ndbd --initial on both nodes
start 1st API node
start 2nd API node
check 2nd API node mysqld.err
060201 16:43:55 [Note] /usr/sbin/mysqld-501: ready for connections.
Version: '5.1.6-alpha' socket: '/var/run/mysqld/mysqld.sock' port: 3306 Gento
o Linux mysql-5.1.6_alpha-r30
060201 16:43:55 [Note] NDB: missing frm for cluster_replication.apply_status, di
scovering...
060201 16:43:55 [Note] NDB: missing frm for cluster_replication.schema, discover
ing...
the NDB notices repeat every second, the logfile grows
Workaround: connect to api, select on affected tables, missing frm automagically appears
How to repeat:
start cluster, check logfile of 2nd API to come up