Dear MySQL Cluster developers and engineers,
We currently have a database with about 80 MyISAM tables.
Index size about 2.5 MB
Data size about 10.5 MB
Size on disc 34.0 MB
The main user-table contains just under 3 000 rows, and we are about to expand to more than 2 000 000.
To make sure that we can handle that amount of requests to the database in the future we have started to look into MySQL clustering.
We have put up a test environment with the following configuration:
Management server:
Intel Pentium II 400 MHz
128 MB RAM
Server 1:
Intel Xeon 2 GHz
1 GB RAM
Server 2
Intel Pentium III 550MHz
396 MB RAM
All servers are running OpenBSD 3.7 and MySQL 4.1.11
---------------------------------------------------------------------------
Config.ini
[NDBD DEFAULT]
NoOfReplicas=2
DataMemory = 200MB
IndexMemory = 50MB
MaxNoOfAttributes = 2000
MaxNoOfOrderedIndexes = 5000
MaxNoOfUniqueHashIndexes = 5000
StopOnError=false
[MYSQLD DEFAULT]
[NDB_MGMD DEFAULT]
[TCP DEFAULT]
[NDB_MGMD]
HostName=192.168.10.4
[NDBD]
HostName=192.168.10.5
DataDir= /llb/mysql-cluster
[NDBD]
HostName=192.168.10.3
DataDir=/llb/mysql-cluster
[MYSQLD]
[MYSQLD]
[MYSQLD]
---------------------------------------------------------------------------
Or main service runs approx 250 selects and selects using "where in" and a couple of joins on two tables.
When converting the table type from MyISAM to NDB we encounter performance loss.
When we connect a second node to the cluster, we encounter an even bigger performance loss.
Please see below;
With table type MyISAM. -
With table type NDB and one node. - 2x slower than MyISAM
With table type NDB and two nodes. - 10x times slower then MyISAM and 5x slower than single node.
Is this a regular behavior? Is there anything we can do to speed up the process?
We have read a similar post on this forum that was posted half a year ago. Has anything changed since that?
"MySQL Lists: cluster: Re: Cluster 4x faster when running on one node only"
http://lists.mysql.com/cluster/1229
Has our minimal hardware configuration on the lab environment an impact?
Looking forward to get feedback and tips.
Best regards,
JW