Percona Live Online has ended

Create Your Own Event

Percona Live Online

Welcome to Percona Live Online 2021
Online Open Source Database Conference
REGISTER HERE!

06:00 EDT

Performance Comparison of MySQL and PostgreSQL Based on Kernel Level Analysis [30Min]

In this talk the author will show the results of performance comparison between MySQL and PostgreSQL using well known benchmarks such as sysbench and tpcc, and analyze the causes of such differences in terms of the database kernel design and key algorithms of the two competitors, in their kernel modules and functionality including transaction management, access methods, query processing, among others.

Following that, the author will show why the Kunlun distributed DBMS can combine the strengths of MySQL and PostgreSQL and avoid their weaknesses to achieve outstanding performance.

Speakers

David Zhao

database systems expert, zettadb

Zhao Wei (David Zhao) has been working on database kernels throughout his career. He worked on Oracle Berkeley DB and MySQL in the two outstanding global teams in Oracle during 2007 and 2015, and he worked in Tencent to upgrade its TDSQL from a table sharding solution to a full-fledged... Read More →

Wednesday May 12, 2021 06:00 - 06:30 EDT
Room #1

MySQL, All Databases

07:00 EDT

Pandemic - A Tale of 25x Growth in Three Weeks [30min]

Edmodo is an educational website that takes the ideas of a social network and refines them and makes it appropriate for a classroom. Our traditional peak period happens during the Back to School when students - and teachers - realize they have to go back to the classrooms and suddenly rush to the site to prepare their online alias to the school year.

Last year was different and it happened quickly and without too much warning in March when people were suddenly sent home from the schools to do all their tasks completely remotely.

That's how our adventure started and this is when the site started doubling its traffic on a daily basis depending how many countries went into lockdown on that given day. The traffic on the dbs went up from 200K QPS to 5 million within a course of 3 week, we hit several limitations when scaling our dbs, sometimes we had no other choice but to make risky decisions but the site stayed up and running.

Please join me on this retroactive journey.

Speakers

Natarajan Chidhambharam

MySQL DBA, Edmodo

Natarajan Chidhambharam is an infrastructure engineer at Edmodo with focus on database scalability and reliability. Relational databases, db infrastructure solutions for large scale websites are his main working interests. Edmodo successfully handled 25x db trac growth during the... Read More →

Miklos Szel

Senior MySQL Architect, Edmodo

Miklos Mukka Szel is a Senior DB Architect at Edmodo. With more than 20 years’ experience in system and network administration, he has also worked for Walt Disney International as its main International MySQL DBA. Miklos specializes in MySQL-based high availability solutions, performance... Read More →

Wednesday May 12, 2021 07:00 - 07:30 EDT
Room #3

MySQL, All Databases

08:00 EDT

Revertible, Recoverable Schema Migrations in Vitess

Recent developments in Vitess take online schema migrations to a new level, allowing us to think of DDLs as little more than a transaction, giving both developers and DBAs new super powers and peace of mind.

- Have you ever completed a schema migration only to realize a column should not have been dropped, an index should not have changed?
- Have you ever dropped a table only to find it was a big mistake?
- Have you ever waited a week for a schema migration, only to see it go down the drain due to a failover? Or have you postponed important maintenance work due to a running migration?

Vitess online schema migrations now utilize _VReplication_, a core component in Vitess that empowers Vitess’s live resharding, materialized views, live imports, and more.

In this session we present VReplication and illustrate how it works. We follow up to explain how online schema changes employ VReplication for both revertible, and recoverable, lossless schema migrations. We will discuss some of the internal logic, and present a demo of these new super powers.

Vitess is a CNCF open source database clustering system for horizontal scaling of MySQL.

Speakers

Shlomi Noach

Engineer, PlanetScale

Engineer and database geek, works at PlanetScale as a maintainer for open source Vitess. Previously at GitHub. Interested in database infrastructure solutions such as high availability, reliability, enablement, automation and testing. Shlomi is an active MySQL community member, authors... Read More →

Wednesday May 12, 2021 08:00 - 08:30 EDT
Room #1

MySQL, All Databases

08:30 EDT

Creating MySQL User-Defined Functions in C++ Has Never Been Easier

In this session I will show how to use **C++ UDF wrappers** from Percona Server 8.0.22+ to add new custom functionality to MySQL.
Forget about *funcinit()* / *func()* / *funcdeinit()* functions, individually defined context structures for passing data between them, manual memory allocations and ugly casts from *void* * to extract function parameter values - now you have nice **c++14** wrappers to do all the dirty work behind the scene with minimal overhead.

Speakers

Yura Sorokin

Principal Software Engineer, Percona

Yura is a Principal Software Engineer at Percona, mostly working on Percona Server Core. He is the primary developer who implemented "Compressed Columns with Dictionaries" and "SEQUENCE_TABLE()". Before joining in July 2015 he was leading a cloud file service backend dev team which... Read More →

Wednesday May 12, 2021 08:30 - 09:00 EDT
Room #1

MySQL, All Databases

09:00 EDT

Scaling MySQL @LinkedIn with Vitess

MySQL serves as the datastore for many of the important internal tools at LinkedIn. A typical MySQL cluster at LinkedIn has 1 primary and 2 replicas for read-scaling and High Availability. To scale the reads for all these tools, more replicas are added to the cluster. But, what about write-scaling which still goes to a single primary?

We started looking for an answer to this question about a year and a half ago when one of the tools ramped up quickly and was struggling due to writes. When we decided sharding as the solution to this, there was a choice between writing the sharding logic in the application itself or choosing Vitess.

Vitess stood out for us. Although we had to tweak the schema design, there were minimal changes to the application code as it supports almost all the SQL queries and connection pooling.

This talk will be focused about our journey with Vitess. We will take the attendees through the ‘Why’ of our journey, why we chose Vitess and not any other sharding method; how we migrated the platform real time and what tremendous metrics we achieved post successful migration.

The talk will consist of:-
- Introduction
- Why Vitess?
- Brief Introduction to Vitess
- Challenges while moving to Vitess
- What it looks like at the Infra-level
- Key Achievements

Along with talking about our journey with Vitess, we will touch base upon what is next for Vitess@LinkedIn.

Key Takeaways
- Vitess as a sharding solution to MySQL
- Insights from our learnings

Speakers

Apoorv Purohit

SRE, LinkedIn

I started my career as an application developer in 2016 handling C++ telephony module and report generation from MySQL. With my growing interest in databases, I switched to become a full time database engineer in 2017 at OneDirect. I was a part of the team that handled the entire... Read More →

Karthik Appigatla

Staff SRE, LinkedIn

Karthik Appigatla has been working on various large scale data stores for a decade primarily focused on MySQL. Currently, he has been working for LinkedIn for the last 5 years. Prior to LinkedIn, he worked for Yahoo, Pythian and Percona where he was responsible for helping clients... Read More →

Wednesday May 12, 2021 09:00 - 09:30 EDT
Room #6

MySQL, All Databases

09:30 EDT

MySQL Performance for DevOps

MySQL performance can be improved by tuning queries, server options, and hardware. Traditionally it was an area of responsibility of three different roles: Development, DBA and System Administrators. Now DevOps handle these all. But there is a gap. Knowledge, gained by MySQL DBAs after years of focus on the single product is hard to gain when you focus on more than one. This is why I am doing this session. I will show minimal, but the most effective, set of options which will improve MySQL performance. For illustrations, I will use real user stories, gained by my Support experience, and Percona Kubernetes operator for PXC.

Speakers

Sveta Smirnova

Principal Support Engineering Coordinator, Percona

Sveta Smirnova is a MySQL Support Engineer with over 10 years of experience. She currently works in Percona. Her main professional interests are problem-solving, working with tricky issues, bugs, finding patterns that can solve typical issues quicker, teaching others how to deal with... Read More →

Wednesday May 12, 2021 09:30 - 10:30 EDT
Room #1

MySQL, All Databases

10:00 EDT

Flexible Data Transfer, Uldra-Replicator

Uldra-Replicator is a binlog parser, that was first started to do streaming processing while reading data to solve complex requirements.
In this session, I'll explain how to transfer data flexibly using binary log. Unlike the existing CDC, various requirements can be handled on a DB event basis, and I will explain this on a case-by-case basis. I want to share ideas that can efficiently handle flowing data and solve complex requirements in a fun way.

The following subjects will be covered:

• Binary log description and structure
• Data transfer technique and limitation
• Uldra-Replicator concepts
- Easy operation
- Performance
- Consistency
- Transaction
• Use case
- Data transfer to Shard DB in real time
- Merge or separate data for delivery
- Change contents while passing data

I'll open my source code, I personally implemented in the Git project, and show the test result based on it.

Speakers

Dongchan Sung

MySQL DBA, KakaoBank

Dongchan is DBA at KakaoBank, the Korean internet bank. He is very interested in data efficient processing and automation. His final goal is building unbreakable data system. He is interested in all elements (monitoring, automation) for a stable system configuration.

Wednesday May 12, 2021 10:00 - 10:30 EDT
Room #5

MySQL, All Databases

10:00 EDT

Comparing High Available Solutions With Percona XtraDB Cluster and Percona Server With Group Replication.

Percona XtraDB Cluster (PXC) is currently the most popular solution for HA in the MySQL ecosystem, and any solutions Galera-based as PXC have been the only viable option when looking for a high grade of HA using synchronous replication.

But Oracle had intensively worked on making Group Replication more solid and easy to use.

It is time to identify if Group Replication and attached solutions, like InnoDB cluster, can compete or even replace solutions based on Galera.

This presentation will focus on comparing the two solutions and how they behave when serving basic HA problems.

Attendees will be able to get a clearer understanding of which solutions will serve them better, and in which cases.

Speakers

MarcoTusa

Technical Leader MySQL, Percona

Marco Tusa had his own international practice for the past twenty-eight years. His experience and expertise are in a wide variety of information technology and information management fields, covering research, development, analysis, quality control, project management and team management... Read More →

Wednesday May 12, 2021 10:00 - 11:00 EDT
Room #1

MySQL, All Databases

11:00 EDT

Monitoring and Tracing MySQL or MariaDB Server With Bpftrace

Bpftrace is a relatively new eBPF-based open source tracer for modern Linux versions (kernels 5.x.y) that is useful for analyzing production performance problems and troubleshooting software. Basic usage of the tool, as well as bpftrace-based one liners and small scripts useful for MySQL, MariaDB, Percona Server or any open source DBAs (and even developers) are presented. Problems of MySQL server dynamic tracing with bpftrace are discussed.

Speakers

Valerii Kravchuk

Principal Support Engineer, MariaDB Corporation

Valerii Kravchuk helps MySQL and MariaDB users and DBAs to resolve their problems since 2005. Worked in MySQL AB, Sun, Oracle, Percona and, since 2016, in MariaDB Corporation. MySQL Community Contributor of the year 2019.

Wednesday May 12, 2021 11:00 - 12:00 EDT
Room #1

MySQL, All Databases

13:00 EDT

Using Percona Audit Plugin in Daily Operation

Log audits have for some become very important for various reasons. Perhaps you need to provide documentation for who had access to your database, perhaps you need to investigate a data breach. Many other scenarios may apply, and for this purpose Percona provides a plugin for MySQL for providing just that!
In this session we'll have a look at how to enable the audit plugin, how to configure it, and - most importantly - collect the logs and import them to a ClickHouse database for storage and analysis. And we'll have a look at some of the possibilities this provides.

Speakers

Lenny Andersen

DBA, Norlys

I have been using MySQL since 2003 and have been a MySQL DBA since 2013 with a constant focus on security and performance.

Wednesday May 12, 2021 13:00 - 13:30 EDT
Room #1

MySQL, All Databases

14:00 EDT

Change Data Capture (CDC) on Top of Statement-Based Replication (SBR)

Yes, that's right, here at Box, we were able to successfully create a Change Data Capture stream on top of Statement-based Replication. Although normally impossible, some quirks in our data access layer coupled with some unique usages of MySQL query comments, PGTID and Kafka have enabled us to successfully provide an at-least-once delivery event stream of changes in our sharded MySQL infrastructure. The sharded MySQL infrastructure lies at the heart of Box.com, made up of 100s of shards, 1000s of servers and billions of records. In this talk, I will take you through the implementation details as well as the challenges involved in building out our change stream.

Speakers

Venkat Morampudi

Sr. Software Engineer, Box, Inc.

Venkat Morampudi is a Sr. Software Engineer on Database & Cache Infrastructure team at Box.

Wednesday May 12, 2021 14:00 - 14:30 EDT
Room #1

MySQL, All Databases

14:30 EDT

Data Protection for Rapid Recovery at Scale

Some things can’t scale in the cloud. When you are trying to get all the performance out of your systems for SaaS and IaaS instances, RAID 0 seems like a good option. What do you do when you have 60 servers go down due to an SSD failure? In this session you will learn about new breakthrough data protection technology for SSDs that gives you better performance during a drive rebuild than you can get from RAID 0 and from a smaller footprint.

Speakers

Steve Fingerhut

President & CBO, Pliops

Steve has built multiple new technology businesses to over a billion in annual revenue. His experience includes SVP/GM Toshiba Memory America’s SSD Business Unit, VP Marketing SanDisk’s Enterprise SSD division, Co-founder and VP Marketing LSI’s Accelerated Solutions Division... Read More →

Wednesday May 12, 2021 14:30 - 15:00 EDT
Room #1

MySQL, All Databases

15:00 EDT

ARM Power! Comparing MySQL x86 vs ARM Performance

With the recent launch of Apple M1 chips and Amazon Graviton Processor, the discussion about ARM performance compared to x86 gained a lot of traction. Not only because it shows promising results in terms of performance, but when compared to the x86 instances, the costs are in general smaller.

In this talk we are going to discuss some scenarios where we compare the performance between instances that have the same cost and instances that have similar hardware capacities.

Lastly, we will check if the ARM MySQL ecosystem (backup tools, monitoring and others) is mature to support production workloads.

It is expected by the end of the session that DBAs, sysadmins and managers have a clearer idea about ARM capabilities compared to x86.

Speakers

Vinicius Grippa

Senior Support Engineer, Percona

Vinicius Grippa is a Percona Senior Support Engineer, Oracle Ace, and author of the book Learning MySQL. Vinicius has a Bachelor's degree in Computer Science and has been working with databases for 16 years. He has experience in designing databases for mission-critical applications... Read More →

Wednesday May 12, 2021 15:00 - 16:00 EDT
Room #1

MySQL, All Databases

16:00 EDT

Multi-colo Async Replication at LinkedIn

LinkedIn is a global site is served from multiple data centers (a.k.a colos). Member Data written at each data center is globally replicated to other data centers. To avoid write latency, we choose the replication to be async which has lead to a lot of problems related to conflicts. This talk is about why global replication is needed, how are we leveraging the multi-colo replication for site-up using [traffic shift](https://engineering.linkedin.com/blog/2017/05/trafficshift--load-testing-at-scale), how are we using Kafka to do multi-colo replication, how we architected our applications and the schema to minimize conflicts and finally how to handle conflicts in case if they arise.

So far LinkedIn has been using [Espresso](https://engineering.linkedin.com/espresso/introducing-espresso-linkedins-hot-new-distributed-document-store) and Oracle as primary data stores. There are already tools developed for handling the multi-colo replication which are covered in this talk. MySQL is growing very rapidly at LinkedIn and we are in search of an open source and reliable async multi-colo replication. I hope this talk may stress the need for it and let the open source community come up with good solutions.

Speakers

Karthik Appigatla

Staff SRE, LinkedIn

Karthik Appigatla has been working on various large scale data stores for a decade primarily focused on MySQL. Currently, he has been working for LinkedIn for the last 5 years. Prior to LinkedIn, he worked for Yahoo, Pythian and Percona where he was responsible for helping clients... Read More →

Wednesday May 12, 2021 16:00 - 16:30 EDT
Room #1

MySQL, All Databases

16:30 EDT

Improving Security in MySQL

MySQL is a powerful, but a very complicated beast.

In this talk we will go through the things that we can do to improve the security of MySQL by mainly covering security-related issues pertaining to MySQL by also keeping MySQL capable of performing at the very best of its ability at the same time. In this talk we will go through the security measures that you can take to secure your MySQL instances including access control (users, privileges, accounts and their security, roles), also password management, MySQL security plugins and a couple of other things - this talk will be useful for both developers and DBAs alike.

Speakers

Lukas Vileikis

Marketing Evangelist, Severalnines

Lukas is an ethical hacker, a MySQL DBA and a frequent conference speaker. Since 2014 Lukas has found and responsibly disclosed security flaws in some of the most visited websites in Lithuania and abroad including advertising, gift-buying, gaming, hosting websites as well as some... Read More →

Wednesday May 12, 2021 16:30 - 17:00 EDT
Room #1

MySQL, All Databases

17:00 EDT

Flame Graphs for MySQL DBAs

Flame graphs are a visualization of profiled software, allowing the most frequent code-paths to be identified quickly and accurately. They can be generated using Brendan Gregg's open source programs on github.com/brendangregg/FlameGraph, which create interactive SVG files to be checked in browser.

Different types of Flame Graphs (CPU, Off-CPU, Memory, Differential etc) are presented. Various tools and approaches to collect profile information of different aspects of MySQL or MariaDB server internal working are presented Several real-life use cases where Flame Graphs helped to understand and solve the problem are discussed.

Speakers

Valerii Kravchuk

Principal Support Engineer, MariaDB Corporation

Valerii Kravchuk helps MySQL and MariaDB users and DBAs to resolve their problems since 2005. Worked in MySQL AB, Sun, Oracle, Percona and, since 2016, in MariaDB Corporation. MySQL Community Contributor of the year 2019.

Wednesday May 12, 2021 17:00 - 18:00 EDT
Room #1

MySQL, All Databases

08:00 EDT

Introducing ProxyWeb - The Open Source Web Interface For ProxySQL

Introducing ProxyWeb the first Open Source ProxySQL Web User Interface. It had proven itself extremely useful during Edmodo's 25x traffic growth last march and now it's available under GPLv3. It can be installed as a docker container or as a system service in 10 seconds.

It has a responsive design, supports administering multiple ProxySQL servers, generating adhoc traffic reports, hiding unnecessary tables on a per-server basis and it comes with detailed documentation.

To make the evaluation easier it comes with a really extensive docker-compose based test environment that gives the user a fully working 'infrastructure' that consist of a MySQL cluster, ProxySQL, ProxyWeb, Orchestrator, Health Check, Sysbench.

The environment can be fully operated through a web browser after the initial start, which takes less than 45 seconds.

In the presentation the audience will be walked through the installation and the configuration of the ProxyWeb and the docker-compose based test environment will be used to set up a ProxySQL cluster from scratch. Once the setup is completed we will generate traffic with Sysbench and perform a failover with Orchestrator.

The codebase and the documentation can be accessed at http://proxyweb.org

Speakers

Miklos Szel

Senior MySQL Architect, Edmodo

Miklos Mukka Szel is a Senior DB Architect at Edmodo. With more than 20 years’ experience in system and network administration, he has also worked for Walt Disney International as its main International MySQL DBA. Miklos specializes in MySQL-based high availability solutions, performance... Read More →

Thursday May 13, 2021 08:00 - 08:30 EDT
Room #5

MySQL, All Databases

09:00 EDT

The Many Ways to Copy Your Database

Everyone needs to copy the data in their database for backups and to clone more database instances. This talk will describe and compare many ways to do this - everything from logical data dump and file copying through native cloning and backup tools to advanced scale-out techniques for large-scale copying. Whether you are using a cloud or servers in your data centres, this talk will tell you how to choose the best way to copy your database in every circumstance with performance comparisons and lessons from real-life experience.

Speakers

Nicolai Plum

Database Engineer, Booking.com

Nicolai Plum works in the Database Engineering team of Booking.com managing database product features and service design. His previous roles at Booking.com have ranged widely from Linux systems administration team lead through storage and systems architecture to regulatory compliance... Read More →

Thursday May 13, 2021 09:00 - 09:30 EDT
Room #3

MySQL, All Databases

10:00 EDT

Almost Perfect Service Discovery and Failover with ProxySQL and Orchestrator

Of course there is no such thing as perfect service discovery, and we will see why in the talk. However, the way ProxySQL is deployed in this case minimizes the risk for split-brains, and this is why I qualify it as almost perfect. But let’s step back a little...

MySQL alone is not a high availability solution. To provide resilience to primary failure, other components need to be integrated with MySQL. At MessageBird, these additional components are ProxySQL and Orchestrator. In this talk, we describe how ProxySQL is architectured to provide close to perfect Service Discovery and how this, combined with Orchestrator, allows for automatic failover. The talk presents the details of the integration of MySQL, ProxySQL and Orchestrator in Google Cloud (and it would be easy to re-implement a similar architecture at other cloud vendors or on-premises). We will also cover lessons learned for the 2 years this architecture has been in production. Come to this talk to learn more about MySQL high availability, ProxySQL and Orchestrator.

Speakers

Jean-François Gagné

System and MySQL Expert, Aiven

Jean-François is a System / Infrastructure Engineer currently working as a MySQL Open Source Developer in Aiven’s Open Source Program Office (OSPO). Before that, his missions were improving operations and scaling MySQL and MariaDB infrastructures at HubSpot, MessageBird and Booking.com... Read More →

Art van Scheppingen

Senior Database Engineer, MessageBird

Art van Scheppingen is a Senior Database Engineer at MessageBird with focus on database scalability and reliability. He's a pragmatic MySQL and Database expert with over 20 years experience in web development. He previously worked in various database architectural roles and as Senior... Read More →

Thursday May 13, 2021 10:00 - 11:00 EDT
Room #3

MySQL, All Databases

11:30 EDT

Implementing a Hybrid Column Level Encryption in MySQL

Many databases have column (or field) level encryption - a special type of encryption to protect sensitive data like credit card numbers or social security numbers. MySQL has transparent table level encryption but does not have more granular / application centric column level encyption. In this talk I will demonstrate how one can implement a column level encryption which combines an application key and a server key. This design will also require no to minimal changes to the application and provide a higher level of protection for sensitive data.

Speakers

Alexander Rubin

Sr. Database Engineer, AWS

Alexander is Sr Database Engineer at Amazon Web Services (AWS), leading RDS Red Team._x000D_ _x000D_ Alexander was working as MySQL principal consultant/architect for over 15 years, started with MySQL AB in 2006 (company behind MySQL database), Sun Microsystems, Oracle and then Percona... Read More →

Thursday May 13, 2021 11:30 - 12:00 EDT
Room #1

MySQL, All Databases

14:00 EDT

Introduction into MySQL Query Tuning for Dev[Op]s

In this talk I will show how to get started with MySQL Query Tuning. I will make a short introduction into physical table structure and demonstrate how it may influence query execution time. Then we will discuss basic query tuning instruments and techniques, mainly EXPLAIN command with its latest variations. You will learn how to understand its output and how to rewrite queries or change table structure to achieve better performance.

Speakers

Sveta Smirnova

Principal Support Engineering Coordinator, Percona

Sveta Smirnova is a MySQL Support Engineer with over 10 years of experience. She currently works in Percona. Her main professional interests are problem-solving, working with tricky issues, bugs, finding patterns that can solve typical issues quicker, teaching others how to deal with... Read More →

Thursday May 13, 2021 14:00 - 15:00 EDT
Room #2

MySQL, All Databases

15:00 EDT

Docstore - Uber’s Highly Scalable Distributed SQL Database

Uber had 93 million monthly active platform consumers in Q4 2020 and there were more than 5 billion trips on our platform in 2020 alone. No wonder we have to deal with a massive volume of data. The real-time nature of the Uber platform also imposes certain restrictions related to availability and consistency.

This is exactly why we built Docstore. Docstore is a general-purpose multi-model database that provides a strict serializability consistency model on a partition level and can scale horizontally to serve high volume workloads. It is currently in production and is serving business-critical use cases.

In this session we will be doing an in-depth study of the architecture of Docstore.

Speakers

Ovais Tariq

Senior Manager, Uber Technologies

Ovais is a Sr. Manager in the Core Storage team at Uber. He leads the Operational Storage Platform group with a focus on providing a world-class platform that powers all the critical business functions and lines of business at Uber. The platform serves tens of millions of QPS with... Read More →

Himank Chaudhary

Staff Software Engineer, Uber Technologies

Himank is the Tech Lead of Docstore at Uber. His primary focus area is building distributed databases that scale along with Uber's hyper-growth. Prior to Uber, he worked at Yahoo in the mail backend team to build a metadata store. Himank holds a master's degree in Computer Science... Read More →

Thursday May 13, 2021 15:00 - 15:30 EDT
Room #5

MySQL, All Databases