Planet MySQL HA Blog

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

preFOSDEM MySQL Belgian Days 2025 - Agenda

This is the agenda of the preFOSDEM MySQL Belgian Days 2025, an Oracle MySQL technical event managed by the MySQL Community Team for customers, partners & community users.

Learn More »

Tracking Query Plans Part I and Rebooting This Blog

01/06/2025 | PHP With MySQL

Did you ever need to determine the performance of a query over time? One of the problems with database query optimizations is that the underlying data is always churning. Add in an increase in the number of users, expanding server demand use, and other items that impact your query. What was optimized is no longer performing as expected.

MySQL added a JSON format option to the output of the EXPLAIN command quite a while ago. More recently, Oracle added the feature of saving the output into a varia

Learn More »

MySQL 8.4 Support in Percona Toolkit 3.7.0

01/05/2025 | Percona
Percona Toolkit 3.7.0 has been released on Dec 23, 2024. The main feature of this release is MySQL 8.4 support. In this blog, I will explain what has been changed. A full list of improvements and bug fixes can be found in the release notes. TLDR; Replication statements in 8.4 are fully supported by the Percona Toolkit pt-slave-delay has been deprecated. pt-slave-find has been renamed to pt-replica-find. The old name has been deprecated but exists in the repository as an alias of the pt-replica-f

Learn More »

Monitoring Multi-threaded Replication Lag With Performance Schema

12/28/2024 | Hack MySQL

Used to be that replication lag was as simple as Seconds_Behind_Master (renamed to Seconds_Behind_Source). But with multi-threaded replication (MTR) this is no longer the case. It’s time to relearn replication lag monitoring using Performance Schema tables.

Learn More »

A Message From the Community Team

For the final day of our Advent Calendar of Content, we bring you a message from the Community Team.

Learn More »

MySQL enters a new decade!

For this penultimate article before Christmas, let's announce the 30th anniversary of MySQL!

Learn More »

MySQL Blog Revisited - OCI TypeScript SDK

For the 22nd day of our Advent Calendar of Content, we bring you a summary of all the MySQL Blog posts that demonstrate using the OCI TypeScript SDK

Learn More »

MySQL Shorts Revisited - DBA Goodies

For the 21st day of our Advent Calendar of Content, we bring you a summary of all the MySQL Shorts that are focussed on topics that would interest DBAs.

Learn More »

MySQL Retrospective - ISAM & MySAM Log

Let's stay a bit longer with MySQL 3.2x to advance the MySQL Retrospective in anticipation of the 30th Anniversary.

Learn More »

MariaDB Galera Cluster with MariaDB MaxScale – Getting Started with Read Write Split

12/19/2024 | Galera Cluster

MariaDB Galera Cluster is a synchronous multi-master database cluster solution that provides MariaDB high availability and data consistency. MariaDB MaxScale is a database proxy that can be used to improve the performance, scalability, and security of MariaDB Galera Cluster. Codership (the makers of Galera Cluster) have a long term partnership with MariaDB Corporation, including joint development, roadmap planning, and supporting customers for continued success.

Using MariaDB MaxScale with Maria

Learn More »

Pages