Rbd - Database performance¶

Summary¶

This blueprint aims at understanding various types of databases performances running over Ceph RBD either via kernel device and/or librbd (via libvirt/qemu). Best practices, fine-tuning guides for performance tradeoffs, features tradeoffs for various types of databases are expected to be some of the outcomes.

Owners¶

• JY Luke (MIMOS)
• Mohd Bazli Ab Karim (MIMOS)
• MT Wong (MIMOS)
• HH Ong (MIMOS)

Interested Parties¶

• Danny Al-Gaaf
• Name (Affiliation)
• Name

Current Status¶

Initial evaluation using HammerDB on PostgreSQL in VM with RBD (via libvirt) however performance is not sactisfactory.

Detailed Description¶

Simple benchmark run using HammerDB on PostgreSQL showed serious lack of performance as do some other discussions over the ceph-users and ceph-devel mailing list recently. The idea here is to study/evaluate several popular open source databases and their IO patterns that will lead to better configuration for both the databases and Ceph to provide the best possible performance. The outcome can be in the form of FAQ/Guidelines on what is the best practices, options, etc.

Currently, we are planning to run more performance tests using the following tools:

• Hammerdb for PostgreSQL, MySQL - http://hammerora.sourceforge.net/
• YCSB for Cassandra - https://github.com/brianfrankcooper/YCSB/wiki

Pad¶

http://pad.ceph.com/p/GH-rbd-database-performance

Work items¶

Coding tasks¶

1. Task 1
2. Task 2
3. Task 3

Build / release tasks¶

1. Task 1
2. Task 2
3. Task 3

Documentation tasks¶

1. Task 1
2. Task 2
3. Task 3

Deprecation tasks¶

1. Task 1
2. Task 2
3. Task 3