Planet MySQL HA Blog
The Planet MySQL HA Blog aggregates content from sources that cover topics related to high availability (HA) for MySQL databases.
How To Select The Best Shape When Migrating From On-Premise MySQL To HeatWave On Oracle Cloud Infrastructure
Choosing the correct shape for a MySQL HeatWave instance in Oracle Cloud Infrastructure (OCI) when migrating your on-premise MySQL database involves assessing your current workload requirements and matching them to the available MySQL HeatWave shapes. A “shape” in (OCI) defines the compute resources (CPUs, memory, maximum network bandwidth, etc.) allocated to your MySQL Database System […]
MySQL Commands To Gather Runtime Statistics For Database Performance Assessment
If you need to know how your MySQL database is performing, or maybe you want to move your MySQL on-premise database to MySQL Heatwave on Oracle Cloud Infrastructure (OCI), this post will explain how to manually collect metrics on connections, resource usage, query performance and database characteristics. This post doesn’t contain every single possible command you […]
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 […]