Planet MySQL HA Blog

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

Learn MySQL Performance

| Hack MySQL

Every year new cohorts of programmers, DBAs, managers, and more learn MySQL. After MySQL and HeatWave Summit 2025 a few weeks ago, I realized what job needs to be done for these people and how I could help them make progress: revamping this website to focus on “the path”.

Learn More »

Creating a Highly Available HeatWave Database System Using Oracle Cloud Shell

In this blog, we will walk through the process of creating a HeatWave HA Database system using Oracle Cloud Shell.

Learn More »

Oracle Dev Days 2025 – French Edition

| MySQL expert Diary

Join the Oracle Dev Days – French Edition, from May 20 to 22, 2025!
This must-attend event (in French) offers a rich program exploring the latest advancements in AI, databases, cloud, and Java.

Join me on May 21 at 2:00 PM for the day dedicated to “Database & AI.” I’ll be presenting “Building an AI-Powered Search Engine with HeatWave GenAI.” I’ll show you how to go beyond the limits of traditional SQL to harness the power of LLM-driven semantic search.

The post Oracle Dev Days 2025 – French Edition first appeared on dasini.net - Diary of a MySQL expert.

Learn More »

Improve Primary Selection on Failover in MySQL Group Replication

The latest update to MySQL Enterprise Edition, version 9.3, introduces a significant enhancement focused on improving primary selection on failover. This update includes an improvement to Group Replication primary failover, providing users with a better selection method of a new primary based on the member's most current data. This enhancement results in a seamless experience during failover, maintaining high availability and data integrity.

Learn More »

Optimize Database Performance with HeatWave's Enhanced Read Operations

Managing read traffic efficiently is crucial for maintaining a high-performing database. With Read Endpoints playing a critical role in directing read traffic, having a flexible, configurable and scalable Read Endpoint solution is a must for ensuring high availability and performance in the DB system, or simplifying application configurations.

Learn More »

Without Good Data, AI is Useless

When training AI models, it is important to use "good" data. Without good data, the model si pretty much useless. In this post, I share what I learned when trying to train an AI model for use in Episode 89 of MySQL Shorts.

Learn More »

Anomaly Detection with HeatWave AutoML

Anomaly detection is an effective technique for finding abnormalities in data. HeatWave AutoML offers an automated machine learning pipeline for anomaly detection based on patented algorithm that can detect various types of anomalies and provides better accuracy compared to other anomaly detection techniques. It also supports semi-supervised learning, Principal Component Analysis (PCA) and internally developed technique called Generalized Local Outlier Factor (GLOF).

Learn More »

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 »