Project

General

Profile

Actions

Support #24397

closed

How to run MySQL on Ceph ?

Added by yi li almost 6 years ago. Updated almost 6 years ago.

Status:
Closed
Priority:
Normal
Assignee:
-
Category:
-
Target version:
-
% Done:

0%

Tags:
Reviewed:
Affected Versions:
Pull request ID:

Description

I want to run MySQL on Ceph, and I did the follow step to achieve my goal.

(Method one)Using Ceph RBD interface:
1. Install MySQL and Ceph
2. Deploy Ceph environment, create a Ceph pool and create Ceph RBD device based on Ceph pool
3. Mount XFS on RBD device
4. Change the MySQL data directory to the directory of RBD device.

(Method two)Using CephFS interface:
1. Install MySQL and Ceph
2. Deploy Ceph environment, create two Ceph pools and mount CephFS
3. Change the MySQL data directory to the directory of CephFS.

And then I achieved the goal of running MySQL on Ceph. I didn’t modify any MySQL codes. Is it that simple ?
I read the librbd.h and libcephfs.h. If I modify the code of MySQL filesystem IO interface, is that any differences between the version of modified the MySQL or not modified the MySQL code ?

I thought this question a lot but didn’t figure it out. Hope getting some help.
Thanks.

Actions #1

Updated by Greg Farnum almost 6 years ago

  • Status changed from New to Closed

This is not an appropriate venue for this discussion. I recommend the ceph-users list or a mysql arena. :)

Actions

Also available in: Atom PDF