Percona Live 2017 Open Source Database Conference

April 24 - 27, 2017

Santa Clara, California

Videos from Percona Live | Page 5

Scale read workload by sharing data files of InnoDB

Zhai Weixiang (Alibaba) delivers his talk "Scale read workload by sharing data files of InnoDB" on Day 1 of the Percona Live Open Source Database Conference 2017, April 25th, at Santa Clara, CA.

The original MySQL provides an ability that if innodb_read_only is turned on, you can setup...

Securing your MySQL/MariaDB data

Hank Eskin (WheresGeorge.com & EV-CPO.com), Ronald Bradford (Pythian), Colin Charles (Percona) delivers their talk "Securing your MySQL/MariaDB data" on Day 1 of the Percona Live Open Source Database Conference 2017, April 25th, at Santa Clara, CA.

This presentation will discuss the...

MySQL 8.0: What is New in the Optimizer?

Manyi Lu (Oracle) delivers her talk "MySQL 8.0: What is New in the Optimizer?" on Day 1 of the Percona Live Open Source Database Conference 2017, April 25th, at Santa Clara, CA.

There are substantial improvements in the Optimizer in MySQL 8.0. Most noticeably, we have added support for...

Practical orchestrator

Shlomi Noach (GitHub) delivers his talk "Practical orchestrator" on Day 1 of the Percona Live Open Source Database Conference 2017, April 25th, at Santa Clara, CA.

Orchestrator is a MySQL topology manager and a failover solution, used in production on many large MySQL installments. It...

Caching your application data with MySQL and TokuDB

Andrea Ponzo (Lastminute.com), Rick Pizzi (Lastminute.com) delivers their talk "Caching your application data with MySQL and TokuDB" on Day 1 of the Percona Live Open Source Database Conference 2017, April 25th, at Santa Clara, CA.

Even if InnoDB is universally recognized by DBAs as "the...

The Database Designer's Modern-Day Cookbook

Preetam Jinka (VividCortex) delivers his talk "The Database Designer's Modern-Day Cookbook" on Day 1 of the Percona Live Open Source Database Conference 2017, April 25th, at Santa Clara, CA.

I’ve been learning about database internals by learning the theory, seeing how other systems have...

Indexes - what you need to know to get the most out of them

Matthew Boehm (Percona) delivers his talk "Indexes - what you need to know to get the most out of them" on Day 1 of the Percona Live Open Source Database Conference 2017, April 25th, at Santa Clara, CA.

Proper indexing is key to database performance. Find out how MySQL uses indexes for...

Schema best practices / high performance SQL

Michael Benshoof (Percona) delivers his talk "Schema best practices / high performance SQL" on Day 1 of the Percona Live Open Source Database Conference 2017, April 25th, at Santa Clara, CA.

Go through a schema review, including reviewing large tables, looking at indexes, and so on. This...

What is Apache Kafka? How is it similar to the databases you know and love, and how it's not

Kenny Gorman (Eventador.io) delivers his talk "What is Apache Kafka? How is it similar to the databases you know and love, and how it's not" on Day 1 of the Percona Live Open Source Database Conference 2017, April 25th, at Santa Clara, CA.

Apache Kafka has become very popular in the last...

Think Your Postgres Backups and Disaster Recovery Are Safe? Let's Talk

Payal Singh (omniTI) delivers his talk "Think Your Postgres Backups and Disaster Recovery Are Safe? Let's Talk" on Day 1 of the Percona Live Open Source Database Conference 2017, April 25th, at Santa Clara, CA.

Disaster recovery is perhaps the most ignored aspect of managing PostgreSQL in...

Hipster MySQL Monitoring: Serving a deconstructed PMM

Ben Mildren (DigitalOcean) delivers his talk "Hipster MySQL Monitoring: Serving a deconstructed PMM" on Day 1 of the Percona Live Open Source Database Conference 2017, April 25th, at Santa Clara, CA.

Percona Monitoring and Management (PMM) is a wonderful solution, it aims to provide out...

Become a MongoDB DBA: monitoring essentials

Art van Scheppingen (Severalnines AB) delivers his talk "Become a MongoDB DBA: monitoring essentials" on Day 1 of the Percona Live Open Source Database Conference 2017, April 25th, at Santa Clara, CA.

To operate MongoDB efficiently, you need to have insight into database performance. And...

One System to Fit Them All: Shared MySQL Hosting at Facebook

Andrew Regner (Facebook) delivers his talk "One System to Fit Them All: Shared MySQL Hosting at Facebook" on Day 1 of the Percona Live Open Source Database Conference 2017, April 25th, at Santa Clara, CA.

MySQL is by far the most common choice among Facebook engineering teams when they...

MySQL Monitoring with Percona Monitoring and Management

Peter Zaitsev (Percona) delivers their talk "MySQL Monitoring with Percona Monitoring and Management" on Day 1 of the Percona Live Open Source Database Conference 2017, April 25th, at Santa Clara, CA.

In this talk, I will introduce Percona’s latest open source software tool: Percona...

Use ProxySQL to Improve Your MySQL High Availability Solution

Marco Tusa (Percona) delivers his talk "Use ProxySQL to Improve Your MySQL High Availability Solution" on Day 1 of the Percona Live Open Source Database Conference 2017, April 25th, at Santa Clara, CA.

ProxySQL is a flexible, fast and highly configurable piece of software that provides...

MySQL 8.0: Major new features

Geir Høydalsvik (Oracle) delivers his talk "MySQL 8.0: Major new features" on Day 1 of the Percona Live Open Source Database Conference 2017, April 25th, at Santa Clara, CA.

In this session, I will describe the new features that have all ready been announced for MySQL 8.0.

In...

B-Trees, Fractal Trees, Heaps and Log Structured Merge Trees, Where did they all come from and Why?

John Schulz (Pythian) delivers his talk "B-Trees, Fractal Trees, Heaps and Log Structured Merge Trees, Where did they all come from and Why?" on Day 1 of the Percona Live Open Source Database Conference 2017, April 25th, at Santa Clara, CA.

For many years the B-Tree has reigned supreme as...

Performance Schema for MySQL Troubleshooting

Sveta Smirnova, Principal Technical Services Engineer from Percona delivers their talk, "Performance Schema for MySQL Troubleshooting", on DAY 2 of the 2016 Percona Data Performance Conference, April 20,2016, at Santa Clara, CA.

The performance schema in MySQL version 5.6, released in...

MySQL GTID Implementation, Maintenance, and Best Practices - The Short Version

Mark Filipi (SurveyMonkey), Brian Cain (Dropbox) delivers his talk, "MySQL GTID Implementation, Maintenance, and Best Practices - The Short Version", on DAY 2 of the Percona Live Open Source Database Conference 2017, 4/26, at Santa Clara, CA.

Many MySQL shops have made the transition...

Multi-Site, Multi-Master Done Right

Matthew Lang (Continuent) delivers his talk, "Multi-Site, Multi-Master Done Right", on DAY 2 of the Percona Live Open Source Database Conference 2017, 4/26, at Santa Clara, CA.

The MySQL marketplace has quite a few High-Availability (HA) solutions such as Continuent Tungsten, Galera/...