Planet MySQL HA Blog

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

Observing InnoDB Cluster: A different approach for specific info extraction

05/15/2024 | MySQL-Med

Now this is far from being any observability manual for your InnoDB Cluster and let alone go into everything MySQL Shell API Admin, or the collectDiagnostics utility. You can also use the default javascript commands that we all know and love via dba.getCluster() and so on, but here’s a different take.

I just want to share something I’ve been playing with to pull out some key info from mycluster. Hope it helps someone else out there.

General setup:

select cluster_id, cluster_

Learn More »

Release Roundup May 15, 2024

05/14/2024 | Percona
Percona software releases and updates April 30 - May 15, 2024. Percona is a leading provider of unbiased, performance-first, open source database solutions that allow organizations to easily, securely, and affordably maintain business agility, minimize risks, and stay competitive, free from vendor lock-in. Percona software is designed for peak performance, uncompromised security, limitless scalability, and disaster-proofed availability. Our Release Roundups showcase the latest Percona software u

Learn More »

Galera Cluster for MySQL 8.0.36-26.18 released

05/02/2024 | Galera Cluster

Codership is pleased to announce a new Generally Available (GA) release of the multi-master Galera Cluster for MySQL 8.0, consisting of MySQL-wsrep 8.0.36-26.18 (release notes, download). There is no change to the Galera replication library 4.18 (release notes, download) implementing wsrep API version 26. This release incorporates all changes to MySQL 8.0.36, adding a synchronous option for your MySQL High Availability solutions.

This is a very minor release compared to the first MySQL 8.0.36-26

Learn More »

How to Provision a MongoDB Cluster in Kubernetes with Percona Everest Summary

05/01/2024 | Percona
Kubernetes continues evolving, and the complexity of deploying and managing databases within the ecosystem is a topic of considerable discussion and importance these days. This article summarizes a detailed discussion between Piotr Szczepaniak and Diogo Recharte, who offer insights and live demonstrations to simplify database operations on Kubernetes with a new technology for cloud-native applications: Percona Everest. If you want to watch the full video, check out How to Provision a MongoDB Clu

Learn More »

Using ProxySQL Query Mirroring to test query performance on a new cluster

04/30/2024 | Percona
ProxySQL is an SQL aware proxy, which gives DBA’s fine grained control over clients’ access to the MySQL cluster. A key part of our DBA team’s process in testing and preparing for major MySQL version upgrades is comparing query plans using ProxySQL query mirroring. This feature allows us to mirror queries to another cluster / host, by configuring query rules. What makes mirroring particularly useful is the ability to selectively mirror queries based on the query digest, or client user.

Learn More »

Release Roundup April 30, 2024

04/29/2024 | Percona
Percona software releases and updates April 17 - April 30, 2024. Percona is a leading provider of unbiased, performance-first, open source database solutions that allow organizations to easily, securely, and affordably maintain business agility, minimize risks, and stay competitive, free from vendor lock-in. Percona software is designed for peak performance, uncompromised security, limitless scalability, and disaster-proofed availability. Our Release Roundups showcase the latest Percona software

Learn More »

Percona Monthly Bug Report: February/March 2024

04/28/2024 | Percona
At Percona, we operate on the premise that full transparency makes a product better. We strive to build the best open-source database products, but also to help you manage any issues that arise in any of the databases that we support. And, in true open-source form, report back on any issues or bugs you might encounter along the way. We constantly update our bug reports and monitor other boards to ensure we have the latest information, but we wanted to make it a little easier for you to keep trac

Learn More »

Deploying Percona Everest on GCP with Kubectl for Windows 11 Users

04/18/2024 | Percona
Welcome to this blog post! Today, our primary goal is to guide you through deploying Percona Everest on GCP using Kubectl, specifically for users on Windows 11. It’s been some time since I last used Windows, so this will be an excellent opportunity to do it from scratch. Let me tell you a little bit about Percona Everest. You may have already heard it recently. It is the new open source tool launched by Percona and is already well-received by Kubernetes database users.

Learn More »

When COMMIT Is the Slowest Query

04/17/2024 | Hack MySQL

When COMMIT is the slowest query, it means your storage is slow. Let’s look at an example.

Learn More »

Release Roundup April 17, 2024

04/16/2024 | Percona
Percona software releases and updates April 2 - April 17, 2024. Percona is a leading provider of unbiased, performance-first, open source database solutions that allow organizations to easily, securely, and affordably maintain business agility, minimize risks, and stay competitive, free from vendor lock-in. Percona software is designed for peak performance, uncompromised security, limitless scalability, and disaster-proofed availability. Our Release Roundups showcase the latest Percona software

Learn More »

Pages