MySQL Forums
Forum List  »  NDB clusters

Cluster performance
Posted by: Johan Wikström
Date: May 27, 2005 04:32AM

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

Options: ReplyQuote


Subject
Views
Written By
Posted
Cluster performance
3277
May 27, 2005 04:32AM
2411
May 27, 2005 12:50PM
2389
May 30, 2005 03:21AM
4172
May 30, 2005 09:46AM
2476
June 02, 2005 04:19AM
2372
June 02, 2005 07:04PM
2285
June 03, 2005 11:06AM
2433
June 08, 2005 08:50AM
2068
June 03, 2005 12:26PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.