Hi,
We have setup a MySQL cluster (pretty standard two NDB nodes + two management servers)
2x cluster processing nodes (running the MySQL NDB daemon + MySQL server)
- 144GB ram
- 8x 300GB SAS - Raid 10
- Data-Storage = 135GB Ram
- Index-Storage = 5GB RAM
However at 92Million rows in a table, it is returning the TableFull error?
My config is as follows:
[NDBD DEFAULT]
NoOfReplicas=2
LockPagesInMainMemory=1
DataMemory=131G
IndexMemory=10G
TimeBetweenLocalCheckpoints=6
NoOfFragmentLogFiles=500
[MYSQLD DEFAULT]
[NDB_MGMD DEFAULT]
[TCP DEFAULT]
SendBufferMemory=8M
ReceiveBufferMemory=8M
# Section for the cluster management node
[NDB_MGMD]
ID=1 #LB1 ID is 1
Datadir=/var/lib/mysql-cluster
HostName=#.#.#.# #PRIVATE IP OF LB1
[NDB_MGMD]
HostName=#.#.#.# #PRIVATE IP OF LB2
ID=2 #ID of LB2 is 2
Datadir=/var/lib/mysql-cluster
# Section for the storage nodes
[NDBD]
# IP address of the first storage node
HostName=#.#.#.# # PRIVATE IP OF DB1
DataDir=/var/lib/mysql-cluster
[NDBD]
# IP address of the second storage node
HostName=#.#.#.# #PRIVATE IP OF DB2
DataDir=/var/lib/mysql-cluster
# one [MYSQLD] per storage node
[MYSQLD]
[MYSQLD]
Can anyone please shed some light on this matter?
Cheers,
Karl Kloppenborg
