Planet MySQL HA Blog
The Planet MySQL HA Blog aggregates content from sources that cover topics related to high availability (HA) for MySQL databases.
Monitoring MySQL HeatWave Replication Using OCI Database Management Custom Alarms
Monitoring MySQL replication is key to maintaining data consistency, troubleshooting issues, and ensuring smooth failover across environments. It helps confirm that your replication topology is running as expected, assists in identifying delays or failures, and gives control to manage increasingly complex deployments. Understanding MySQL Replication types: Asynchronous replication can be configured to establish pathways for […]
HeatWave Point-in-time Recovery of deleted DB systems
HeatWave is the only fully managed MySQL database service that combines transactions, analytics, machine learning, and GenAI services, without ETL duplication. It 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), Amazon Web Services […]
MySQL Routing Guidelines: Breaking Down the Mechanics in MySQL Router
Welcome to the final post in our MySQL Routing Guidelines series. In the first two posts (Smarter Query Routing with MySQL Routing Guidelines and MySQL Routing Guidelines: A Practical Guide to Management and Configuration), we introduced the concept of Routing Guidelines and showed how to configure and manage them in MySQL Shell. Now, we’re going […]
MySQL AWS keyring component extends functionality of AWS keyring plugin
MySQL Server utilizes keyring to store cryptographic keys used by several modules to secure data stored by them. For example, InnoDB storage engine uses a key to encrypt tablespace, binary log and relay log management use keys to encrypt passwords for the log files. There are several keyring components and plugins that may be used […]
Deploying High Availability and Disaster Recovery MySQL on OCI like a devops
We all know MySQL InnoDB ClusterSet, a solution that links multiple InnoDB Clusters and Read Replicas asynchronously to easily generate complex MySQL architectures and manage them without burdensome commands. All this thanks to the MySQL Shell’s AdminAPI. This is an example of MySQL InnoDB ClusterSet using two data centers: Let’s explore how we can […]
How do you upgrade MySQL HeatWave when deploying with Terraform?
Have you already tried to upgrade the MySQL version of your MySQL HeatWave instance in OCI that is deployed with Terraform? When you tried, you realized, I hope you didn’t turn off backups, that the instance is destroyed and recreated new! This is our current MySQL HeatWave DB System deployed using Terrafrom: And this is […]
HeatWave MySQL: Solving Missing UPDATES for Debezium CDC
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 […]
HeatWave MySQL security series – Customer managed encryption keys
Oracle HeatWave is a fully managed cloud database service that integrates with MySQL, combining transactions, analytics, machine learning, and generative AI capabilities. It features an in-memory query accelerator for real-time analytics, eliminating the need for ETL processes to separate databases. Available on Oracle Cloud Infrastructure (OCI), AWS, and Azure, HeatWave automates tasks like backups and […]
Using In-HeatWave LLMs on OCI Always Free
HeatWave MySQL is the only fully managed MySQL database service that combines transactions, analytics, machine learning, and GenAI services, without ETL duplication. It 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), Amazon Web Services (AWS), and Microsoft Azure. This […]
Uplevel the MySQL REST Service
The MySQL REST Service is a next-generation JSON Document Store solution, enabling fast and secure HTTPS access to data stored in MySQL, HeatWave, InnoDB Cluster, InnoDB ClusterSet, and InnoDB ReplicaSet. The MySQL REST Service was first released on https://labs.mysql.com in 2023 using MySQL Router. During spring 2025, it was released on MySQL HeatWave and standard […]