Andy Pavlo (Carnegie Mellon University) delivers the talk, "Make Your Database Dream of Electric Sheep: Designing for Autonomous Operation", on DAY 1 of the Percona Live Open Source Database Conference 2018, 4/24, at Santa Clara, CA. In the last 20 years, researchers and vendors have built advisory tools to assist DBAs in tuning and physical design. Most of this previous work is incomplete because they require humans to make the final decisions about any database changes and are reactionary measures that fix problems after they occur. What is needed for a "self-driving" DBMS are components that are designed for autonomous operation. This will enable new optimizations that are not possible today because the complexity of managing these systems has surpassed the abilities of humans. In this talk, I present the core principles of an autonomous DBMS based on reinforcement learning. These are necessary to support ample data collection, fast state changes, and accurate reward observations. I will discuss techniques on how to build a new autonomous DBMS or retrofit an existing one. Our work is based on our experiences at CMU from developing an automatic tuning service (OtterTune) and our self-driving DBMS (Peloton).

Related Videos: Percona Live Sessions, New Tech & Trends, Operations, Monitoring and Operations

Introduction to pg_stat_monitor
How To Measure Linux Performance Wrong
MySQL 8 Observability
How we ran our first 24 Hour, Virtual Percona Live Online Conference
Mostly mistaken and ignored parameters while optimizing a PostgreSQL database - Percona Live 2020
Working With PostgreSQL As A JSON Document Store - Robert Bernier - Percona Live Online 2020
Cassandra where and how - John Schulz - Percona LIve Online 2020