Videos from Percona | Page 6
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