In this webinar, Sveta Smirnova, MySQL Engineer at Percona, will uncover nuances of Percona XtraDB Cluster (PXC) schema upgrades and point out details you need to give extra attention to.

Percona XtraDB Cluster (PXC) is a 100% synchronized cluster in regards to DML operations. It is ensured by the optimistic locking model and ability to rollback transaction which cannot be applied on all nodes. However, DDL operations are not transactional in MySQL. This adds complexity when you need to change the schema of the database. Changes made by DDL may affect the results of the queries. Therefore all modifications must replicate on all nodes prior to next data access. For operations that run momentarily, it can be easily achieved, but schema changes may take hours to apply. Therefore in addition to the safest synchronous blocking schema upgrade method: TOI, – PXC supports more relaxed, though not safe, method RSU. RSU: Rolling Schema Upgrade is …

First I want to thank everyone who attended my May 21, 2020 webinar “How Safe is Asynchronous Master-Master Setup in MySQL?“. Recording and slides are available on the webinar page.

Here are answers to the questions from participants which I was not able to provide during the webinar.

Q: What do you generally think of hosting Relational Databases on VM’s as opposed to Bare metals?

A: With modern hardware and modern virtual machines this is absolutely possible. I know about many successful high loaded applications that run MySQL on VMs.

Just note that running a few VMs on a single physical machine may lead to resource loss rather than saving. For …

Join Peter Zaitsev, CEO at Percona, as he discusses eBFT. eBPF is one of the most powerful instrumentation frameworks in modern Linux Kernel. In this presentation, we will cover eBPF basics as well as usage of Interactive eBPF tools, showing practical examples when and how they can help to resolve performance problems. Finally, we will look into Cloudflare’s ebpf_exporter and show how you can integrate eBPF with Prometheus for Long Term Monitoring.

Please join Peter Zaitsev, CEO at Percona, on Wednesday, June 10 at 11 am EDT for his webinar “Using eBPF for Linux Performance Analyses”.

Watch the Recording

If you can’t attend, sign up anyway and we’ll …

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 Ecosystem

Please join Alkin Tezusal of Percona, on Thursday, June 4 at 10 am EDT for his webinar “MySQL Ecosystem in 2020”.

Watch the Recording

If you can’t attend, sign up anyway and we’ll send you the slides and recording afterward.

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 overall view of the current state of best-in-breed MySQL clustering as well as the Percona roadmap for the future.

Please join Tyler Duzan of Percona, on Tuesday, May 26 at 11 am EDT for his webinar “What’s New in Percona XtraDB Cluster (PXC) 8.0?”.

…

It is common knowledge that built-in asynchronous master-master (active-active) replication is not safe in MySQL. I remember times when the official MySQL User Reference Manual stated that such an installation is not recommended for production use. Some experts repeat this claim even now.

While this statement is generally true, I worked with thousands of shops that successfully avoided asynchronous replication limitations in active-active setups.

In this talk, I will show how they did it, demonstrate situations when asynchronous master-master replication is the best possible high availability option and beats such solutions as Galera or InnoDB Clusters. I will also cover common mistakes, leading to disasters.

Please join Sveta Smirnova of Percona, on Thursday, May 21 at 12 pm EDT for her webinar “How Safe is Asynchronous Master-Master Setup in MySQL?”.

…

Peter Zaitsev, Founder and CEO at Percona, presents a webinar focused on dealing with an unexpected high traffic event as it is happening. He’ll 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. Join us and learn how to bring your database under control, earn performance gains, and delight your customers!

Please join Peter Zaitsev, CEO of Percona, on Wednesday, May 13 at 12 pm EDT for his webinar “18 Things To Do When You Have a MySQL Bottleneck“.

Register Now

If you can’t attend, sign up anyway and we’ll send you the slides and recording afterward.

During this joint webinar our speakers, Alkin Tezuysal, Technical Expert at Percona and Sugu Sougoumarane, Co-Founder and CTO at PlanetScale, will provide attendees with hands-on experience using Vitess using Kubernetes. They will start by providing a quick overview of Vitess – including key concepts and terminology, and then describe the deployment options for both in Kubernetes.

The hands-on exercises will cover many of the key workflows with running a sharded system:

– Moving from an unsharded system to a vertical split one (moving some tables to a different host)
– Sharding large tables across several instances
– Backups, Recoveries, and failovers (both planned and unplanned).

Attendees are not expected to have any prior experience with Vitess but will find it useful if they have prior experience completing these tasks in a MySQL environment and general know-how …

Although MySQL is now more than two decades old, it continues to power some of the world’s largest internet applications. In this presentation, we’ll look at the history and evolution of distributed MySQL deployments. We’ll explore the original designs and the common architecture patterns still in use today. Finally, we’ll predict what the future has in store for us with the advent of the cloud and containers as the new operating environments for databases.

Please join Peter Zaitsev on Wednesday, April 29 at 11:00 am EDT for his webinar “Distributed MySQL Architectures – Past, Present, Future”.

Watch the Recording

If you can’t attend, sign up anyway and …

In this talk, we’ll walk through RocksDB technology and look into situations where MyRocks is a good fit versus other engines such as InnoDB. We will go over internals, benchmarks, and the tuning of MyRocks engine. We will also explore the benefits of using MyRocks within the MySQL ecosystem. Attendees will leave with solid knowledge of the latest development tools and integrations within MySQL.

Please join Alkin Tezuysal and Sergey Kuzmichev on Monday, March 23rd, at 9:00 am EDT for their webinar “When is MyRocks a Good Fit?”

View the Recording