Jun 18, 2019

A Proactive Approach to Monitoring Slow Queries

Shashank Sahni (ThousandEyes Inc.) delivers the talk, "A Proactive Approach to Monitoring Slow Queries", on DAY 2 of the Percona Live Open Source Database Conference 2019, 5/30, at Austin, TX.

Slow queries are the harsh reality of any database. Irrespective of how you build the system, design data, educate developers and control access, it's very hard to prevent slow queries. They negatively affect the performance of a database...

Percona Live SessionsMySQLMonitoring and OperationsPercona Toolkit


Jun 18, 2019

At Rest Encryption with MySQL and Vault

Tate McDaniel (Percona), Charles Thompson (Empowered Benefits) deliver the talk, "At Rest Encryption with MySQL and Vault", on DAY 2 of the Percona Live Open Source Database Conference 2019, 5/30, at Austin, TX.

A discussion of different types of encryption as it relates to MySQL and the community, followed by a deep dive into key management with Hashicorp's Vault software and MySQL.

Real world examples, problems, and "...

Percona Live SessionsMySQLSecurity


Jun 18, 2019

Automatic Upgrade and New Error Logging in MySQL 8.0

Ståle Deraas (Oracle) delivers the talk, "Automatic Upgrade and New Error Logging in MySQL 8.0", on DAY 2 of the Percona Live Open Source Database Conference 2019, 5/30, at Austin, TX.

We will cover upgrade from MySQL 5.7 to MySQL 8.0 (8.0.15), going from legacy metadata storage to transactional data dictionary. We will cover the new possibilities for automation of upgrade, and the major advances in upgrade speed and reliability...

Percona Live SessionsMySQL


Jun 18, 2019

Deep Dive on MySQL Databases on Amazon RDS

Chayan Biswas (AWS) delivers the talk, "Deep Dive on MySQL Databases on Amazon RDS", on DAY 2 of the Percona Live Open Source Database Conference 2019, 5/30, at Austin, TX.

In this session, we provide an overview of the MySQL options available on AWS, including a deep dive on Amazon Relational Database Service (Amazon RDS) for MySQL and Amazon Aurora, a MySQL-compatible database with up to 5X the performance, and many additional...

Percona Live Sessions


Jun 18, 2019

MySQL Group Replication: The Magic Explained v2

Frédéric Descamps (Oracle) delivers the talk, "MySQL Group Replication: The Magic Explained v2", on DAY 2 of the Percona Live Open Source Database Conference 2019, 5/30, at Austin, TX.

During this talk, I explain how Group Replication replication works.

This is a theoretical talk in which I explain in details what replication is and how it works.
I discuss what certification is and how it's done. What is XCOM and GCS...

Percona Live SessionsMariaDBMySQL


Jun 18, 2019

The Google Cloud Way For a More Resilient MySQL at Scale

Gabriela Ferrara (Google) delivers the talk, "The Google Cloud Way For a More Resilient MySQL at Scale", on DAY 2 of the Percona Live Open Source Database Conference 2019, 5/30, at Austin, TX.

Being hosted in the cloud is not just about having someone to take care of your database servers for you. It's also about how to improve, contribute, and implement best practices of MySQL to better serve customers. Did you know that we...

Percona Live SessionsOpen Source DatabaseMySQL


Jun 18, 2019

From Scheduled Downtime to Self-Healing in Less Than a Year

Karoly Nagy (Salesforce) delivers the talk, "From Scheduled Downtime to Self-Healing in Less Than a Year", on DAY 2 of the Percona Live Open Source Database Conference 2019, 5/30, at Austin, TX.

Infrastructure automation is not easy, especially for stateful services like MySQL (or any other database for that matter). It goes way beyond the capabilities of Ansible, Chef, SaltStack or other similar tools. In this session I'm going...

Percona Live SessionsContainers and AutomationMariaDBMySQL


Jun 18, 2019

Self-Driving Databases: It All Starts with Workload Forecasting

Lin Ma (Carnegie Mellon University) delivers the talk, "Self-Driving Databases: It All Starts with Workload Forecasting", on DAY 2 of the Percona Live Open Source Database Conference 2019, 5/30, at Austin, TX.

Database management systems (DBMSs) are notoriously difficult to deploy and administer because of their long list of functionalities. If a system could optimize itself automatically, then it would remove many of the...

Percona Live SessionsContainers and AutomationOpen Source Database


Jun 18, 2019

Automate PMM Deployment with Ansible

Max Bubenick (Percona) delivers the talk, "Automate PMM Deployment with Ansible", on DAY 2 of the Percona Live Open Source Database Conference 2019, 5/30, at Austin, TX.

Based on our experience deploying PMM on hundreds of different environments, in this session, I'm going to show how to manage PMM on production using Ansible for automation.

Some of the automation tasks include:
- PMM Server Deployment
- PMM...

Percona Live SessionsContainers and AutomationOpen Source DatabaseMonitoring and OperationsSecurity


Jun 18, 2019

MySQL Shell: The Best DBA tool? How to Use the MySQL Shell as a Framework for DBAs

Frédéric Descamps (Oracle) delivers the talk, "MySQL Shell: The Best DBA tool? How to Use the MySQL Shell as a Framework for DBAs", on DAY 1 of the Percona Live Open Source Database Conference 2019, 5/29, at Austin, TX.

MySQL Shell is the new client for MySQL. It understands standard and X protocol. It also allows to send JS, Python or SQL commands to the server. In this talk I will show you how to first configure the Shell for a...

Percona Live SessionsMySQL


Pages