Nov 3, 2020

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


Nov 3, 2020

The State of ProxySQL, 2020 Edition

The State of ProxySQL, 2020 Edition

High AvailabilityOperations


Nov 3, 2020

Databases on Kubernetes - Rick Vasquez - PLO October 2020

Databases on Kubernetes - Rick Vasquez - PLO October 2020

Operations


Oct 29, 2020

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


Oct 8, 2020

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


Sep 21, 2020

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


Sep 21, 2020

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


Sep 21, 2020

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


Aug 26, 2020

Understanding and Optimizing commit sychronization for maximum performance

Jobin Augustine present "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


Jul 22, 2020

The State of Data Platforms and Becoming Data-Driven

Data growth is expected to skyrocket for the foreseeable future, so what are enterprises to do? How can organizations leverage all their data to become a data-driven enterprise? It begins at the data layer—the place where the data lives. In this session, we will discuss current database landscape, trends, and how organizations can leverage the right data platform environment that will most prepare them to leverage their data, opening the...

Open Source DatabaseOperationsScalability


Pages