Planet MySQL HA Blog

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

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 »

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 »