Project

General

Profile

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:

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