Planet MySQL HA Blog

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 »

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 »

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 »

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 »

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 »

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 has been released, here is a list of the contributions we included in it. Thank you to all contributors!

Learn More »

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 »

This post demonstrates how you can use HeatWave GenAI to transform an unstructured PDF of a purchase order into a structured, queryable format directly within your database. We'll walk through the process of loading a PO from an object store and then asking natural language questions to retrieve key details like order dates, item costs, and supplier information.

Learn More »

We’re happy to announce the release of ClusterControl v2.3.4, delivering powerful updates that strengthen high availability, secure deployment options, and scalability for enterprise-scale database management.  As with every release, we’ve focused on tackling real-world challenges our users face. Below, we’ll dive into the key features that define this release, followed by additional improvements that round […]

The post ClusterControl 2.3.4 Adds MySQL Group Replication, Streamlined Air-Gapped Installation, and Controller Pooling for Scalable Management appeared first on…

Learn More »