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


Pages