Videos from Percona

Tuning PostgreSQL for High-Write Workloads

Grant McAlister (Amazon Web Services) delivers the talk, "Tuning PostgreSQL for High-Write Workloads", on DAY 1 of the Percona Live Open Source Database Conference 2018, 4/24, at Santa Clara, CA.

In this session, we will cover a number of the way that you can tune PostgreSQL to better handle high write workloads. We will cover both application and database tuning methods as each type can have substantial benefits but can also...

Percona Live SessionsPostgreSQLQuery Tuning and Optimization

Aug 10, 2018

What's New in Alibaba's X-DB SQL Engine

Min Qiu (Alibaba Group),Hui Liu (Alibaba Group) delivers the talk, "What's New in Alibaba's X-DB SQL Engine", on DAY 1 of the Percona Live Open Source Database Conference 2018, 4/24, at Santa Clara, CA.

X-DB is Alibaba's next-generation distributed and intelligent database which is ACID compliant, horizontally scalable, globally deployed and highly available. Motivated by the ideas of decoupling compute and storage, and...

Percona Live SessionsCloudMySQLPerformance

Aug 10, 2018

MySQL at Scale at Square

Daniel Nichter (Square) delivers the talk, "MySQL at Scale at Square", on DAY 1 of the Percona Live Open Source Database Conference 2018, 4/24, at Santa Clara, CA.

At Square we operate several thousand MySQL instances to power a financial network, from payments to payroll. In a word: money. "Mission-critical" isn't critical enough. Come learn how we operate MySQL with billions of dollars at stake. We'll look at everything:...

Percona Live SessionsMySQLMonitoring and OperationsSecurityConfigurationHigh AvailabilityReplication

Aug 10, 2018

Combine the power of OSS DB engines and Microsoft Azure to migrate existing apps or build new apps

Sunil Kamath (Microsoft) delivers the talk, "Combine the power of OSS DB engines and Microsoft Azure to migrate existing apps or build new apps", on DAY 1 of the Percona Live Open Source Database Conference 2018, 4/24, at Santa Clara, CA.

Azure provides fully managed, enterprise-ready community MySQL and PostgreSQL services that are built for developers and devops engineers. These services use the community database technologies...

Percona Live SessionsDeveloperPostgreSQLMySQLPerformanceSecurityHigh Availability

Aug 10, 2018

No MySQL or MongoDB? No Problem! How to Extend PMM's Functionality to Monitor Other DBMSs

Agustín Gallego (Percona), Fernando Ipar (Pythian) delivers the talk, "No MySQL or MongoDB? No Problem! How to Extend PMM's Functionality to Monitor Other DBMSs", on DAY 1 of the Percona Live Open Source Database Conference 2018, 4/24, at Santa Clara, CA.

Percona Monitoring and Management is quickly growing in both functionality and adoption. In this talk, we will discuss how to integrate it with other Database Management Systems...

Percona Live SessionsPostgreSQLMonitoring and OperationsPercona Open Source Software

Aug 9, 2018

How to make MySQL work with Raft Unlisted

Diancheng Wang (Alibaba Cloud), Guangchao Bai (Alibaba Cloud) delivers the talk, "How to make MySQL work with Raft", on DAY 1 of the Percona Live Open Source Database Conference 2018, 4/24, at Santa Clara, CA. For the cloud environment, we hope MySQL cluster can do the failover and choose the new master node by the instance-self automatically, without third-party middleware. So we built the Raft protocol inside MySQL. In MySQL-Raft...

Percona Live SessionsCloudMySQLMySQL-related Technologies

Aug 9, 2018

Query Optimizer - MySQL vs. PostgreSQL

Christian Antognini (Trivadis) delivers the talk, "Query Optimizer - MySQL vs. PostgreSQL", on DAY 1 of the Percona Live Open Source Database Conference 2018, 4/24, at Santa Clara, CA.

MySQL and PostgreSQL are the two most popular open-source relational databases. To help choosing between them, a comparison of their query optimizers has been carried out. The aim of this session is to summarize the outcome of the comparison....

MySQLQuery Tuning and OptimizationMySQL-related Technologies

Aug 9, 2018

MySQL Replication: What's new in MySQL 5.7 and MySQL 8

Luis Soares (Oracle) delivers the talk, "MySQL Replication: What's new in MySQL 5.7 and MySQL 8 ", on DAY 1 of the Percona Live Open Source Database Conference 2018, 4/24, at Santa Clara, CA.

The latest developments and the enticing roadmap, show that MySQL Replication is addressing requirements in different areas such as operations, flexibility, elasticity, automation and seamless scale-out. Moreover, new replication features...

Percona Live SessionsCloudMySQLReplicationMySQL 5.6

Aug 9, 2018

MongoDB 3.6 Features and Their Benefits

David Murphy (Percona) delivers the talk, "MongoDB 3.6 Features and Their Benefits", on DAY 1 of the Percona Live Open Source Database Conference 2018, 4/24, at Santa Clara, CA.

By now you surely know that MongoDB 3.6 Community became generally available on Dec 5, 2017. Of course, this is great news: it has some big-ticket items that we are all excited about! But we need to talk about general thoughts on this release good an...

Percona Live SessionsMongoDBMongoDB 101

Aug 9, 2018

How to Use JSON in MySQL Wrong

Bill Karwin (Square) delivers the talk, "How to Use JSON in MySQL Wrong", on DAY 1 of the Percona Live Open Source Database Conference 2018, 4/24, at Santa Clara, CA.

The JSON data type and functions that support it comprise one of the most interesting features introduced in MySQL 5.7 for application developers. But no feature is a "Golden Hammer." We need to apply a little expertise to get the best result and avoid misusing it....

Percona Live SessionsMySQLMySQL-related Technologies