Planet MySQL HA Blog

button#focus {display:none; visibility:hidden;} nav#toc {display: none;} Conference Video Slides MySQL Performance for Application Developers @ MySQL and HeatWave Summit 2025† mysql-summit-2025.pdf MySQL Performance for Developers @ Percona Live 2023† PL23.pdf Efficient MySQL Performance @ Percona Live 2022 PL22.pdf Efficient MySQL Performance @ FOSDEM 2022 -

† Video recording not available

Learn More »

This is the second part of our series on managing on-premises (External) MySQL DB systems in Oracle Cloud Infrastructure (OCI). In this blog, we cover the registration process, fleet monitoring, key metrics, alarms, and events to help you optimize performance and gain operational insights. Ensure that the prerequisites from the first part are completed and that you have the necessary permissions to proceed.

Learn More »

This blog will guide you through setting up and managing On-premises (External) MySQL DB systems in OCI, ensuring optimal performance and operational insights. In this part, we will cover the prerequisite steps before registering and managing External MySQL DB systems.

Learn More »

This blog outlines how to set up Oracle Heatwave MySQL disaster recovery copy for the production database using the OCI Console level full backup, copying the backup to another region, building the disaster recovery database from the primary backup and setting up the in-bound replication channel from primary to disaster recovery database.

Learn More »

Just for fun...

Numerous options exist for testing MySQL and general database instances.

This is just an example of how you can use Proxmox to have a simple fast setup for repeatable testing and access.

This example is a nice and cheap option to have a home lab for MySQL and anything else you want.

The homelab virtualization I picked was Proxmox and Openmediavaul for extended NFS storage (not 100% sold on Openmediavault, Debian alone could do it)

Hardware I pic

Learn More »

MySQL 8.0 will reach End-Of-Life (EOL) in April 2026. This means that HeatWave MySQL will no longer provide support or updates for MySQL 8.0 after this date. Customers should upgrade to newer supported version of HeatWave MySQL 8.4 LTS much ahead of the April 2026 deadline. This announcement is to provide customers with sufficient time to migrate their DB systems from 8.0 to the latest LTS release track. This article is exclusive to the cloud service version (HeatWave MySQL).

Learn More »

The first launch of your database is not the end; it is the beginning of Day-2 operations. Day-2 operations include critical, ongoing tasks such as rolling upgrades, patching, capacity scaling, and continuous performance tuning. These tasks are essential to ensure high availability, security, and performance of your production environments. Manual execution of Day-2 operations by DBAs and operators can waste time, introduce risk, and limit agility. 

This post will explore the significanc

Learn More »

MySQL 8.4 has two good options for High Availability clusters: Galera Cluster (and Percona XtraDB Cluster (PXC)) plus MySQL InnoDB Cluster. Both solutions are now mature enough, so what is the deciding factor? Workload characteristics, application compatibility (Galera is virtually synchronous; InnoDB Cluster offers 2 modes – single primary mode, which is one instance being read-write, with the rest being read only, and multi-primary mode, which is closer to what Galera Cluster is) and ope

Learn More »

For users of HeatWave Service, the maintenance process can sometimes feel like a black box. What does it entail? How does it differ from version upgrades? When and how are updates applied? With questions like these swirling around, it’s time to unpack the mechanics of HeatWave maintenance and shed light on its purpose, scope, and flexibility. Whether you’re managing a production database or planning a deployment, this guide will help you navigate the process with confidence.

Learn More »

We are excited to announce that HeatWave on AWS is now available in the US West (Oregon) and Asia Pacific (Seoul) AWS regions, in addition to US East (N.Virginia), Europe (London), Europe (Frankfurt), Asia Pacific (Tokyo), and Asia Pacific (Mumbai).

Learn More »