1 / 8

MySQL Cluster Performance and Architecture Evaluation

Test objectives, setup, results and highlights. MySQL Cluster Performance and Architecture Evaluation. António Amorim, Carlos Jesus. CU1 - System Architecture Meeting 7, 22/SEP/08. Test objectives.

zubeda
Download Presentation

MySQL Cluster Performance and Architecture Evaluation

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Test objectives, setup, results and highlights MySQL Cluster Performance and Architecture Evaluation 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. Q&A • For more information:More on MySQL-cluster and other studies:SIM Studies at the GAIA WIKIThe technical note:GAIA-C1-TN-SIM-CDJ-001-1.pdf António Amorim, Carlos Jesus. CU1 - System Architecture Meeting 7, 22/SEP/08

More Related