Percona Live: Open Source Database Performance Conference - Amsterdam 2016 Logo

October 3-5, 2016

Amsterdam, Netherlands

MySQL and Ceph: A tale of two friends

MySQL and Ceph: A tale of two friends

 5 October 11:20 AM - 12:10 PM @ St. Gallen
Experience level: 
Intermediate
Duration: 
50 minutes conference
Tracks:
OSDBMS
MySQL
Topics:
MySQL
OpenStack
Data in the Cloud

Description

OpenStack is getting popularity among various industry segments for providing both internal and external IT services. Counting on OpenStack user survey, Ceph is the #1 and the most loved storage backend for providing persistent block storage service through OpenStack Cinder. As developers build new applications, and repatriate old workloads, they are quickly discovering the need to provide database services within their OpenStack infrastructure. Given the ubiquity of MySQL, and its reliance on persistent storage, it is of utmost importance to understand how to achieve database performance demanded by today's applications. Databases like MySQL can be incredibly IO intensive, and Ceph offers a great opportunity to go beyond the limitations presented by a single scale-up system. Since Ceph provides a mutable object store with atomic operations, could MySQL store InnoDB pages directly in Ceph? This talk drives through the basics of "Why MySql on Ceph", gradually covering Ceph architecture. Then we'll spend some time discussing our setup and results of a series of benchmarks done on small to mid-size Ceph cluster and finally uncovering some of the tunings we learned during this study.

Speakers

Taco Scargo's picture

Taco Scargo

Sr. Solution Architect, RedHat

Biography:

Taco Scargo is working as senior solution architect at Red Hat based in The Netherlands. At Red Hat his responsibilities include designing and implementing solutions based on Red Hat Ceph Storage. Taco has been working with OpenStack, Ceph, DevOps tools, Containers and helped building multiple IaaS & PaaS clouds throughout EMEA.

Karan Singh's picture

Karan Singh

Sr. Storage Architect, Red Hat

Biography:

Karan Singh is working as senior storage architect at Red Hat based in Finland. At Red Hat his responsibilities include designing, implementing and testing various reference architectures, performance and sizing guides based on Ceph. He is deeply involved in Ceph performance evaluation across wide range workloads and industry standard hardware from different providers. Karan has been working with OpenStack, Ceph, DevOps tools and helped building multiple IaaS clouds at CSC-IT Center for Science where he worked before Red Hat. Karan enjoys writing and has authored a few titles on Ceph Learning Ceph : https://www.packtpub.com/application-development/learning-ceph Ceph Cookbook : https://www.packtpub.com/application-development/ceph-cookbook He devotes a part of his time to R&D and learning new technologies. When not working on Ceph and OpenStack, Karan can be found working with emerging technologies or automating stuffs. He loves writing about technologies and is an avid blogger at www.ksingh.co.in.

Share this talk


Slides