MySQL Cluster Performance and Architecture Evaluation

1
MySQL Cluster Performance and Architecture
Evaluation

• Test objectives, setup, results and highlights

António Amorim, Carlos Jesus. CU1 - System
Architecture Meeting 7, 22/SEP/08
2
Test objectives

• The purpose of this study was to evaluate the
  architecture and performance of MySQL Cluster
  solution for the Gaia Databases.
• Analyzed characteristics
• MySQL-Cluster vs. standard MySQL performance
• Architecture benefits and limitations
• Scaling performance

António Amorim, Carlos Jesus. CU1 - System
Architecture Meeting 7, 22/SEP/08
3
Test setup

• The tests made use and extended the already
  available DbBenchmark package which was modified
  to serve our proposes, the changes where namely
  converting it to GaiaTools 3, and altering the
  default create statements.
• Control and Monitor
• At the local infrastructure was available the SMS
  (Supervisor Monitor Scheduler) batch system, we
  deployed 2 suits one for controlling the cluster
  and another for executing the tests.
• Using the SMS batch system, we deployed 14
  (2processes x 7 machines) processes, which
  performed different tasks, create, insert, etc...

António Amorim, Carlos Jesus. CU1 - System
Architecture Meeting 7, 22/SEP/08
4
Test setup
The local cluster is composed of 20 nodes, linked
by a gigabit switch. Each node has 7 standard
sata hard drives in raid5 and 8GB of RAM.
Cluster node composition
Software versions
António Amorim, Carlos Jesus. CU1 - System
Architecture Meeting 7, 22/SEP/08
5
Test setup
The different databases have different data types
so in order to produce the same results the
create statements where changed in order to have
a similar row size in all databases, using the
following conversion
Integer Conversion
Floating point number Conversion
António Amorim, Carlos Jesus. CU1 - System
Architecture Meeting 7, 22/SEP/08
6
MySQL Benchmark
MySQL single Tests composed of 7Milion rows
filled with random data.
MySQL-cluster Tests composed of 7Milion rows
filled with random data.
António Amorim, Carlos Jesus. CU1 - System
Architecture Meeting 7, 22/SEP/08
7
Overview

• Performance
• Slow insert and select, poor scaling performance.
• Availability
• A highly redundant environment can be achieved,
  with no node being a single point of failure
• Architecture
• Poor BLOB implementation a row that took 0.5kb
  is now 2kb (solved in MySQL5.1).
• High availability, can be achieved, but load
  balance must be a added layer.
• MySQL cluster is a in-memory database, which
  limits the total size of database.

António Amorim, Carlos Jesus. CU1 - System
Architecture Meeting 7, 22/SEP/08
8
QA

• For more informationMore on MySQL-cluster and
  other studiesSIM Studies at the GAIA WIKIThe
  technical noteGAIA-C1-TN-SIM-CDJ-001-1.pdf

António Amorim, Carlos Jesus. CU1 - System
Architecture Meeting 7, 22/SEP/08