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

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

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

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

It’s incredibly useful to know which tables in your MySQL databases are seeing active changes versus those tables that are less frequently updated or entirely static. To do this, we need to examine DML (Data Manipulation Language) activity—specifically, updates, inserts, and deletes. MySQL offers various mechanisms to gather this information. This blog will explore two primary […]

MySQL Operator for Kubernetes? The MySQL Operator for Kubernetes supports the lifecycle of a MySQL InnoDB Cluster inside a Kubernetes Cluster. This goes from simplifying the deployment of MySQL Server and MySQL Router instances, including management of TLS certificates and replication setup, over ongoing management of those as well as support for backups, be it […]

Security is a foundational principle for cloud deployments, especially when dealing with mission-critical workloads like those managed by HeatWave MySQL. As applications and environments scale, fine-grained network control becomes critical not just for protecting sensitive data, but also for isolating systems, enforcing boundaries, and minimizing lateral movement within a Virtual Cloud Network (VCN). Network Security […]

In today’s fast-paced digital landscape, uninterrupted availability of IT infrastructure isn’t just a luxury—it’s a fundamental necessity for businesses to thrive. Downtime, whether planned or unplanned, carries a hefty price tag, impacting everything from customer relationships to competitive edge. This is where the MySQL Reference Architectures for High Availability steps in, offering a robust framework […]

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

MySQL Group Replication is a powerful feature that allows you to create a fault-tolerant and redundant database system, ensuring high availability and data consistency across multiple servers. The primary goal of this technology is to provide automatic failover and improve the overall system’s reliability. If one of the servers in the group fails, the others […]