Peter Zaitsev

Learn the best practices for running Open Source Databases on Kubernetes. Explore high availability, security, backups, and disaster recovery strategies. Discover how to implement these practices with Percona Operators for MySQL, MongoDB, PostgreSQL – leading solutions for Open Source Databases on Kubernetes.

In this talk we will look into the state of MySQL Security in 2023. We will cover the new security focused features available in MySQL (and MySQL Compatible variants) as well as share best practices to consider for secure MySQL deployment.

The presentation will be focused on dealing with an unexpected high traffic event as it is happening. We will address the impact a traffic spike can have on your database – from poor query response time to replication lag issues – and provide actionable tips and tricks. We will talk about how to bring your database under control, earn performance gains and delight your customers.

In this presentation, we will look into eBPFTrace as a capable Dtrace replacement. We will also show how you can develop your own tools and utilities using eBPFTrace as well as how you can use the tools from eBPFTrace collection to get great insights into Linux Operations.

Optimizing MySQL performance and troubleshooting MySQL problems are two of the most critical and challenging tasks for MySQL DBA’s. 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. Further, DBA’s are expected to find cost-efficient means of solving these issues. In this presentation, we will demonstrate how PMM 2 enables you to solve these challenges, which is built on free and open-source software. We will look at common MySQL problems and how to fix them.

MySQL was acquired by Sun Microsystems 11 years ago, and it would be 10 years this April that Oracle acquired Sun becoming the new steward of MySQL. In parallel a number of distributions based on the original MySQL have emerged, including MariaDB and Percona. Many web-scale companies and cloud providers such as Facebook and Google have also become maintainers or contributors in this ecosystem. Join us as we dive into the thriving MySQL diaspora and learn how these open source communities compete and collaborate on the open source database database that powers the modern web.

In this presentation, we will talk about how to find queries worth optimizing, which queries can be optimized as well as the most important techniques you need to know to optimize queries in MySQL.

There are many great new features in MySQL 8.0, but how exactly can they help your applications? This session takes a practical look at MySQL 8.0 features and improvements. It looks at the bugs, issues and limitations of previous MySQL versions and how MySQL 8.0 addresses them. It will also cover what you can do with MySQL 8.0 that you couldn’t before.

We will look into the MySQL architecture options for single and multiple distributed data center systems. We will cover the old-school option of using MySQL replication, along with more modern solutions such as AWS, MySQL Group Replication and Percona XtraDB Cluster.

Open Source Relational Database or most popular Open Source NoSQL Database? We will look into the pros and cons of each.

Is sharding right for your application or should you use other scaling technologies? If you're sharding what things do you need to consider and which questions do you need to have answered?