MySQL and PostgreSQL
Evaluation
Past tests, tools and
highlights
António Amorim, Carlos Jesus. CU1 - First Database Testing Meeting, 20/Nov/08
Test objectives
•
Past studies evaluated the architecture and performance of MySQL Cluster and PostgreSQL
solutions for the Gaia Databases.
•
MySQL Cluster:
– MySQL-Cluster
• Poor performance
• Redundancy benefits
– PostgreSQL
• Sends 2x more data than MySQL
• Poor Bytea performance
Network load(400K objects)
PostgreSQL: 2072M
MYSQL:
1050 Mb
ORACLE-XE: 520 Mb
António Amorim, Carlos Jesus. CU1 - First Database Testing Meeting, 20/Nov/08
Single MySQL Server
In order to pinpoint bottlenecks associated with MySQL, a series of basic tests were performed, these new
tests made use of the available MDBExtractorIngestor package.
Control and Monitor:
Available at the local infrastructure was the SMS (Supervisor Monitor Scheduler) batch system, we
deployed in one node the database and in another the Ingestor.
At the local infrastructure was available the SMS (Supervisor Monitor Scheduler) batch system.
The tests basic 2 node client server model the nodes where as following:
Hardware setup
António Amorim, Carlos Jesus. CU1 - First Database Testing Meeting, 20/Nov/08
The Tests
JdbcObjectUpdater.java
MySQL Ingestor, Old and new JdbcObjectUpdater
António Amorim, Carlos Jesus. CU1 - First Database Testing Meeting, 20/Nov/08
The MDBExtractorIngestor
António Amorim, Carlos Jesus. CU1 - First Database Testing Meeting, 20/Nov/08
Q&A
•For more information:
More on MySQL-cluster and other studies:
SIM Studies at the GAIA WIKI
The technical note:
GAIA-C1-TN-SIM-CDJ-001-1.pdf
GAIA-C1-TN-SIM-AAB-001-01.pdf
António Amorim, Carlos Jesus. CU1 - First Database Testing Meeting, 20/Nov/08