Saturday, May 05, 2007

Performance White Papers on MySQL Cluster

I've been working on some very interesting benchmarking using the
DBT2 test suite developed by OSDL for MySQL Cluster. As part of this
work I've made significant additions to the DBT2 test to enable clustered
test runs. I've also developed a set of scripts to enable easy start and
stop of MySQL Cluster processes.

The benchmarks include comparisons of various connect methods using
Ethernet and Dolphin Express cards. It also discusses improvements using
the latest version of the Intel Core2 architecture.

As part of this work I discovered a couple of essential performance
optimisations and scalability optimisations. All these improvements
are currently being integrated in MySQL Cluster Carrier Grade Edition.
To enable those wanting "bleeding edge"-access I've also made the
benchmark version available on www.iclaustron.com

A short white paper and the full white paper can be downloaded from
www.dolphinics.com and a MySQL-focused version of the white paper
can be downloaded from www.mysql.com. www.iclaustron.com contains
the exact links for all material available from various places.

The full white paper contains also recommendations of HW architectures
to use for optimal MySQL Cluster performance and scalability.