Planet MySQL HA Blog

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

Choosing The Correct Shape When Migrating MySQL From On-Premise to HeatWave in OCI

This post provides information on how to choose the appropriate shape when migrating your MySQL workload from on-premise to HeatWave (MySQL) in Oracle Cloud Infrastructure. The post also provides some additional information for a successful migration.

Learn More »

MySQL 9.3! Thank you for your contributions!

Before the MySQL & HeatWave Summit, we released MySQL 9.3, the latest Innovation Release. The event was terrific, and I had the chance to meet some of the MySQL contributors. As usual, we released bug fixes for 8.0 and 8.4 LTS, but I focus on the newest release in this post.

Learn More »

Improving Semi-join Performance in MySQL

This blog post describes the latest performance improvement in semi-join / anti-join queries.

Learn More »

Enhance Data Protection in HeatWave

This blog describes two new properties of a HeatWave MySQL database system (DB system) on OCI: database and access mode. These DB system properties can be used to update the DB system read-write setting and restrict access only to administrator accounts.

Learn More »

Making it Easy to Load and Query CSV Files with HeatWave Lakehouse

In this blog we will see how HeatWave Lakehouse automates the detection of dialects when loading CSV (Comma Separated Value) files from object storage.

Learn More »

AI Features Available in HeatWave Always Free Tier

HeatWave offers a variety of AI features - and many of these features are available in the Always Freed tier. In this post we discuss some of the performance differences when training an AI model and doing predictive analysis.

Learn More »

Progress report on pg_tde - GA extension is nearer every day!

| Percona

Another week, another blogpost about the state of open source Transparent Data Encryption (TDE) for PostgreSQL.

First off, thank you for all the feedback shared so far!

Whether it’s reports about deployment issues with pg_tde, integration with KMS, missing features or gaps in our documentation, we truly appreciate it! Your input helps us build a better, more complete solution and to properly prioritize what’s next.

What’s the word?

Learn More »

MySQL Routing Guidelines: A Practical Guide to Management and Configuration

Learn how to configure and manage MySQL Routing Guidelines using MySQL Shell's AdminAPI, with step-by-step examples for InnoDB Cluster, ClusterSet, and ReplicaSet - Enabling smarter and more dynamic query routing.

Learn More »

MySQL and HeatWave Summit 2025: 2 Days of Innovation, Learning, and Collaboration

On April 22-23rd, 2025, the Oracle Conference Center in Redwood Shores, California, buzzed with excitement as the MySQL and HeatWave Summit 2025 kicked off. The MySQL and HeatWave Summit is the largest gathering of MySQL users, developers and product experts in the world. The summit brought together developers, DBAs, experts, and users for this two day event packed with learning, networking, and celebration of MySQL’s latest advancements.

Learn More »

Performance Regression in MySQL 8.0, Fixed in 8.4, Easy Workaround (innodb_doublewrite_pages)

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 »