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


Jun 18, 2019

LATERAL Derived Tables in MySQL 8.0

Norvald Ryeng (Oracle) delivers the talk, "LATERAL Derived Tables in MySQL 8.0", on DAY 1 of the Percona Live Open Source Database Conference 2019, 5/29, at Austin, TX.

Since version 8.0.14, MySQL supports LATERAL derived tables, sometimes called the for each loop of SQL. What are they? How do they work? Why do you need them? What can they do? How can you use them? Should you use them? What is all this talk about for each loops...

Percona Live SessionsMySQL


Jun 18, 2019

Percona XtraBackup vs Mariabackup vs MySQL Enterprise Backup

Iwo Panowicz (Percona), Juan Pablo Arruti (Percona) deliver the talk, "Percona XtraBackup vs Mariabackup vs MySQL Enterprise Backup", on DAY 1 of the Percona Live Open Source Database Conference 2019, 5/29, at Austin, TX.

There are few ways to take a backup. One of the most used tools is Percona Xtrabackup, MariaBackup, and MySQL Enterprise Backup.

In this talk, the audience will have an in-deep overview of:
-...

Percona Live SessionsMariaDBPercona XtraBackup


Jun 18, 2019

Errant GTIDs Breaking Replication: How to Detect and Avoid Them

Dieter Adriaenssens (Ghent University) delivers the talk, "Errant GTIDs Breaking Replication: How to Detect and Avoid Them", on DAY 1 of the Percona Live Open Source Database Conference 2019, 5/29, at Austin, TX.

GTIDs were introduced to solve replication problems and improve database consistency.

When, accidentally, transactions occur on a replica, this introduces GTIDs on that replica that don't exist on the master. When...

Percona Live SessionsMySQLMonitoring and Operations


Jun 18, 2019

MySQL on Google Cloud: The Good, The Bad, and The Ugly

Jeremy Cole (Shopify) delivers the talk, "MySQL on Google Cloud: The Good, The Bad, and The Ugly", on DAY 1 of the Percona Live Open Source Database Conference 2019, 5/29, at Austin, TX.

Running MySQL in the cloud isn't magic - it can be brilliant, but it can also be a real challenge. We'll learn about some of the big wins that can be had in the cloud (such as elasticity and easy provisioning). But, we'll talk about the dark...

Percona Live SessionsMySQLCloud Solutions


Pages