Percona Live 2022

Links

Percona Live 2022 was an amazing 3-day event of keynotes, educational sessions, hands-on activities, and more. It took place in Austin, TX on May 16th-18th. Attendees could hear the biggest names in the industry, discuss their experience, dive deep into software, and offer actionable advice. They also learned about how open source database technology can power applications, improve websites, secure data, and solve critical database issues. On this page, you can find the list of presentations from Percona Live 2022.

Schedule: https://perconalive2022.sched.com/

Website: https://www.percona.com/live/conferences ∎

Talks

Sharding and Things We'd Like To See Improved Starting with MongoDB version 5.0, we can reshard a collection using the new shard key. But there are still something we think could be improved like: Cluster metadata lack of details on chunks TTL indexes Improvements in the rebalancing process Performance issues on rebalancing data Observability	Igor Donchovski Principal Consultant Pythian May 17, 2022 10:30 MongoDB 1 Classroom 201 M2
Transforming Your DBA Team Into a DBRE/SRE One! A common and modern challenge is how you, as a DB team, can reinvent yourself and align with SLOs, SLIs, and other DevOps and SRE topics. In this talk, we will go through: Team structuring Team culture/branding Ways of working Focuses and goals for the team Sharing reports/data/metrics vs. security/GDPR	David Murphy Amach.ie May 17, 2022 16:00 Partner Classroom 202 M2
Percona XtraBackup - new features and improvements Percona XtraBackup is an open-source hot backup utility for MySQL - based servers that doesn't lock your database during the backup. In this talk, we will cover the latest development and new features introduced on Xtrabackup and its auxiliary tools: - Page Tracking - Azure Blob Storage Support - Exponential Backoff - Keyring Components - and more.	Marcelo Altmann MySQL Software Developer Percona May 16, 2022 10:30 Advanced Database Topics Classroom 202 M2
Database Reliability Engineering for MySQL A common request that we get from our clients is to make MySQL highly available or to enhance existing architecture. We have standardized our approach by combining a proxy layer, for traffic redirection, a topology management tool, for master failover/switchover, and some additional tools to glue together both layers.	Matthias Crauwels Principal Consultant Pythian Services Inc May 16, 2022 11:15 Advanced Database Topics Classroom 202 M2
The Road Toward an Open Database Performance Ranking Understanding the performance of different databases is crucial for building efficient, data-intensive applications. Benchmarking possible databases is a valid option for enabling such comparison, yet, it is a major challenge due to heterogeneity in the resource, database, and workload level. To enable an on-demand comparison of cloud-hosted databases, we present a database performance ranking as an open dataset that is created with the Benchmarking-as-a-Service platform benchANT. This ranking will be continuously extended to cover the latest advancements in the cloud resource, database, and benchmark domain.	Daniel Seybold Co-Founder & Product Development benchANT May 16, 2022 14:15 Advanced Database Topics Classroom 202 M2
The Development of Cloud-native Database GaussDB for MySQL GaussDB for MySQL is a cloud-native database system based on MySQL 8.0. It uses the "log is the database" paradigm and separates compute and storage. It takes the full advantages of a computational storage system with flexible consistency models for superior performance and availability. Further, the system offloads certain query operators down to the storage layer to reduce data movement. The development of a multi-master system is also underway. This talk will cover the following topics: Overview of the GaussDB for MySQL architecture Design and implementation of near data processing (NDP) Development of cloud-native multi-master Performance results Future directions	Calvin Sun; Alex Depoutovitch May 16, 2022 15:00 Advanced Database Topics Classroom 202 M2
So That's Why It's So Fast! An Introduction to ClickHouse Internals Are you a ClickHouse fan? Want to make your apps faster? This talk introduces ClickHouse internals, focusing on how to make analytic queries faster and more efficient. We'll cover data insertion, aggregation, joins, and distributed queries. You'll learn about the basic flow of query execution, how ClickHouse parallelizes processing, and how it uses memory. We'll also show you standard tools like the system.query_log table that help you diagnose problems, trace distributed queries, and track memory usage. To enjoy the talk, all you need is a basic knowledge of SQL. We'll supply the rest!	Robert Hodges May 16, 2022 15:45 Advanced Database Topics Classroom 202 M2
Advanced PMM Usage Have you already deployed Percona Monitoring and Management (PMM) and wonder what else you can do with the tool? Come to this talk to learn how to: Build a custom dashboard from scratch (it really is easy!). Leverage Custom Queries for MySQL and PostgreSQL to plot data unique to your dataset. Use the textfile collector to pull in data you generate from a shell script.	Michael Coburn; Francisco Bordenave May 18, 2022 15:00 Percona Classroom 106 M1
Building an Open Source MongoDB-compatible Database on Top of PostgreSQL MongoDB is a life-changing technology for many developers, empowering them to build applications faster than using relational databases. However, MongoDB abandoned its open source roots, changing the license to SSPL and making it unusable for many open source and commercial projects. We decided to change that, so we started working on FerretDB – an open-source proxy, written Go, that accepts connections and handles queries from unmodified MongoDB clients, and stores data in PostgreSQL. In our talk, we will discuss our reasoning for starting this project, our vision, the current state of FerretDB, some interesting implementation details, and our plans for the future.	Alexey Palazhchenko; Peter Farkas May 17, 2022 17:00 Percona Classroom 106 M1
Better MySQL With Percona Monitoring and Management Optimizing MySQL performance, troubleshooting MySQL problems, and managing backups are the most critical and challenging tasks for MySQL DBAs in their daily routine. The databases powering your applications need to be able to handle changing traffic workloads while remaining responsive and stable so that you can deliver an excellent user experience. At the same time, modern database vendors demonstrate a trend of moving away from traditional deployment methods to DBaaS, which means DBAs are also expected to find cost-efficient means of solving these issues. In this presentation, we will demonstrate the advanced options of PMM that enable you to solve these challenges. We will show how to get the DBaaS experience built on free and open-source software. We will look at specific, common MySQL problems and review them.	Peter Zaitsev CEO Percona May 17, 2022 17:00 MySQL Classroom 104 M1
Opening remarks and Key Open Source Databases Strategies That Shape 2022 It has been an exciting year in the open source database industry, with more choice, more cloud, and key changes in the industry. We will dive into the key developments over 2022, including the most important opensource database software releases in general, the significance of cloud-native solutions in a multi-vendor, multi-cloud world, the new criticality of security challenges, and the evolution of the open source software industry.	Ann Schlemmer; Peter Zaitsev May 17, 2022 08:30 Keynote Zlotnik Ballroom
How is open source shaping up to survive and thrive in the Roaring 20’s? In a time of turbulence can our immature open source model survive attack? Why does it matter that open source is not a business model? Why is open source open to use for any purpose by anyone? How do our Governments adopt secure open source ? This challenging talk questions the status quo in strategic and topical view of open source, its usage, commercialization and place in the world as a public or common good. This talk is dedicated to our colleagues in the #opensource communities in Ukraine, #standwithukraine	Amanda Brock CEO OpenUK May 17, 2022 09:05 Keynotes Zlotnik Ballroom
Build a Powerful Alerting Platform by Integrating Alertmanager With PMM Percona Monitoring and Management (PMM) is known for its great monitoring functionality. However, its integrated alerting capability, as of now implemented, is limited and sometimes complex to manage. The Alertmanager handles alerts sent by client applications. It takes care of deduplicating, grouping, and routing them to different receivers such as email, PagerDuty, or OpsGenie. With PMM and Alertmanager combined, you can build a powerful monitoring and alerting system that will alert you through multiple communication channels if either a simple health check fails or in case of a pattern change that may indicate an issue.	Ananias Tsalouchidis; Tibor Korocz May 17, 2022 17:00 Partner Classroom 202 M2
The Future of Percona Products Donnie will share where Percona products are headed over the next few years, as well as a major announcement. Everyone who's using or considering Percona software or services will want to attend this keynote.	Donnie Berkholz SVP Product Management Percona May 17, 2022 09:30 Keynotes Zlotnik Ballroom
The Complete MariaDB Tutorial The MariaDB Server is loaded with lots of new features to increase data integration, performance, availability, scalability, and orchestration. We will cover the features where MariaDB Server is enhanced compared to MySQL, where it differs, how to harness its new features (e.g., CONNECT engine, Galera Cluster, Oracle compatibility, etc.), and most importantly, how to get the most out of MariaDB. This is a practical hands-on session that will leave an intermediate MySQL with knowledge on how to be an effective MariaDB DBA.	Colin Charles Consultant codership (galera cluster) May 16, 2022 09:00 Tutorial Salon 2 Zlotnik L
Deploying Highly Available, Durable Amazon RDS for PostgreSQL and for MySQL Databases With Multi-AZ With Two Readable Standbys Amazon Relational Database Service (Amazon RDS) for PostgreSQL and for MySQL now supports a new Amazon RDS Multi-AZ deployment option with one primary and two readable standby database (DB) instances across three Availability Zones (AZs). With this new option, Multi-AZ users can get up to 2x faster transaction commit latency compared to one standby, typically under 35 second failovers, and additional read capacity. In this session, learn about the new option, how it compares to other high availability options, and see a demo on how to get started.	Vijay Karumajji; Pandit Prasad May 18, 2022 09:30 Live Streaming Salon 1 Zlotnik L
Efficient MySQL Performance MySQL performance can be challenging for new software engineers because where does one begin? Even experienced engineers can find MySQL performance challenging because it's not their area of expertise. In this talk, I show a path to learning and achieving better MySQL performance by focusing on the most important topics for software engineers using MySQL, not aspiring DBAs. Focus is the "efficient" in the title of this talk and my recently published book, Efficient MySQL Performance (O'Reilly 2022), where I explore and layout the path in detail.	Daniel Nichter DBA Block May 18, 2022 14:00 Live Streaming Salon 1 Zlotnik L
Postgres and the Artificial Intelligence Artificial intelligence, machine learning, and deep learning are intertwined capabilities that attempt to solve problems that defy traditional computational solutions --- problems including fraud detection, voice recognition, and search result recommendations. While they elude simple computation, they are computationally expensive, involving the calculation of perhaps millions of probabilities and weights. These computations can be done outside the database, but there are specific advantages of doing machine learning inside it, close to where the data is stored. This presentation explains how to do machine learning inside the Postgres database.	Ibrar Ahmad Sr. Software Architect Percona May 18, 2022 09:30 Live Streaming Salon 1 Zlotnik L
PostgreSQL Challenges PostgreSQL challenges	Bruce Momjian Vice President, Postgres Evangelist EDB May 18, 2022 08:45 Keynotes Zlotnik Ballroom
MySQL 8 New Features MySQL 8 has been among us for a while and brought some interesting features when it was launched. However, new features have been constantly added. In this talk, we will talk about the latest added features that can improve MySQL operations: DDL improvement such as parallelization New server status variables (to improve monitoring and health analysis) Performance Schema instrumentation DROP / TRUNCATE operations REDO log capabilities (archiving, disabling) EXPLAIN tree format Parallel read threads INSTANT algorithm We will share our experience to help the audience become familiar with all the new features to extract the full potential of MySQL.	Vinicius Grippa Senior Support Engineer Percona May 16, 2022 15:45 Database 101 for Developers Classroom 201 M2
Oracle to PostgreSQL Migration with Near Zero Downtime Enterprises face many challenges to migrate off of legacy databases and embrace more open source database technologies. These legacy databases have vendor lock-ins, run on on-premise data centers, are difficult to maintain and are expensive to license. In this session, we will cover how Broadcom Software successfully migrated from an Oracle RAC Cluster to PostgreSQL HA Cluster with near zero downtime. We will go into specifics about migration methodologies, tools used, challenges encountered, data migration, data validation and PostgreSQL best practices. We will also share our experiences running PostgreSQL and some of the pitfalls to avoid.	Sumit Aneja; Vinay Kamble May 17, 2022 16:00 MySQL Classroom 104 M1
Managing PostgreSQL With Ansible Ansible is an open source configuration management and deployment tool, which can be used to manage servers and software installations. This talk will briefly cover Ansible itself, and then explain how Ansible is used to install and configure PostgreSQL on a server. Demos will round up the talk.	Andreas Scherbaum Head of Databases Adjust GmbH May 17, 2022 10:30 PostgreSQL 1 Classroom 203 M2
What’s New in Amazon Web Services Amazon Web Services (AWS) is the world’s most comprehensive and broadly adopted cloud platform, offering over 200 fully-featured services from data centers globally. Millions of customers—including the fastest-growing startups, largest enterprises, and leading government agencies—are using AWS to lower costs, become more agile, and innovate faster. In this session, learn about the latest innovations, features, and capabilities from AWS.	Barry Morris GM ElastiCache, Timestream and DocumentDB May 17, 2022 10:30 Partner Classroom 202 M2
The Future of MySQL MySQL is undoubtedly one of the most successful SQL databases in the past decades. With the emergence of new scenarios and applications, the MySQL community is becoming more diverse than ever. In this talk, I will share my observations from a database designer's perspective in the MySQL community in the last few years, as well as some interesting new databases and some of my predictions for the future MySQL community and products. Late in the session, I will share some great news about TiDB, the open-source distributed database we are working on.	Ed Huang Co-founder and CTO PingCAP May 18, 2022 14:00 MySQL Classroom 104 M1
Downsampling in PMM	Dima Lazerka Co-Founder Victoria Metrics May 16, 2022 13:30 Advanced Database Topics Classroom 202 M2
Dude, where's my column? Building an object-oriented abstraction over Postgres EdgeDB is a "post-SQL" database that aims to modernize the relational model for modern development. This talk will discuss: the usability issues with RDBMSes that inspired EdgeDB's creation how EdgeDB extends the relational paradigm the design of its query language EdgeQL the broad strokes of its architecture how it leverages the power of Postgres under the hood future directions	Colin McDonnell Head of Developer Relations EdgeDB May 17, 2022 14:30 PostgreSQL 2 Salon 2 Zlotnik L
The Lost Art of Database Design The scalability of your application and your database is only as good as the database design you put behind it. Designing your schema, the database structures, and planning for the future need to happen early and needs to evolve over time. In today's rapid pace development cycles, the database design is often overlooked or even dismissed entirely. Databases and marketing teams tout "Schemaless Designs", database as a service, and new tech that makes caring about databases a thing of the past. I will explain why database design is as important as ever and I will give you the 8 things you need to design on every application regardless of which database or service you use.	Pep Pla Consultant Percona May 18, 2022 10:50 Live Streaming Salon 1 Zlotnik L
10 Reasons Why the TiDB Database Should Power Your Next Development Project You have one database for online transaction processing (OLTP) and another for online analytical processing (OLAP). Does it have to be this way? Fortunately, it doesn't. There is a new breed of database that combines the functionality of OLTP and OLAP databases. It's called HTAP (Hybrid Transactional Analytical Processing) and it is a game changer. TiDB, from PingCAP, is the leading HTAP database. It transparently combines OLTP and OLAP functionality into a single, open source database. During this presentation we will discuss the technology that powers TiDB and describe how it can help you solve your most pressing data needs.	Jeff Bailey Education North America Regional Manager PingCAP May 18, 2022 15:00 PostgreSQL 1 Classroom 203 M2
The future of databases is being decided for you…	Steve Hoffman SVP, Engineering in Eng-Platform Percona May 18, 2022 08:30 Keynote Zlotnik Ballroom
State of the Dolphin I cover (very highly) what happened last year in MySQL development and thx our contributors. It's like a what have we done at MySQL last year, what have we improved, released etc...	Frederic Descamps MySQL Community Manager Oracle May 18, 2022 09:05 Keynote Zlotnik Ballroom
Unify Your Database Experience with Percona Platform Managing complex database environments is incredibly challenging across multiple open databases, spanning across clouds and on-premises. Learn how you can easily monitor, secure, and optimize your database environments on any infrastructure with Percona Platform. It brings together expert-curated database distributions, monitoring, and management tooling with Percona’s renowned expertise into a single product that helps DBAs focus on creating value.	Barrett Chambers; Donnie Berkholz May 18, 2022 11:50 Live Streaming Salon 1 Zlotnik L
Simplifying the Top Complexities While Migrating From Oracle to PostgreSQL This talk will cover simplifying some of the major complexities while performing migrations from Oracle to PostgreSQL. The following topics will be covered in detail, alongside a demo and a detailed explanation. Converting sysdate from Oracle to PostgreSQL. Among a variety of options available in Postgres, which one is correct? Converting Hierarchical Queries from Oracle to PostgreSQL. Is Recursive CTE a correct alternative Understanding Internals of the available solutions. Implementing Associative Arrays in PostgreSQL. Understanding the correct alternatives for Oracle Array Indexes and other complexities.	Avinash Vallarapu CEO and Database Performance Tech Lead MigOps May 17, 2022 11:30 PostgreSQL 1 Classroom 203 M2
Database-as-a-Service for a Hybrid Multicloud World	Krishna Kattumadam Vice President of Engineering – Solutions Nutanix May 17, 2022 13:30 Partner Classroom 201 M2
Neon tech - Separation of storage and compute for Postgres In this talk we will introduce Neon - a new serverless fully managed Postgres which is open source and written in Rust. The talk will cover Neon's architecture of separation of storage and compute and demonstrate how this architecture allows to build serverless, branchable, and bottomless Postgres as a service.	Bojan Serafimov System Software Engineer Neon May 18, 2022 14:00 PostgreSQL 1 Classroom 203 M2
Making Postgres Central in Your Data Center Postgres has the unique ability to act as a powerful data aggregator in many data centers. This talk shows how Postgres's extensibility, access to foreign data sources, and ability handle NoSQL-like and data warehousing workloads gives it unmatched capabilities to function in this role.	Bruce Momjian Vice President, Postgres Evangelist EDB May 17, 2022 13:30 MySQL 2 Classroom 105 M1
Backup/Restore tools - performance and comparison Backup/Restore tools - performance and comparison	Vinicius Grippa Senior Support Engineer Percona May 16, 2022 10:30 Database 101 for Developers Classroom 201 M2
Comparing DDL operations through several solutions like Aurora, Percona XtraDB Cluster and MySQL server Perform agile schema design, is the new frontier for DBA. The pressure to be able to modify and adapt the schema definition to the code needs and evolution is nowadays a must have for most of the software companies. Unfortunately the reality of what can be done natively by most of our RDBMS solutions is not facilitating this task. In this presentation, we will illustrate what the current limitations are by comparing different solutions. We will also take a look at what is piling in the pot for new solutions and what to expect.	Francisco Bordenave Senior Architect Percona May 16, 2022 11:15 Database 101 for Developers Classroom 201 M2
The Top 10 Mistakes When Migrating Oracle Databases to PostgreSQL Many major organizations like Amazon have moved their fleets of Oracle database to PostgreSQL, and many more are embarking on the change every day. As part of these migrations, a distinct pattern of mistakes has emerged that lead to project delays, performance issues, and frustration. These mistakes can be caused by the tools being used or just by not understanding how PostgreSQL is different than Oracle. In this talk, we will discuss the top mistakes people generally make when moving to PostgreSQL from Oracle and what the correct course of action to take.	Jim Mlodgenski Principal Database Engineer Amazon May 17, 2022 14:30 PostgreSQL 1 Classroom 203 M2
The Evolution of a MySQL Database, From a Single Instance to HA With Disaster Recovery From a single MySQL instance to multi-site high availability, this is what you will find out in this presentation. You will learn how to make this transition and which solutions best suit changing business requirements (RPO, RTO). Recently, MySQL has extended the possibilities for easy deployment of architecture with integrated tools. Come and discover these open source solutions that are part of MySQL.	Frederic Descamps MySQL Community Manager Oracle May 17, 2022 10:30 Live Streaming Salon 1 Zlotnik L
ProxySQL at Scale on AWS At Pinterest, the ProxySQL infrastructure fronts numerous heterogeneous databases. Due to the high number of unique configurations and dynamic nature of cloud deployments, it’s a challenge to reliably provision, change, auto-scale, and monitor ProxySQL servers. Applying Infrastructure as Code principles using Terraform, we made it possible to manage such a large fleet of ProxySQL instances confidently. Come learn how we automated provisioning, testing, and monitoring of ProxySQL at scale.	Oleksandr Kuzminskyi Staff Database Engineer Pinterest May 17, 2022 10:30 MySQL 2 Classroom 105 M1
PostgreSQL in the Cloud: DBaaS vs Kubernetes Applications in the cloud on Kubernetes are very common these days. Most of the time, they need a database (like PostgreSQL). There are two often considered alternatives: 1. Use DBaaS - for example, Google CloudSQL for PostgreSQL 2. Deploy the database on Kubernetes with the application We'll compare those approaches from different angles to clarify the differences. You'll be better equipped to decide how to run PostgreSQL for your cloud-native application. We'll focus on Google CloudSQL and Percona Distribution for PostgreSQL Operator on Google Kubernetes Engine (GKE). Still, most of the knowledge is universal across cloud platforms and DBaaS solutions.	Michal Nosek Enterprise Architect Percona May 17, 2022 10:30 Percona Classroom 106 M1
Non-relational Postgres This talk shows the many ways that Postgres has expanded to support non-relational storage, specifically the ability to store and index multiple values, even unrelated ones, in a single database field. The talk will cover examples of multiple-value-per-field storage, including arrays, ranges, geometry, full text search, xml, json, and records.	Bruce Momjian Vice President, Postgres Evangelist EDB May 17, 2022 10:30 PostgreSQL 2 Salon 2 Zlotnik L
How-to MySQL Performance Diagnostic Using Percona PMM This session will give a live tour of how we use PMM at our Support department to systematically find the root cause of performance issues. We will showcase our bottom-up approach, based on the U.S.E. method by Brendan Gregg, and will diagnose a live workload that attendees themselves will have a chance to tweak during the presentation.	Marcos Albe Principal Support Engineer Percona May 17, 2022 11:30 Live Streaming Salon 1 Zlotnik L
MongoDB Monitoring and Alerting With PMM In this session we will cover PMM's latest developments in detail, which include new functionality for MongoDB like collection statistics, index usage and top command monitoring. We will also show you how to configure alerting via PMM's integrated alerting capabilities.	Ivan Groenewold Architect Percona May 17, 2022 11:30 MongoDB 1 Classroom 201 M2
Database Incident Management: When Everything Goes Wrong As database professionals, we're often the last line of defense for our companies' data. When the systems we manage go down, the consequences are usually severe. In this talk, we will discuss incident management practices that can help any DBA/DRE teamwork through tough issues, even when the pressure is high. We'll talk about tips that span the various stages of an incident: detection, alerting, response, postmortem, and prevention, and the different challenges a database team faces compared to other disciplines.	Josh Varner Core MySQL Lead Shopify May 17, 2022 11:30 MySQL 2 Classroom 105 M1
MySQL Backups at Booking.com Booking.com is one of the largest travel e-commerce companies in the world. Booking.com uses MySQL at scale to power its online business. Business data needs backups, and backups at scale come with many challenges. We will tell you about the challenges we faced and the solutions we implemented.	Peter Boros; Nicolai Plum May 17, 2022 11:30 Percona Classroom 106 M1
Using Roles and Partial Revokes To Improve Security in MySQL 8.0 For many years MySQL had a problem with managing granular privileges: Anyone who had all privileges on a MySQL system database could grant all other privileges, including "grant option" and "super." That complicated managing privileges and resulted in a less secure setup. MySQL 8.0 introduced 3 critical features: 1. partial revokes 2. splitting SUPER privilege to more granular set and 3. roles. In this presentation, I will show how to use the new features to increase MySQL security and protect it from privilege escalations.	Alexander Rubin Sr Database Engineer Amazon Web Services May 17, 2022 11:30 MySQL Classroom 104 M1
Get Your Insecure PostgreSQL Passwords to SCRAM! PostgreSQL 10 introduced SCRAM (Salted Challenge Response Authentication Mechanism) to securely authenticate passwords. The SCRAM algorithm lets a client and server securely validate a password without ever exchanging the password using a series of cryptographic methods! In this talk, we will look at: A history of password storage and authentication in PostgreSQL Flaws in each of the legacy PostgreSQL password-based authentication methods How SCRAM works with a guided deep dive into the algorithm Channel binding, which helps prevent authentication MITM attacks How to safely set and modify your passwords, and how to upgrade to SCRAM-SHA-256	Jonathan Katz Principal Product Manager Technical AWS May 17, 2022 11:30 PostgreSQL 2 Salon 2 Zlotnik L
PostgreSQL Replication Conflicts: Avoiding Pitfalls Experiencing replication conflicts is not too unfamiliar a sight. Whether one experiences replication lag, slots, locks, snapshots, tablespace issues, or other conflicts, establishing a set of best practices along with using proper observability tools will help avoid potential issues. This talk focuses on what to do and what not to in order to avoid database conflicts in streaming replication setups by providing deep insight into how issues are PostgreSQL internals.	Hamid Akhtar Senior Software Engineer Percona May 17, 2022 13:30 PostgreSQL 1 Classroom 203 M2
MariaDB Scaling - From Single Instance to Multiple Clusters In this session, we will follow the story of growing applications with respect to database architecture. From single-instance database on developer's machine to cross-DC multi-cluster HA setup using Galera, ProxySQL, and anycast routing.	Michal Kuchta SW Architect Seznam.cz May 17, 2022 13:30 Live Streaming Salon 1 Zlotnik L
Best Practices To Run Percona Operator for MySQL Percona Operator for MySQL (POM) is the first MySQL operator that can be considered production-ready. However, there are many small things that require attention to successfully run and manage your data using this solution. The presentation will illustrate what you need to know before rolling out POM, and what you need once it is in production. Your takeaway will be a better understanding of the product and some practical instructions on what is needed in order to have a healthy setup.	May 17, 2022 13:30 Percona Classroom 106 M1
RocksDB Performance and Reliability Practices Meta/Facebook's database serving social workloads is running on top of MyRocks (MySQL on RocksDB). This means our performance and reliability depends a lot on RocksDB. Not just MyRocks, but also we have other important systems running on top of RocksDB. We have learned many lessons from operating and debugging RocksDB at scale. In this session, we will offer an overview of RocksDB, key differences from InnoDB, and share a few interesting lessons learned from production.	Yoshinori Matsunobu Production Engineer Meta May 17, 2022 13:30 MySQL Classroom 104 M1
A Detailed Understanding of MVCC and Autovacuum Internals in PostgreSQL 14 PostgreSQL implements MVCC in a slightly different way when compared to databases like Oracle, MySQL, and others. In PostgreSQL, you'll see a different method for managing UNDO, which requires a cleanup concept called vacuum. It is now important for PostgreSQL admins/DevOps to understand the internals of autovacuum and the MVCC implementation. Let us discuss MVCC and autovacuum in this talk in detail. This talk includes a discussion of the following topics in detail: MVCC and Autovacuum Internals in PostgreSQL. Tuning Autovacuum. Problems you may see in a busy OLTP database with untuned autovacuum settings. Enhancements in PostgreSQL 14	Avinash Vallarapu CEO and Database Performance Tech Lead MigOps May 17, 2022 13:30 PostgreSQL 2 Salon 2 Zlotnik L
Walking Through Identifying and Drilling Into a Slow Down in MongoDB In this session, we will be going through different areas which need to be examined in order to find the bottlenecks causing a slowdown in our MongoDB database, starting from database model, query pattern, indexing strategy, server resources, and need for scalability. We will be using Percona Monitoring and Management tool for the metrics and Query Analytics to deep dive into our database.	May 17, 2022 13:30 MongoDB 1 Classroom 201 M2
Scaling Venmo Applications for Growth With Zero Database Downtime Venmo had 44% YoY TPV growth in 2021. Traffic growth and new product features resulted in many scalability challenges, including higher database connections, especially during high-velocity events throughout the year. This talk will describe how we used proxy solutions for MongoDB and Aurora-MySQL to scale with traffic, various alternatives explored and driving factors narrowing down to a chosen approach. We will share how we migrated the traffic via proxy with zero downtime, challenges faced and solutions applied to achieve our goals. You can take away valuable lessons learned and get tips on how you could tackle similar challenges in your organization.	Kushal Shah; Puneeth Melavoyraja May 17, 2022 14:30 Live Streaming Salon 1 Zlotnik L
New Client Tool for Developers and DBAs In this session, you will discover a totally new tool that we will release just before the conference. This multi-platform tool will make life easier for developers and DBAs using MySQL. It provides visual and command line capabilities that will make all MySQL users happy, from beginners to experts. If you like eye-candy material, join my talk. You won't regret it!	Frederic Descamps MySQL Community Manager Oracle May 17, 2022 14:30 MySQL 2 Classroom 105 M1
Vitess VReplication: Standing on the Shoulders of a MySQL Giant Vitess provides a large set of features that allow you to use and manage a scalable set of MySQL database instances across custom partitions or shards of your dataset as if it was a single logical database. One of the key components used within Vitess is called VReplication. In this talk, we'll cover what VReplication is and how it relates to MySQL replication, including how VReplication leverages the technologies you're already familiar with while expanding on them to add a set of powerful primitives and abstractions that support an ever-growing list of high-level features such as sharding and resharding of tables, materialized views, online DDL, change streams (CDC), and message or job queues. This talk should leave a MySQL user/operator with a good understanding of what VReplication could do for them and when they may want to use it.	Matt Lord Principal Engineer Planetscale May 17, 2022 14:30 MySQL Classroom 104 M1
How To Improve PostgreSQL Monitoring and Observability With PMM Percona Monitoring and Management (PMM) is a great open source tool used to monitor databases. In this talk, we'll demonstrate how to set up and use the tool to make the most out of your PostgreSQL deployments. We'll review the built-in metrics and dashboards, and how you can add your own customized ones! PMM collects data with up to one-second resolution, and it will retain it for months. After attending the talk, you will be able to: Navigate the different metric dashboards Proactively detect bottlenecks Troubleshoot performance issues Optimize configuration settings Analyze query information	Agustin Gallego; Charly Batista May 17, 2022 14:30 Percona Classroom 106 M1
Efficiently Deploying PostgreSQL Instances: The Evolution We will review how to deploy PostgreSQL environments and be able to have any version of PostgreSQL running within minutes... or even seconds! You will learn what cool tools the Percona Support team uses to efficiently deploy everything from standalone servers to more complex replication and HA topologies. After attending, you will have all the knowledge you need to start testing your applications against fully functional PostgreSQL instances... fast! This talk is an evolution of "Efficiently Deploying PostgreSQL Instances," after one year of added functionality to the tools presented in the past.	Agustin Gallego Senior Support Engineer Percona May 17, 2022 16:00 PostgreSQL 1 Classroom 203 M2
Looking Ahead at PostgreSQL 15 Feature freeze for PostgreSQL 15 has come and gone. What does this mean for the upcoming release? This talk explores many of the new features that will be released in the next major version of PostgreSQL and explains how they can impact your workload. Some of the features may change before general availability, but this talk will give you directional guidance on targeting PostgreSQL 15 for upgrade.	Jonathan Katz Principal Product Manager Technical AWS May 17, 2022 16:00 Live Streaming Salon 1 Zlotnik L
Diagnosing Database Issues With MySQL 8.0’s Performance Schema You’re probably aware of the valuable query data stored in the Performance Schema, which pros use to monitor and improve query behavior. Did you know that MySQL 8.0 added additional columns to those tables and a brand-new dataset, one which includes fine-grained details of query performance and outlying executions over time? In this breakout session, you’ll learn: The new query data added to MySQL’s performance tables The new statement histogram summary Code examples to capture and display this information How to most effectively leverage this new dataset to improve performance	Robert Mandeville Manager, Sales Engineering Solarwinds May 17, 2022 16:00 MySQL 2 Classroom 105 M1
MySQL at Scale: Booking MariaDB to MySQL Migration Booking has one of the largest MySQL deployments in the world. Operating thousands of servers is not trivial. To perform database upgrades and migrations in an environment like this requires careful planning and can take weeks or months. In this session we will cover: The Booking MySQL architecture Operation at scale The problem: Migrate from MariaDB to MySQL The process: Do not migrate, replace The outcome: Migration completed and lessons learned	Pep Pla; Mohammed Gaafar May 17, 2022 16:00 Percona Classroom 106 M1
Big Data. Or Just Too Much Data? Do you have a multi-terabyte MySQL instance and feel it has become unmanageable? Reporting queries take longer and longer, backup storage cost is ever-increasing, and simple queries take seconds to run? Join us to understand the practical limits of MySQL, learn how to tame your data, and find out what the alternatives are.	Marcos Albe Principal Support Engineer Percona May 17, 2022 10:30 MySQL Classroom 104 M1
PBM - The Backup Open Source Tool for MongoDB Backup and restore are two of the most important things for databases. We don't often use the backup, but during a disaster situation, it is crucial to work. In this session, we will discuss Percona Backup for MongoDB (PBM short). We will walk through the process of taking backups and executing restores. We will also introduce the newest backup method that PBM offers, the physical backup in addition to the logical backup. After the introduction of the backup methods, we will evaluate the backup and restore times, and how to store the backup on remote backup storage.	Jean da Silva; Vinicius Grippa May 17, 2022 14:30 MongoDB 1 Classroom 201 M2
Solving PostgreSQL Wicked Problems: Oriole DB Inc. PostgreSQL is one of the most popular DBMSes in the world. But we can see a set of wicked problems in PostgreSQL design, which came from Berkley or were added in very early development stages. Those problems are very annoying for users and aren't resolved for decades: bloat, xid wraparound, write-amplification, and more. Miraculously, with just a small patch to PostgreSQL core extending this API, it appears possible to solve wicked PostgreSQL problems in a new engine made within an extension. This talk covers how the new engine is integrated with PostgreSQL Core and solves the wicked PostgreSQL problems.	Mehboob Alam; Alexander Korotkov May 17, 2022 16:00 PostgreSQL 2 Salon 2 Zlotnik L
PostgreSQL Extensions: A Deep Dive PostgreSQL is designed to be easily extensible. For this reason, extensions loaded into the database can function just like features that are built-in. In this session, we will learn more about the PostgreSQL extension framework and how they are built.	Jignesh Shah Senior Software Development Manager Amazon Web Services May 17, 2022 17:00 PostgreSQL 1 Classroom 203 M2
Data Consistency at Scale in Meta Meta has gone through multiple large scale MySQL rollouts like MyRocks and 8.0 migrations. To avoid the potential data inconsistency introduced by those migrations and various other small rollouts like minor version upgrades, we implemented several large scale consistency checking tools to help surface issue at early stage. In this talk, we will cover how these tools work under the hood and share some stories about how they have helped in large-scale rollouts.	Junyi Lu Production Engineer Meta/Facebook May 17, 2022 17:00 Live Streaming Salon 1 Zlotnik L
MySQL Parallel Replication: All the 5.7 and 8.0 Details (LOGICAL_CLOCK) To get better replication speed and less lag, MySQL implements parallel replication in the same schema, also known as LOGICAL_CLOCK. But fully benefiting from this feature is not as simple as just enabling it. In this talk, I explain in detail how this feature works. I also cover how to optimize parallel replication and the improvements made in MySQL 8.0 and back-ported in 5.7 (Write Sets), greatly improving the potential for parallel execution on replicas (but needing RBR). Come to this talk to get all the details about MySQL 5.7 and 8.0 Parallel Replication.	Jean-François Gagné System and MySQL Expert HubSpot May 17, 2022 17:00 MySQL 2 Classroom 105 M1
Reducing Costs and Improving Performance With Data Modeling in Postgres During this talk, we will explain how PostgreSQL organizes the data internally, how the Free Space Map (FSM) works, and how we can reorganize the data model to take advantage of data alignment inside blocks, reducing the size of the data in the disk and consequently in memory, which can save money and improve performance. Understanding how PostgreSQL organizes the data internally can save you a lot of money!	Charly Batista PostgreSQL Tech Lead Percona May 17, 2022 17:00 PostgreSQL 2 Salon 2 Zlotnik L
PostgreSQL Internals for Oracle, MySQL DBAs and Beginners This tutorial is focused on teaching PostgreSQL to professionals who are already experienced with Oracle or MySQL. As we discuss from the basics, even a beginner may adapt the concepts easily. Here are the main points covered in this tutorial: Brief history of PostgreSQL and its features PostgreSQL Architecture for MySQL/Oracle DBAs and beginners. Basics of PostgreSQL including Installation, Data Directory, and Managing a Cluster. Architecture and Internals. MVCC, AUTOVACUUM, and Transaction ID Wraparound in PostgreSQL User Management Types of Indexes Logical and Physical Backups and PITR Declarative Partitioning.	Avinash Vallarapu CEO and Database Performance Tech Lead MigOps May 16, 2022 09:00 Tutorial Classroom 203 M2
MySQL Architectures: Design the Right Solution for Your Needs In this tutorial, we will cover the different deployment possibilities of the MySQL architecture depending on the business requirements for the data. We will also deploy some architecture and see how to evolve to the next one. The tutorial covers the new MySQL Solutions like InnoDB ReplicaSet, InnoDB Cluster, and InnoDB ClusterSet. Users will get familiar with the MySQL Shell Admin API and MySQL Router.	Frederic Descamps MySQL Community Manager Oracle May 16, 2022 09:00 Tutorial Classroom 104 M1
PostgreSQL High Availability With Patroni High availability is a key point in any modern system, and it's no different for Postgres. We will discuss some designs that can be used to implement a high available database ecosystem, and we'll see that it doesn't need to cost a liver to implement. We'll discuss restrictions, the minimum level of availability we can accept (SLA), if it's possible to implement with the budget we have, and if not, what can be done to mitigate the problem and get as close as possible.	Charly Batista PostgreSQL Tech Lead Percona May 16, 2022 09:00 Tutorial Classroom 105 M1
High Availability With Percona XtraDB Cluster Percona XtraDB Cluster is the defacto standard when it comes to high availability with MySQL. We will cover installation and setup of Percona XtraDB Cluster (PXC), interworkings of Galera, various gotchas, and how to achieve ultimate HA by incorporating ProxySQL.	Matthew Boehm Senior Instructor / Senior Architect Percona May 16, 2022 09:00 Tutorial Classroom 106 M1
Cloud-native MongoDB 101 Tutorial Would you like to learn how to easily deploy a complete and robust MongoDB environment for your cloud-native applications on Kubernetes? Bring your laptop! You'll get a chance to get your hands dirty with Percona Distribution for MongoDB Operator in a dedicated environment. We'll cover areas like: Deploying a shared MongoDB cluster from scratch Configuring the cluster according to your needs Connecting to the cluster Scaling up and out Backups and restores Monitoring and observability Upgrades You'll see some slides, but the goal is to have you work hands-on as much as possible.	Michal Nosek; Takis Stathopoulos May 16, 2022 09:00 Tutorial Salon 1 Zlotnik L
Enabling Full-text Search Capabilities on Amazon DocumentDB (With MongoDB Compatibility) Using Amazon OpenSearch Amazon DocumentDB (with MongoDB compatibility) is a purpose-built document database service used for various NoSQL data storage use-cases within applications. As these applications evolve, you may want to gain further insights or add functionality that require you to search entire collections to find patterns related to specific words. In this talk, we show you how to integrate Amazon DocumentDB with Amazon OpenSearch so you can run full text search queries on data stored in Amazon DocumentDB.	Kehinde Otubamowo; Douglas Bonser May 17, 2022 16:00 MongoDB 1 Classroom 201 M2
Mastering PostgreSQL Administration This talk is designed for PostgreSQL administrators. It covers all aspects of PostgreSQL administration, including installation, security, file structure, configuration, reporting, backup, daily maintenance, monitoring activity, disk space computations, and recovery. It shows how to control host connectivity, configure the server, and find the query being run by each session.	Bruce Momjian Vice President, Postgres Evangelist EDB May 16, 2022 13:30 Tutorial Classroom 203 M2
Getting Started With InnoDB Cluster in MySQL 8 Since MySQL 5.7, InnoDB Cluster saw the light. With MySQL 8.0, the solution has matured a lot, and it has become a full-scale, high availability solution for MySQL. We will guide you in a hands-on tutorial through the setup. Bring your laptop!	Matthias Crauwels; Jakob Lorberblatt May 16, 2022 13:30 Tutorial Classroom 104 M1
Tune PostgreSQL for Read/Write Scalability PostgreSQL is one of the leading open-source databases. Out of the box, the default PostgreSQL configuration is not tuned for any particular workload. Nowadays, production systems have quite expensive machines, which require extra configuration. PostgreSQL provides configuration parameters to configure it accordingly. Most of the time, people configure PostgreSQL according to hardware and don’t consider the workload and type of queries. In all these three cases, there’s a different set of configurations. In this talk, users will see how to configure PostgreSQL for a Read/Write intensive load. This talk will explain every important configuration parameter with real-time examples.	Ibrar Ahmad; Naeem Akhtar May 16, 2022 13:30 Tutorial Classroom 105 M1
Open Source Database Performance Optimization and Monitoring With PMM This is a hands-on tutorial covering how to set up monitoring for MySQL database servers using the Percona Monitoring and Management (PMM) platform. PMM is an open source database observability, monitoring, and management solution. It allows database users to observe the health of their systems, explore new patterns in database behavior, quickly troubleshoot issues, and perform database management operations no matter where they are located - on-prem or in the cloud. You will learn about: Installation and configuration of PMM Identifying and analyzing problematic queries via Query Analytics Send Alerts using the Integrated Alerting feature Taking backups from your MySQL and MongoDB instances	Michael Coburn Principal Architect Percona May 16, 2022 13:30 Tutorial Classroom 106 M1
Percona Platform Hands-on This hands-on lab is designed to give attendees a full demo of the Percona Platform for each of its supported technologies. Attendees will set up their own Percona Monitoring and Management instance, link it to Percona's open source database distributions, observe metrics, and utilize management functionality of PMM. Upon completion, attendees will understand the benefits and all components of the Percona Platform.	Barrett Chambers; Kyle Avants May 16, 2022 13:30 Tutorial Salon 1 Zlotnik L
Let it Go! (Golang for DBAs) Go is the new Python. The Go programming language was designed with concurrency in mind but is also easy to learn. And it has powerful libraries that provide basic MySQL database access and advanced features. These characteristics make Go the ideal language for database administrators that need to perform basic and complex tasks at scale. In this session, we will cover: Basics of Go: syntax and grammar. Concurrency: Goroutines and channels. The database/SQL library. The Go MySQL Driver. The Go-MySQL library: A library to handle MySQL network protocol and replication.	Pep Pla Consultant Percona May 16, 2022 13:30 Tutorial Salon 2 Zlotnik L
State of MariaDB State of MariaDB	Michael Widenius Founder of MySQL May 18, 2022 09:30 MongoDB 1 Classroom 201 M2
Deploying MongoDB Sharded Clusters Easily With Terraform and Ansible Installing big clusters can be a time-consuming task. In this talk, we will see how to develop a complete pipeline to deploy MongoDB sharded clusters. By combining Terraform for the hardware provisioning and Ansible for the software installation, we can save time and provide a standardized reusable solution.	Ivan Groenewold Architect Percona May 18, 2022 10:50 MongoDB 1 Classroom 201 M2
MongoDB Version Upgrades – Recommendations, Procedures, Paths, and Warnings MongoDB began a new release cadence last July 2021 with MongoDB v5.0 that included many changes to internals, the core server, and the WiredTiger engine to facilitate exciting new features including time series collections, live resharding, and API versioning. Many of the features included in v5.0 were backported to the 4.4 release causing parts of the branch to break with bugs, such as carrying warnings of “not recommended for production use due to critical issues”. This session covers Percona’s recommended upgrade paths and tactics to get you safely to a supported version (4.2, 4.4, and 5.0).	Kimberly Wilkins NoSQL Tech lead - MongoDB Percona May 18, 2022 11:50 MongoDB 1 Classroom 201 M2
Take Your Percona Server for MongoDB to the Next Level As organizations grow their MongoDB datasets from a few terabytes to hundreds of terabytes, they will encounter performance and Quality of Service (QoS) challenges. This results in costly architectural changes for infrastructure and software. Avoid migrating to expensive MongoDB Enterprise License edition by leveraging Percona Distribution for MongoDB with Pliops Extreme Data Processor (XDP). This delivers a no-compromise solution for enterprise security, performance, and QoS while meeting the capacity needs. In this session, we will cover all aspects of Percona Distribution for MongoDB plus Pliops XDP advantages over the Enterprise Edition for economically scaling capacity needs with best-in-class data protection.	Prasad Venkatachar Sr Director - Solutions -Technical Marketing Pliops May 17, 2022 17:00 MongoDB 1 Classroom 201 M2
MongoDB Magical Live Resharding – Considerations and Concerns One of the biggest pains with MongoDB has been handling problems caused by picking bad shard keys when sharding to scale out horizontally as your application needs and data size grow. Suboptimal shard keys cause performance problems relating to disk imbalance, disk I/O, and issues with CPU and memory. MongoDB first addressed this with refinable shard keys in v4.4 and now with live resharding in v5.0. This highly requested feature took time, effort, changes to the core server and WiredTiger engine. However, it is not all magic and healthy bunnies coming out of the hat. Let’s take a deeper look.	Kimberly Wilkins NoSQL Tech lead - MongoDB Percona May 18, 2022 14:00 MongoDB 1 Classroom 201 M2
Change Streams Don't Work Change streams were introduced in MongoDB 3.6 and are being used by many developers to implement simple queuing messaging solutions. I will detail how MongoDB change streams work, provide use cases where it may or may not be used, and go over the last code changes we have in the recent versions (4.4, 5.0).	Arlindo Neto MongoDB DBA Percona May 18, 2022 15:00 MongoDB 1 Classroom 201 M2
ProxySQL and the Tricks Up Its Sleeve: Ideas on How to Manage Your Database Systems ProxySQL is well-affirmed into thousands of production environments for the features we all know: multiplexing, query routing, and rewriting to name a few. Let's go through those use cases which maybe are the least common: from keeping malicious eyes away from your production data to rebuilding your non-production environment, from stopping having hanging transactions to safely speed up logical backups in RDS, from query firewalling to changing ProxySQL configuration without a single line of SQL! When the sky is the limit, ProxySQL gives you some boost!	Jesmar Cannao COO ProxySQL LLC May 18, 2022 09:30 Partner Classroom 202 M2
Galera Cluster State of the Union Galera Cluster has come a long way in its 15 years of existence, and it continues to have thousands of satisfied users in production. It is still the primary virtually synchronous replication solution for MySQL and MariaDB Server. In this session, learn about the new features in Galera 4, how we have optimized the protocol for wide area networks, how we can now handle large transactions with streaming replication, and how we’ve extended the MySQL system tables for monitoring purposes. We’ve also added some synchronization functions and continue to improve on things like foreign key handling in every release.	Seppo Jaakola CEO Codership (galera cluster) May 18, 2022 10:50 Partner Classroom 202 M2
Git for Databases: How to Version and Collaborate on Databases with Liquibase Liquibase is the defacto standard for versioning your database schema. With 15 years of use by the largest enterprises, Liquibase is a proven Open Source DevOps Solution. Now, with Liquibase Data, users can apply git-like workflows to development and test environments. See how free Open Source Liquibase can accelerate database development and cross-team deployments.	Robert Reeves CTO Liquibase May 18, 2022 11:50 Partner Classroom 202 M2
Zero Trust Database Access Using OpenZiti and JDBC Securing your database is incredibly important and easy to get wrong. We can't go a week without hearing about another database leak. What if we could access these databases using strong identities and zero-trust principles? That's exactly what you can do quickly and easily using OpenZiti's zero trust JDBC. Not only can you add the OpenZiti JDBC directly to your app for zero-trust access, but you can also add it to your favorite SQL editors and access the DB over a zero-trust overlay network with no VPN. Who wants to turn on the VPN just to run a query?	Marcos Schejtman Solution Architect NetFoundry May 18, 2022 14:00 Partner Classroom 202 M2
Overcome Blast Radius Anxiety With Ultrafast Rebuilds and Performance for High-capacity SSDs Organizations looking to address surging data storage requirements with high capacity 32TB+ SSDs are challenged by blast radius concerns. Data protection with RAID 10 uses excessive redundancy in array mirroring, wasting significant capacity, while RAID 5/6 schemes penalize storage performance. All existing technologies have extensive rebuild times that are beyond acceptable risk levels. Pliops Extreme Data Processor using new data structures and algorithms change these dynamics to increase storage reliability with higher endurance, ultrafast rebuilds, and consistent performance. The presentation discusses how to enable these capabilities, including demonstrating how quickly a high-capacity SSD can rebuild with minimal impact on performance.	Prasad Venkatachar Sr Director - Solutions -Technical Marketing Pliops May 18, 2022 15:00 Partner Classroom 202 M2
PostgreSQL High Availability: The Considerations and the Candidates Almost every organization that I interact with wants a high availability system for PostgreSQL. This clearly depicts an active trend toward an increase in utilizing PostgreSQL for critical business applications. In some cases, it is a move away from other major database systems like Oracle or even Teradata. We are going to define the basic criteria for a high availability system, and have a quick glance at the current open source solutions available in the market.	Hamid Akhtar Senior Software Engineer Percona May 18, 2022 09:30 PostgreSQL 1 Classroom 203 M2
Introduction to Serverless Databases for MySQL and PostgreSQL Amazon Aurora Serverless brings automatic scaling to MySQL and PostgreSQL, allowing applications to instantly scale to hundreds of thousands of transactions in a fraction of a second. This session will dive into the Aurora architecture that allows this to happen. Additional topics include real-world use cases of how serverless has not only helped organizations to scale but to control costs by only paying for the database resources that are needed.	Krishna Sarabu; Raj Jayakrishnan May 18, 2022 10:50 PostgreSQL 1 Classroom 203 M2
Avoid PostgreSQL LWLock:buffer_content locks in Amazon Aurora: Tips and best practices We have seen PostgreSQL customers facing buffer_content locks caused by contention of data in high concurrency or large datasets(96vCPUs, 768GiB with 30TB). We provide a benchmark and share tips with a real-world workload that leads to buffer_lock contentions. We then propose the patterns to minimize the chance for buffer_content locks.	Yahav Biran; Sami Imseih May 18, 2022 11:50 PostgreSQL 1 Classroom 203 M2
Building Fast ClickHouse Analytics for MySQL Transaction Data Using Kubernetes MySQL servers routinely process hundreds of thousands of transactions per second on busy web properties. Analyzing those transactions is a different matter: For that, you need an analytic database like ClickHouse with column storage, efficient data compression, and parallel query. In this talk, we'll show how to set up a Kubernetes-based analytic service based on Debezium, Kafka, and ClickHouse. We'll discuss management options for each component, and also discuss options to represent transactional data in ClickHouse. All components are open source and the pipeline can run on any Kubernetes implementation.	Robert Hodges; Kanthi Subramanian May 17, 2022 11:30 Partner Classroom 202 M2
Common Possible Preventative Measures To Avoid Locking Issue in PostgreSQL In our day-to-day tasks, we encountered locking issues in the PostgreSQL database. To avoid locking issues, we have some best practices and possible preventative measures. It also adds a positive impact on the overall performance of the database.	Naveed Shaikh PostgreSQL DBA II Percona May 18, 2022 14:00 PostgreSQL 1 Classroom 203 M2
Best Practices for MySQL High Availability in 2022 The MySQL world is full of trade-offs, and choosing a High Availability (HA) solution is no exception. This session aims to look at all of the alternatives in an unbiased nature. Preference is, of course, only given to open source solutions. While the landscape will be covered, including but not limited to replication, the focus of the talk will be what is recommended for today, and what to look out for. Thus, this will include deep-dive coverage of ProxySQL and MySQL InnoDB Cluster in 8.0, and Galera Cluster variants like Percona XtraDB Cluster and MariaDB Galera Cluster.	Colin Charles Consultant codership (galera cluster) May 18, 2022 09:30 MySQL Classroom 105 M1
MySQL Failover for Asynchronous replication with Orchestrator, ProxySQL and Consul I would like to present on how the failover works along with orchestrator and ProxySQL. How the orchestrator hook is responsible to update the required changes in ProxySQL without any manual intervention.	Yunus Shaikh Mysql DBA II Percona May 18, 2022 10:50 MySQL Classroom 105 M1
Building Database Using Terraform in AWS for Maximal Isolation Usability In this session, we will cover: Separating DB accounts Using PrivateLink for both EC2 and RDS based systems Planning your Route53 design Planning SGs Using SessionManager to avoid VPN's and Bastions	David Murphy Amach.ie May 18, 2022 11:50 MySQL Classroom 105 M1
Venmo's Experiences With Aurora Failovers Using ProxySQL Venmo's Aurora database clusters are the centerpiece of its success. As a follow up to our 2021 talk Venmo's Aurora Upgrades With Open Source Tools, we dive deeper into the failover aspect of running Aurora at scale and achieving virtually no downtime switchover/rollback. We will discuss: Our motivations for choosing ProxySQL, Our Infrastructure as Code implementation for ProxySQL Our recipes for a painless failover 3 Ps of a successful failover - People, Process and Product What went well for us and what could go better. We hope sharing our experiences will enrich yours.	Kushal Shah; Yashada Jadhav May 18, 2022 14:00 MySQL Classroom 105 M1
ProxySQL Cluster: Challenges and Solutions To Synchronize Configuration Across Multiple Decentralized Cluster Nodes As a reverse proxy for MySQL databases, ProxySQL is being used in various infrastructure sizes, and it is not surprising to see deployments with thousands of nodes running. Such large deployments introduce some interesting challenges because nodes can be initialized or destroyed at any time. This session will describe the challenges in configuring such large deployments of nodes, the most common external tools to configure ProxySQL, and then focus on improved ProxySQL native clustering solutions that allow auto-discovery, bootstrap, and a distributed decentralized reconfiguration.	Rene Cannao CEO ProxySQL LLC May 18, 2022 15:00 MySQL Classroom 105 M1
MySQL in the Cloud: DBaaS vs Kubernetes Applications in the cloud on Kubernetes are very common these days. Most of the time, they need a database (like MySQL). There are two often considered alternatives: 1. Use DBaaS - for example, Google CloudSQL for MySQL 2. Deploy the database on Kubernetes with the application We'll compare those approaches from different angles to clarify differences. You'll be better equipped to decide how to run MySQL for your cloud-native application. We'll focus on Google CloudSQL and Percona Distribution for MySQL Operator on Google Kubernetes Engine (GKE). Still, most of the knowledge is universal across cloud platforms and DBaaS solutions.	Michal Nosek Enterprise Architect Percona May 18, 2022 09:30 Percona Classroom 106 M1
External Authentication 101 With Percona Server for MySQL, MongoDB and PostgreSQL and PMM As a support engineer in Percona, we've come across tickets that deal with integrating Percona Server and Percona Monitoring and Management (PMM) with external authentication backends such as OpenLDAP, Windows AD, Centrify, Auth0, and recently, Okta. In support, we do not have access to some of these products so we need to be creative on how to troubleshoot these. I will share my experience in setting up and troubleshooting: 1. Sandbox for external authentication with Samba AD and OpenLDAP with Vagrant/Ansible 2. External authentication with Percona Server for MySQL, MongoDB and PostgreSQL 3. LDAP, Auth0 and Okta integration with PMM	Jaime Sicam Senior Support Engineer Percona May 18, 2022 10:50 Percona Classroom 106 M1
High Availability and Disaster Recovery Made Easy With MySQL InnoDB ClusterSet The InnoDB Cluster is a great HA solution that often is deployed alongside asynchronous replication to achieve a multi-datacenter Disaster Recovery. With 8.0.27 MySQL shell, this was greatly simplified with the release of MySQL InnoDB ClusterSet. In this session, we will look at the MySQL InnoDB ClusterSet and how it can simplify managing the MySQL InnoDB Cluster disaster recovery. We will walk through the process of setting it up, managing multiple clusters, and how to perform a switchover/failover. Lastly, we will discuss its use cases and limitations.	Leonardo Bacchi Fernandes Support Engineer Percona May 18, 2022 11:50 Percona Classroom 106 M1
How ZNS SSD's Are Changing the Landscape There is a new technology emerging in the world of storage called ZNS. Find out how it's been integrated into applications you are currently using or potentially could use, and where the ecosystem is headed.	Rick Vasquez Senior Director - Strategic Initiatives Western Digital May 17, 2022 13:30 Partner Classroom 202 M2
Extending Percona Monitoring and Management With Custom Collectors In this session, we'll review how you can make the most out of the extensibility of PMM's custom data collectors. Be it with queries running directly in the monitored databases, or with external scripts that can gather OS-related data, PMM is all about power and freedom to implement things yourself! Additionally, we'll review how to integrate the newly collected data within PMM's native dashboards, and discuss the caveats and limitations behind this approach.	Agustin Gallego Senior Support Engineer Percona May 18, 2022 14:00 Percona Classroom 106 M1
Scaling One of the Largest On-prem Managed MySQL Fleets in India In this session, we'll cover how Flipkart (India's largest e-commerce company) has built and scaled one of the largest on-prem managed MySQL fleets in India (600 clusters over 1600 VMs, with a footprint of about 1000TB). I'll cover the entire journey of this platform, the problems it has solved, the features being provided, the overall architecture, and finally, the future of this product.	Vaidyanathan Subramanian Engineering Manager Flipkart May 18, 2022 09:30 MySQL 2 Classroom 104 M1
MySQL Cookbook: Recipes for Your Business MySQL Cookbook 4th edition is planned to be released this spring. I am one of the authors of the book and will show you how to "cook" MySQL. I will show you a few tasks with different priorities, such as JSON in MySQL for those who need flexibility; modern SQL for analytics, and Group Replication for high availability. I will also show how to write programs using JavaScript and Python languages, X DevAPI, and MySQL Shell. I expect this talk will be interesting for MySQL application developers.	Sveta Smirnova Principal Support Engineering Coordinator Percona May 18, 2022 10:50 MySQL 2 Classroom 104 M1
MySQL 8.0 at 4. Where are we now? This is to discuss how things have evolved with our use of MySQL 8.0 and where we stand now. - some discussion of things over COVID downscaling - moving everything to 8.0. Why it's hard to get all systems up to date and how to achieve that - automation-related changes we saw - new features that have been incrementally released - our view on them - stability of 8.0 - overall thoughts on where MySQL should/could go from here	Simon Mudd Senior Site Reliability Engineer (Databases) Booking.com May 18, 2022 11:50 MySQL 2 Classroom 104 M1
Migrating Meta to MySQL 8.0 MySQL powers some of Facebook’s most important workloads. We actively develop new features in MySQL to support our evolving requirements which change many different areas of MySQL, including client connectors, storage engine, optimizer, and replication. Each new major version of MySQL requires significant time and effort to migrate our workloads. The challenges include: porting our custom features, minimizing changes needed for application queries, and fixing performance regressions. In this talk, we will share our story about how we went about achieving the migration from 5.6 → 8.0 for our workloads at Meta.	Pradeep Nayak; Herman Lee May 18, 2022 15:00 MySQL 2 Classroom 104 M1
Cleaning the Room - Everything You Need To Know About Vacuum Vacuum is a very important but largely misunderstood topic in Postgres world, but we will change it now! We will dive deep into the Postgres storage system and its multi-version model (MVCC) during this presentation to give us the needed base to understand what is and why we need Vacuum. We will then discuss the Vacuum, its implementation, what it does, how it does its job, and also the Autovacuum, the automated keeper that is in charge keeping everything clean and tidy, as well as the settings related to it and how it can influence performance (for good or for bad).	Charly Batista PostgreSQL Tech Lead Percona May 18, 2022 15:00 PostgreSQL 2 Salon 2 Zlotnik L
Advanced Data Types in PostgreSQL The “Tour de Data Types” talk provided an overview of the rich set of basic data types in PostgreSQL. But there are more data types available, which can and should be used in applications. PostgreSQL also allows you to combine simple types into more complex structures, or create your very own data type. This talk starts with ENUM types, and how to create and use them. From there we will discover Arrays and Composite types, look into Range types and finally learn how you can create your own data type.	Andreas Scherbaum Head of Databases Adjust GmbH May 18, 2022 10:50 PostgreSQL 2 Salon 2 Zlotnik L
PostgreSQL Query Performance Insights Understanding query performance patterns are essentially the foundation for query performance tuning. It, in many ways, dictates how a database cluster evolves. And then there are direct and indirect cost connotations as well. With improved observability, using the right tools, you can get the best out of your existing setup and ensure that it is able to handle not only the average load profile but peak load as well. We'll see how different tools like pg_stat_activity, pg_stat_statements, auto_explain, pgBadger, and pg_stat_monitor can deliver a complete picture to help measure, analyze and optimize your queries and database system.	Hamid Akhtar Senior Software Engineer Percona May 18, 2022 11:50 PostgreSQL 2 Salon 2 Zlotnik L
Evaluating PostgreSQL Compatibility in Distributed SQL Databases Google Spanner announced support for PostgreSQL, validating the importance of such compatibility. But many distributed SQL databases have taken radically different approaches. This has major implications for developers. We will examine the degree of compatibility across four databases: Google Spanner, Amazon Aurora, CockroachDB, and YugabyteDB.	Denis Magda Head of Developer Relations Yugabyte May 18, 2022 14:00 PostgreSQL 2 Salon 2 Zlotnik L
The Paradigm Shift - Understanding the Move To Distributed Databases Databases still face one monumental challenge. Despite all the features, all of the capabilities, and advanced data parsing, the modern SQL RDBMS maintains data integrity by storing data in a single controlled location. Distributed databases break that barrier. Using the consensus technology that underpins blockchain, an emerging group of databases - like PingCAP TiDB, Cockroach DB, and YugabyteDB - are bringing SQL compliant distributed data storage to the general cloud. We will discuss the underlying technologies that enable distributed databases, the current state of the technology, and cover some of the considerations for current and future development projects.	Liquan Pei Sr Software Engineer PingCAP May 17, 2022 14:30 Partner Classroom 202 M2
A Deep Dive Into PostgreSQL Indexing Indexes are a fundamental feature of relational databases, and PostgreSQL offers developers and designers a rich collection of options. To take advantage of these entirely, users need to understand the basic concept of indexes to compare the different index types and apply them to different application scenarios. Only then can you make an informed decision about your database index strategy and design. One thing is for sure: Not all indexes are appropriate for all circumstances, and using a ‘wrong’ index can have the opposite effect to what you intend. Armed with more advanced knowledge, you can avoid this worst-case scenario!	Ibrar Ahmad Sr. Software Architect Percona May 18, 2022 15:00 PostgreSQL 2 Salon 2 Zlotnik L
Going the distance In every DBA's life, there is a point where data needs to be copied over great distances. This can be the other coast, or it can be another continent. It can be because of implementing a disaster recovery system, it can be because distant read replicas are needed for the application. In this talk, we use examples with MySQL and xtrabackup to discuss the issues of long-distance copies and the potential performance tuning opportunities. In this talk, we will: Examine the characteristics of transferring a large amount of data over WAN links. Discuss compression and encryption options. Check out options for copying an already existing backup. Check out options for streaming backups.	Peter Boros Principal Architect Percona May 16, 2022 09:00 Database 101 for Developers Classroom 201 M2
Congratulations! You're Also the DBA! Are you an accidental DBA? Suddenly find out that, in addition to your other duties, you have to keep the database humming along too? Well, this is the session for you! In this talk, you'll learn the five things you HAVE TO DO to keep a database happy and healthy. Even if your enterprise needs a DBA only five minutes a week, there are certainly some things that you need to know before tackling a database task to keep data safe.	David Stokes Technology Evangelist Percona May 16, 2022 09:45 Database 101 for Developers Classroom 201 M2
A Survey of MySQL Indexes Types Adding an index to a table is a popular way to try and speed up queries. But MySQL has several types of indexes and many options. Which is best for your need? Do you need to ignore indexes for hash joins? Can functional indexes help the optimizer plan for a better query? And how do you test an index's effectiveness? This session will detail what you need to know to configure the best possible index for the needs of your applications in a simple and concise fashion.	David Stokes Technology Evangelist Percona May 16, 2022 13:30 Database 101 for Developers Classroom 201 M2
Percona Monitoring and Management (PMM) for Novices Percona Monitoring and Management (PMM) is an open source database observability, monitoring, and management tool for MySQL, PostgreSQL, and MongoDB that simplify operations, optimize performance, and improve the security of your database services. This session will cover the installation of PMM, how to register your databases with it, and how to use PMM to make your life simpler. This session with start at zero and make you a hero at monitoring your MySQL, PostgreSQL, and MongoDB databases.	David Stokes Technology Evangelist Percona May 16, 2022 14:15 Database 101 for Developers Classroom 201 M2
How To Ease Major MySQL Upgrades! For a variety of reasons, including new features, performance benefits, bug fixes, and so on, it is essential to upgrade MySQL to the most recent version. Databases with obsolete versions are vulnerable. Major version upgrades, on the other hand, can be problematic if they haven't been well tested with your application, as the procedure may break it, render it inoperable, or cause performance issues. The goal of this talk is to go over the details of how to make major MySQL upgrades easier!	Arunjith Aravindan; Alison Savage May 16, 2022 15:00 Database 101 for Developers Classroom 201 M2
Optimizing MySQL for I/O Best practices for tuning MySQL and Linux in regards to I/O subsystem and analysis of I/O throughput.	Taras Onishchuk MySQL DBA Percona May 16, 2022 09:00 Advanced Database Topics Classroom 202 M2
Troubleshooting MySQL From a MySQL Developer Perspective Working as a MySQL Developer as part of the Bugs committee exposes you to a variety of bugs, such as server crashes, memory leaks, wrong query results, internal thread deadlocks, and others. In this talk, I will cover some of the technics we utilize to troubleshoot MySQL when things are not working as expected. Some of the topics covered include: Reproducible test cases Git Bisect Stack Traces GDB Record and Replay By the end of this session, attendees will grasp how to tackle analyses of when software is not working as expected.	Marcelo Altmann MySQL Software Developer Percona May 16, 2022 09:45 Advanced Database Topics Classroom 202 M2