MySQL Forums
Forum List  »  NDB clusters

Re: Cluster performance
Posted by: Mikael Ronström
Date: May 27, 2005 12:50PM

Hi,
One problem with your configuration is that the ndbd nodes are very unbalanced so
the slow node will become a bottleneck in the 2 node case. I presume the 1 node case
used the fast node as ndbd node and then your figures are normal behaviour. It is also
natural that 2 nodes is slower than 1 node if updates are common since there is
replication with 2 nodes and not with 1 node.

Using 5.0 is also likely in general to speed up your IN queries significantly upto 3-4 times.

Rgrds Mikael

Johan Wikstr�m wrote:
> 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
>
>
> NoOfReplicas=2
> DataMemory = 200MB
> IndexMemory = 50MB
> MaxNoOfAttributes = 2000
> MaxNoOfOrderedIndexes = 5000
> MaxNoOfUniqueHashIndexes = 5000
> StopOnError=false
>
>
>
>
>
>
>
>
> HostName=192.168.10.4
>
>
> HostName=192.168.10.5
> DataDir= /llb/mysql-cluster
>
>
> HostName=192.168.10.3
> DataDir=/llb/mysql-cluster
>
>
>
>
>
> --------------------------------------------------
> -------------------------
>
> 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

Mikael Ronstrom
Senior Software Architect, MySQL AB
My blog: http://mikaelronstrom.blogspot.com

Options: ReplyQuote


Subject
Views
Written By
Posted
3275
May 27, 2005 04:32AM
Re: Cluster performance
2409
May 27, 2005 12:50PM
2386
May 30, 2005 03:21AM
4170
May 30, 2005 09:46AM
2474
June 02, 2005 04:19AM
2366
June 02, 2005 07:04PM
2284
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.