Planet MySQL HA Blog
The Planet MySQL HA Blog aggregates content from sources that cover topics related to high availability (HA) for MySQL databases.
Deploying MySQL InnoDB ClusterSet Across Kubernetes Clusters Using Cilium
Deploying MySQL InnoDB ClusterSet across multiple Kubernetes clusters is a complex challenge. While the MySQL Operator for Kubernetes can manage a MySQL InnoDB Cluster within a single Kubernetes cluster, deploying an InnoDB ClusterSet across multiple clusters requires cross-cluster communication, which is not yet supported by the current MySQL Operator release. This is where Cilium […]
HeatWave Always Free Tier Disaster Recovery Support
HeatWave is the only fully managed MySQL database service that combines transactions, analytics, machine learning, and GenAI services, without ETL duplication. HeatWave also includes HeatWave Lakehouse, allowing users to query data stored in object storage, MySQL databases, or a combination of both. Users can deploy HeatWave MySQL–powered apps on a choice of public clouds: Oracle Cloud Infrastructure (OCI), […]
Making CREATE/DROP SCHEMA Truly Atomic in MySQL
Introduction Guaranteeing the atomicity of database operations is critical for maintaining data integrity. While DDL operations for InnoDB tables have long been atomic and crash-safe, we recognized that DDL operations for schemas lacked the same level of robustness. Starting from MySQL Server 9.1 Community Edition, we have improved the atomicity of CREATE SCHEMA and DROP […]
Multicloud: deploying a MySQL HeatWave instance on AWS
Multicloud is a cloud adoption strategy that utilizes services from multiple cloud providers rather than relying on just one. This approach enables organizations to take advantage of the best services for specific tasks, enhances resilience, and helps reduce costs. Additionally, a multicloud strategy offers the flexibility necessary to meet regulatory requirements and increases options for […]
Enabling FIPS Mode – MySQL Server, Linux, OpenSSH, and OpenSSL 3
Ensuring FIPS compliance is crucial for securing sensitive data and meeting compliance objectives. For those of you unfamiliar with the term, FIPS (Federal Information Processing Standards) are a set of standards and guidelines issued by the U.S. National Institute of Standards and Technology (NIST) for use in federal computer systems. This blog provides a step-by-step guide […]
Smarter Query Routing with MySQL Routing Guidelines
With the 9.2.0 Innovation Release of MySQL Shell and MySQL Router, we are introducing Routing Guidelines – a new feature that makes query routing in MySQL database architectures more dynamic, flexible, and declarative. Available in the MySQL Community and Enterprise Editions, this feature enables tailored query routing for specific application needs and ensures seamless query distribution across MySQL InnoDB Cluster, ClusterSet, and ReplicaSet […]
MySQL 9.2 : thank you for your contributions!
At the beginning of the year, we released MySQL 9.2, the latest Innovation Release. Sorry for the delay, but I was busy with the preFOSDEM MySQL Belgian Days and FOSDEM MySQL Belgium Days. Of course, we released bug fixes for 8.0 and 8.4 LTS, but in this post, I focus on the newest release. Within […]
How To Check The Available Memory In Your HeatWave MySQL Cluster Via SQL
HeatWave MySQL Cluster HeatWave is a massively parallel, high performance, in-memory query accelerator that accelerates MySQL performance by orders of magnitude for analytics workloads, mixed workloads, and machine learning. HeatWave can be accessed through Oracle Cloud Infrastructure (OCI), Amazon Web Services (AWS), and Oracle Database Service for Azure (ODSA). HeatWave consists of a MySQL DB […]
Understanding MySQL Global Transaction Identifiers (GTIDs) And Their Role in Replication
MySQL Replication MySQL has built-in replication, which enables data from one MySQL database server (known as a source) to be copied to one or more MySQL database servers (known as replicas). Replication is asynchronous by default; replicas do not need to be connected permanently to receive updates from a source. Depending on the configuration, you can […]
Meeting NIS2 Challenges with MySQL Enterprise Edition
The NIS2 Directive strengthens EU cybersecurity standards by expanding sector coverage and imposing stricter requirements. This document outlines how MySQL Enterprise Edition can help organizations meet these demands, focusing on key areas for securing MySQL database servers within the NIS2 framework. NIS2 covers various sectors, from energy and transport to digital infrastructure and manufacturing. It […]