DBdeployer, the Community Edition - Giuseppe Maxia - Percona Live ONLINE 2020
DBdeployer, an OpenSource tool that allows easy deployment of many MySQL/Percona servers in the same host, has passed two years of development. Its latest additions have aimed at improving ease of use for both beginners and experts.
This talk will show how to start with dbdeployer with an empty box, and quickly populate it with recent and less recent server versions, all at the command line.
MySQLOperations
The State of ProxySQL, 2020 Edition
High AvailabilityOperations
Databases on Kubernetes - Rick Vasquez - PLO October 2020
Operations
Disaster Recovery and High Availability: The Concepts, The Mistakes, and How To Properly Plan For Failure
Any good system must be built to expect the unexpected. None are perfect and at some point something WILL happen to render the system non-operational causing failure.
Join Dimitiri Vanoverbeke, Percona Engineer, as he discusses the concepts of High Availability, Disaster Recovery, common missteps that happen along the way and how to ultimately prepare for failure.
High AvailabilityOperations
BPFTrace - Dtrace Replacement on Linux
Join Peter Zaitsev, Percona CEO, as he discusses bpfTrace and Dtrace on Linux.
While eBPF was included in Linux kernel for quite a few years, it lacked a good “front end” to complete Dtrace functionality in the Linux ecosystem. In this presentation, Peter will look into BPFTrace as a capable Dtrace replacement. He will also demonstrate how you can develop your own tools and utilities using BPFTrace as well as how you can use the...
OperationsPerformance Optimization
MySQL Schema Review - Michael Benshoof - Percona Tech Days
Michael Benshoof, Technical Account Manager at Percona, brings his talk, Schema Review 101: How and What You Should Be Looking at.
The goal of this talk is to review the key features that would be part of a schema review, including things such as largest tables, index issues and table activity. Since learning how to profile your data is important when looking at capacity planning, architecture, and application design, I'll also...
MySQLOperations
Percona Server 8.0 features you always wanted but were afraid to ask for - MySQL Tutorial
Percona Server 8.0 features you always wanted but were afraid to ask for: SEQUENCE_TABLE() and Data Masking.
In the first part of this talk, we will give you a brief introduction to SEQUENCE_TABLE() - a new MySQL table function available in Percona Server 8.0.20-11. We will go through a few examples of how it can be used to generate simple integer sequences, sets of random numbers, pseudo-random string values, etc. As a bonus, we...
MySQLOperations
MySQL 8 Observability - Peter Zaitsev - Percona Tech Days
Broken MySQL means broken Application, so maintaining insights in MySQL operational performance is critical.
Thankfully MySQL 8 offers a lot in terms of observability to resolve problems quickly and get great insights into opportunities for optimization. In this talk, we will cover most important observability improvements in MySQL 8 ranging from Performance Schema and Information Schema to enhanced error logging and optimizer...
MySQLOperations
Understanding and Optimizing commit sychronization for maximum performance
Durability by PostgreSQL is taken for granted. PostgreSQL allows it to be tweaked at different levels. A better understanding of the commit synchronization and how it interacts with standby databases can help to optimize the performance while achieving the desired durability.
-Interaction with OS
-Interaction with the...
PostgreSQLOperations
The State of Data Platforms and Becoming Data-Driven
Open Source DatabaseOperationsScalability