Let’s now see how we can connect to our MySQL HeatWave DB System, which was deployed with the OCI Hackathon Starter Kit in part 1. We have multiple possibilities to connect to the DB System, and we will use three of them: MySQL Shell in the command line MySQL Shell is already installed on the […]

In our earlier post, we unpacked the mechanics of MySQL HeatWave maintenance, the behind-the-scenes process that keeps your MySQL environments secure, stable, and optimized without changing your database version. We also touched on how Auto Minor Version Upgrades occur when a version reaches the end of its lifecycle. With this update, MySQL HeatWave introduces Configurable Maintenance Windows and Auto-Upgrade Controls, giving you […]

  Introduction MySQL HeatWave is a fully managed MySQL database service that combines transactions, analytics, machine learning, and GenAI services, without ETL duplication. Also included is MySQL HeatWave Lakehouse, which allows users to query data in object storage, MySQL databases, or a combination of both. Users can deploy MySQL HeatWave–powered apps on a choice of […]

MySQL HeatWave is the only fully managed MySQL database service that combines transactions, analytics, machine learning, and GenAI services, without ETL duplication. Also included is MySQL HeatWave Lakehouse, which allows users to query data in object storage, MySQL databases, or a combination of both. Users can deploy MySQL HeatWave–powered apps on a choice of public […]

Ensuring the reliability and performance of database backup and recovery operations is mission-critical for any enterprise. MySQL HeatWave Service already provides robust support for Manual, Automatic, and Operator backups. To further enhance the integrity and efficiency of backup operations, we are excited to introduce two new features: Backup Validation and Backup Preparation. Why Backup Validation and Preparation Matter For many […]

Introduction Customers often need to perform analytics on their MySQL audit logs for compliance, monitoring, and troubleshooting. However, managing large volumes of audit data within MySQL can be inefficient and costly. To address this, an archival system is essential—one that reliably extracts audit logs, stores them in a cost-effective repository, and makes them available for […]

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 […]

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 […]

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 […]

Database Management on Oracle Cloud Infrastructure (OCI) continues to evolve, enabling MySQL users to gain deeper visibility and manage their HeatWave and on-premises (External) MySQL DB systems. In our previous blogs, we introduced how Database Management supports monitoring for both HeatWave and External MySQL DB systems.  We’re now expanding its capabilities with a new set of […]