David Cohen (Intel), Steve Scargall (Intel), Jeff Smits (Intel) deliver the talk, "A Discussion on the Advantages Afforded MySQL DBaaS offerings hosted on Intel's Next Gen Platform", on DAY 1 of the Percona Live Open Source Database Conference 2019, 5/29, at Austin, TX.

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.


Related Videos: Percona Live Sessions, MariaDB, MySQL

Optimize and Troubleshoot MySQL using PMM
Using PMM to Identify and Troubleshoot Problematic MySQL Queries
MariaDB Observability
Google Cloud Platform: MySQL at Scale with Reliable HA
Analytical Queries in MySQL - PLO October 2020
MySQL Ecosystem on ARM - Krunal Bauskar - Percona Live ONLINE 2020
How Does Geo-Replication Work in TiDB? - Jay Lee - Percona Live ONLINE