In traditional MySQL, analytics require data to be ingested into InnoDB tables and processed on a single primary instance using row-based storage engine and limited parallelism. Scaling analytical workloads typically involves replicas, ETL pipelines, or even external analytics system.  With MySQL HeatWave, Oracle’s fully managed service in the cloud, analytics execution is offloaded to a […]

In traditional MySQL, analytics require data to be ingested into InnoDB tables and processed on a single primary instance using row-based storage engine and limited parallelism. Scaling analytical workloads typically involves replicas, ETL pipelines, or even external analytics system.  With MySQL HeatWave, Oracle’s fully managed service in the cloud, analytics execution is offloaded to a […]

We are pleased to introduce the ability to export MySQL HeatWave backup data directly to an OCI Object Storage bucket in your tenancy, enabling a one-step process to create an exported backup via the Console or API. This process creates a logical dump from the backup without utilizing DB system resources, thereby minimizing the impact on the […]

MySQL 8.0 is scheduled for End of Life (EOL) in April 2026. In line with this milestone, we previously announced in this Oracle blog post that all existing MySQL HeatWave instances running version 8.0 would be automatically upgraded to the latest supported 8.4 release after April 2026. However, understanding the operational realities and planning cycles […]

MySQL Studio in Oracle Cloud Infrastructure MySQL Studio in Oracle Cloud Infrastructure (OCI) is a unified environment for working with MySQL and HeatWave features through a single, streamlined interface. It brings SQL authoring, AI-assisted chat, and Jupyter-compatible notebooks together with project-based organization to help teams get from database setup to productive analytics faster. The same […]

Managing large datasets can be a balancing act between performance and storage. Keeping your “hot” data lean is critical for speed and memory efficiency. But what about the “cold” data you still need to retain? Partition Exchange Archiving a simple, production-ready strategy that lets you instantly move old data out of your primary tables without […]

We have reached the end of our series on deploying to OCI using the Hackathon Starter Kit. For this last article, we will see how to deploy an application using Helidon (Java), the MySQL REST Service, and OCI GenAI with Lanchain4J. We use Helidon because it’s a cool, open-source framework developed by Oracle. It’s lightweight […]

Welcome to the 20th installment of the 2025 MySQL Community Advent Calendar of Content! For this entry, we are highlighting season 3 of the Inside MySQL: Sakila Speaks podcast, which was dedicated to all things artificial intelligence (AI) and its impact on MySQL. Across five insightful episodes, Scott, Fred, and a range of expert guests […]

The starter kit deploys a MySQL HeatWave DB System on OCI (see previous posts [1],[2],[3],[4],[5],[6],[7]) and enables the MySQL REST Service automatically: The REST Service enables us to provide access to data without requiring SQL. It also provides access to some Gen AI functionalities available in MySQL HeatWave. Adding data to MRS using Visual Studio […]

We saw in part 6 how to use OCI’s GenAI Service. GenAI Service uses GPUs for the LLMs, but did you know it’s also possible to use GenAI directly in MySQL HeatWave? And by default, those LLMs will run on CPU. The cost will then be reduced. This means that when you are connected to […]