Running MySQL Virtualized on Ceph: Which Hypervisor is the Best?
With the popularity of virtualization, running MySQL in a virtual environment is now almost the norm -- with many technology options. Since the storage layer is also commonly virtualized, a virtual server instance is not bound to the local storage of a physical host. The most popular OpenStack cinder backend is Ceph, but Ceph is not restricted to the OpenStack world. If we restrict ourselves to open source technologies, consider the following options: KVM, LXC and Docker. How does MySQL perform on these forms of virtualization? How can we use Ceph for the storage backend? Are the LXC and Docker performance similar? In addition to answering these questions, in this talk we’ll present the results of MySQL and file-level benchmarks obtained using tools like Percona TPCC, Sysbench and FIO. These results allow us to compare the MySQL performance levels possible on the referenced open source platforms, along with the positive and negative sides of each virtualization technology. We’ll also provide tuning guidelines to maximize performance.
Principal consultant, Percona
I am a Principal Consultant at Percona, specializing in MySQL High-Availability and scaling solutions. Prior to joining Percona in 2009, I worked as a senior consultant for MySQL AB and Sun Microsystems, assisting customers across North America with NDB Cluster and Heartbeat/DRBD technologies.
Sr Solution Architect, Red Hat
Kyle Bader, a Red Hat senior architect, provides expertise in the design and operation of petabyte scale storage systems using Ceph. He joined Red Hat as part of the 2014 Inktank acquisition. As a senior systems engineer at DreamHost, he helped implement, operate, and design Ceph and OpenStack-based systems for DreamCompute and DreamObjects cloud products.