Planet MySQL HA Blog

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 with being known since 16 Jul 2024, has not been talked about much, so this deserves a blog post.Jean-François Gagnéhttp://www.blogger.com/profile/12267071794432977020noreply@blogger.com0

Learn More »

Connecting to MySQL HeatWave in OCI

Learn More »

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 »