Jun 9, 2020

MySQL Ecosystem in 2020

Join Alkin Tezusal, Percona Technical Expert, as he covers the past, present and future of MySQL as an Open Source Database.

During this webinar he will discuss:
  • Use cases of MySQL as well as edge cases of MySQL topologies using real-life examples and "war" stories
  • How scalability and proxy wars make MySQL topologies more robust to serve webscale shops
  • Open-source tools, utilities, and surrounding MySQL...


Jun 5, 2020

The journey from a MySQL proxy to being the de-facto multi-functional tool that scales MySQL

ProxySQL has had a stable, generally available release since December 2015, and since that time has moved from Version 1.x to Version 2.x, now with a more fast track release cadence.
The goal of this hour long webinar is to go through some of our design principles and how we have managed to progress from database proxy to multi-function tool that so many benefit from.

ProxySQL 2.0 has so many new features, from setting up...

MySQLPercona XtraDB ClusterPerformance Optimization

May 29, 2020

What's New in Percona XtraDB Cluster (PXC) 8.0

During this webinar, Tyler Duzan, Product Manager for MySQL and Cloud at Percona, will discuss Percona's decision to delay Percona XtraDB Cluster 8.0 to ship it with Galera 4 instead of Galera 3, and why that matters. In addition he'll talk about the work done to integrate MySQL 8.0 features with Galera as well as how Percona is treating Kubernetes as one of its primary target platforms with this release. This webinar will provide an...

MySQLPercona XtraDB Cluster

May 26, 2020

Optimize and Troubleshoot MySQL using PMM 2 - Peter Zaitsev - Percona Live Online 2020

Peter Zaitsev talked about the 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 also expected to find cost-efficient means of solving these issues. In...

Percona Live SessionsMySQLPercona Monitoring and Management

May 26, 2020

Dynamic Tracking for Finding MariaDB (and MySQL) Performance Problems on Linux - Percona Live 2020

Valeriy Kravchuk talked about while troubleshooting MariaDB server performance problems it is important to find out where the time is spent in the mysqld process, on-CPU and off-CPU. The process of investigation should have as small influence as possible on the server we try to troubleshoot.

Performance_schema introduced in MySQL 5.5 (and inherited from MySQL 5.6 by MariaDB) is supposed to provide detailed enough instrumentation...

Percona Live SessionsMariaDBMySQL

May 26, 2020

MySQL and Clickhouse - Vadim Tkachenko - Percona Live Online 2020

In this talk I will review how to combine popular transactional and analytical databases together to get the best from both worlds. Let's talk about how to get data from MySQL to ClickHouse, different migration scenarios, and what integration solutions are available for MySQL DBA get up to speed with ClickHouse in no time.

Percona Live SessionsMySQLMigration

May 26, 2020

Enhancing MySQL Security at LinkedIn- Karthik Appigatla - Percona Live Online 2020

In this talk, we will discuss how security is enhanced for MySQL at LinkedIn. The following areas will be covered:

1- A brief overview of MySQL at LinkedIn
2- MySQL Access Management- Privileged User Access Control- Fine-grained Access Control- Access to application owners
3- SSL- Applications to Databases- Replication
4- Audit Framework- Audit Plugin- Syslog to Kafka- Query Analyzer
5- How applications get...

Percona Live SessionsMySQLSecurity

May 26, 2020

Comparison of Kubernetes Operators for MySQL - Mykola Marzhan - Percona Live Online 2020

Running databases in Kubernetes attracts a lot of attention today. Orсhestration of MySQL on Kubernetes is no way a straightforward process. There are several good MySQL based solutions in the open-source world, made by Oracle, Presslabs, and Percona. Having a common base, they differ in self-healing capabilities, consistency guarantees, storage capabilities, monitoring, proxying and backup / restore support, etc. So, let’s make a fair...

Percona Live SessionsContainers and AutomationMySQL

May 26, 2020

Kubernetes - the Swiss Army Knife for your ProxySQL deployments - Rene Cannao - Percona Live 2020

ProxySQL is a high performance proxy from design to implementation. It speaks the MySQL protocol, and can go beyond load balancing. This talk covers various deployment options for ProxySQL in a Kubernetes environment.
Typically ProxySQL is deployed in one of three ways depending on the scale and needs of your environment:
- Directly on each application server
- On a separate server (or layer)
- Cascaded, i.e. on each...

Percona Live SessionsMySQLPerformance Optimization

May 26, 2020

Dark corners of the MySQL code base - Daniel Black - Percona Live Online 2020

As you'd expect with a 25+ year code base there are aspects of the MySQL codebase that are unglamorous. These dark corners contain implementations that introduce behaviour that users depend upon, that changing will introduce storage or replication compatibility issues, or just don't attract the resources to sufficiently rewrite. These areas of code can lead to performance degradation by having code that doesn't utilize hardware in an...

Percona Live SessionsMySQLOperations