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