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


Jun 18, 2019

New Features in ProxySQL 2.0

René Cannaò (ProxySQL), Nick Vyzas (ProxySQL) deliver the talk, "New Features in ProxySQL 2.0", on DAY 1 of the Percona Live Open Source Database Conference 2019, 5/29, at Austin, TX.

ProxySQL, the high performance, high availability, protocol-aware proxy for MySQL is now GA in version 2.0.
This version introduces several new features, like causal reads using GTID, better support for AWS Aurora, native support for Galera...

Percona Live SessionsMySQL


Jun 18, 2019

Percona XtraDB Cluster 8.0 (PXC-8.0)

Krunal Bauskar (Percona) delivers the talk, "Percona XtraDB Cluster 8.0 (PXC-8.0)", on DAY 1 of the Percona Live Open Source Database Conference 2019, 5/29, at Austin, TX.

Percona XtraDB Cluster 8.0 (PXC-8.0) is the latest addition to PXC family.

Starting MySQL/PS-8.0 upstream has done a lot of significant changes including atomic DDL, replication channel, locking algorithm changes, security/ encryption, etc....

...

Percona Live SessionsMariaDBMySQLPercona XtraDB Cluster


Jun 18, 2019

Upgrading to MongoDB 4.0 From Older Versions

Alex Cercel (Rackspace) delivers the talk, "Upgrading to MongoDB 4.0 From Older Versions", on DAY 1 of the Percona Live Open Source Database Conference 2019, 5/29, at Austin, TX.

The changes that MongoDB is bringing to the world in 4.0 are tempting to many companies and administrators, but if you are on an older version such as 3.2, upgrading with minimum disruption can be challenging.

Some of the problems that a company...

Percona Live SessionsMongoDB


Pages