Videos from Percona | Page 6
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
Jun 18, 2019
MongoDB: Where Are We Going From Here?
David Murphy delivers the talk, "MongoDB: Where Are We Going From Here?", on DAY 1 of the Percona Live Open Source Database Conference 2019, 5/29, at Austin, TX.
MySQL JSON Support
Open source reject license
MySQL Group Replication
MongoDB transactions
Distros dropping MongoDB package
This year has seen a good deal of changes and challenges in the MongoDB Space. But where are things going? We are...
Percona Live SessionsMongoDB
Jun 18, 2019
MongoDB HA, What Can Go Wrong
Igor Donchovski (Pythian) delivers the talk, "MongoDB HA, What Can Go Wrong?", on DAY 1 of the Percona Live Open Source Database Conference 2019, 5/29, at Austin, TX.
Redundancy and high availability are the basis for all production deployments. With MongoDB this can be achieved by deploying a replica set. In this talk, we'll explore how MongoDB replication works and what the components are of a replica set. Using examples of...
Percona Live SessionsMongoDB