May 29, 2019
 Percona Live Open Source Database Conference 2019
  David Cohen, Steve Scargall, Jeff Smits

In this talk, we discuss the use of the open source MySQL Community Edition and Percona Server projects and Intel's Cascade Lake server platform as the primary building blocks for hosting a Database-as-a-Service (DBaaS) deployment. Data demonstrating the advantage of this configuration will be presented. Emphasis will be on deployment of an offering that provides developers with self-service, on-demand delivery of databases that run over shared infrastructure in a multi-tenant environment. Demand for DBaaS from a diverse span of market segments has driven the large Cloud Service Providers to invest in the buildout such offerings.

Today, these offerings are widely available from Multiple Cloud Providers. Until recently, however, organizations wanting to provide DBaaS from within their own data centers were left without good options. This demand is set to be addressed with the emergence of several open source projects. A second, intersecting trend is the imminent release of Intel's next-generation Cascade Lake XEON platform and its support for byte-addressable, persistent memory via the Intel® Optane™ DC Persistent Memory product.

Our talk will dive into the intersection of these two trends starting with an overview of the Cloud Native DBaaS model. Next, a concrete description of a deployment model using Percona's MySQL and MyRocks distributions will be introduced. This model will be supported by a two-fold, data-driven discussion on performance and density. First, a performance characterization for both the InnoDB and MyRocks storage engines is presented with the focus on comparing/contrasting the use of NVMe vis-a-vis Intel® Optane™ DC Persistent Memory. For the latter, we include Intel® Optane™ DC Persistent Memory volumes in fsdax as well as sector modes. Secondly, data on database instance density using a single Intel Cascade Lake server outfitted with NVMe vis-a-vis Intel® Optane™ DC Persistent Memory will be presented. The talk will conclude with a discussion on the results and how they have influenced our plans for further work in MySQL CE/Percona Server open source projects going forward.



About the Authors

David Cohen

Dave Cohen is the Storage Solutions CTO in Intel's Nonvolatile Memory and Storage (NVMS) Group and the Chief Architect of Intel's Data Management Platform. This is a rack-centric, physical cluster that builds on the Intel Rack Scale Design (RSD). Dave has been at Intel for five years working on a variety of network and storage related solutions. His career spans over 30 years working on large scale, distributed systems for Fortune 500 companies across several industry segments.
 

Steve Scargall

Steve Scargall is a Persistent Memory Software Architect at Intel Corporation responsible for supporting partners and customers as they incorporate the disruptive Persistent Memory technology into their software architectures. This includes Server Software Vendors, Cloud Service Providers, and the Open Source Development community software stacks. He received a B.Sc in Computer Science and Cybernetics from the University of Reading, UK in 2001 where he studied Neural Networks, AI, and Robotics. He also has over 18 years' experience providing Solaris Kernel, ZFS and UFS Filesystem, Performance Analysis on x86 and SPARC, and DTrace debugging in enterprise and cloud environments.
 

Jeff Smits

Leads Intel's Server Software Performance engineering efforts.