Planet MySQL HA Blog

The Planet MySQL HA Blog aggregates content from sources that cover topics related to high availability (HA) for MySQL databases.

OAuth, OIDC, validators, what is all this about?

| Percona

Somebody might tell you, “let’s configure PostgreSQL 18 with OIDC, it should be simple, only takes a few minutes!” And that might be the case if you already have an OIDC provider set up and know all the details about the protocols, configurations, and possible issues. Or it might take much longer if you just open your favorite search engine and type “What is this OIDC stuff about?”

In this series of blog posts, I’ll try to help with this task. First, by clearing up all the terminology and details in this article. Later, I’ll provide vendor-specific setup instructions for some of the…

Learn More »

Performance Regression in MySQL 8.0, Fixed in 8.4, Easy Workaround (innodb_doublewrite_pages)

While doing benchmarks on 5.7 and 8.0, I came across a performance regression in MySQL 8.0 over 5.7 and opened a bug (Bug #111353 : 3x Performance Regression from 5.7 to 8.0 on ALTER TABLE FORCE).  There has been recent activity on this bug, showing an easy workaround.  This, even if it is known since 16 July 2024, has not been talked about much, so this deserves a blog post.

Learn More »

MySQL Basics: Don’t Lose It—Backing Up and Restoring Your Database

Learn how to safeguard your MySQL database with simple, reliable backup and restore techniques! This final post in the beginner series uses fun library analogies and clear MySQL Shell examples to ensure your data stays safe—no matter what surprises come your way.

Learn More »

MySQL Basics: Safe and Sound—User Management and Database Security

Keep your MySQL database protected with beginner-friendly advice on user management and security! Learn how to create users, grant and revoke privileges, and safeguard your data using library-themed examples and practical tips. Essential reading for every data explorer eager to lock up their digital collection.

Learn More »

Encryption support in PMM Dump

| Percona

The pmm-dump client utility performs a logical backup of the performance metrics collected by the PMM Server and imports them into a different PMM Server instance. PMM Dump allows you to share monitoring data collected by your PMM server with the Percona Support team securely.

Up until now dumps, created by the tool, were not encrypted. It was possible to encrypt them after they are done but this required additional actions from the user.

Learn More »

MySQL Basics: Trust the Process—Mastering Transactions Step by Step

Discover how to use transactions in MySQL to keep your data safe and organized—just like a diligent librarian! This beginner-friendly post explains what transactions are, why they matter, and how to use them with easy library metaphors, clear SQL examples, and essential tips for database reliability.

Learn More »

MySQL 9.5 – Thank you for your contributions!

On October 10th, 2025, we released MySQL 9.5, the latest Innovation Release. As usual, we released bug fixes for 8.0 and 8.4 LTS, but this post focuses on the newest release. In this release, we can see contributions related to Connector J and Connector Net, as well as to different server categories. Connector / J […]

Learn More »

MySQL 9.5 – Thank you for your contributions!

MySQL 9.5 has been released, here is a list of the contributions we included in it. Thank you to all contributors!

Learn More »

MySQL Basics: The Inside Track—Speeding Up Searches with Indexes

Unlock the secret to faster data searches with indexes! This post introduces beginners to the power of indexes in MySQL, using friendly library metaphors and simple SQL examples. Learn how—and why—to create indexes, understand their impact, and keep your growing database running at page-turning speed.

Learn More »

Effortless Document AI with MySQL HeatWave GenAI

Manually sifting through documents like purchase orders (POs) to find specific information is a time-consuming and often frustrating task. What if you could simply ask questions in plain English and get immediate, accurate answers? This is now possible with MySQL HeatWave GenAI. MySQL HeatWave is a fully managed MySQL database service that combines transactions, analytics, […]

Learn More »