As MySQL HeatWave environments continue to grow, many organizations prioritize scaling compute and storage resources while overlooking a critical area: database housekeeping. Inadequate maintenance practices can result in excessive storage consumption, longer backup and recovery times, replication lag, degraded query performance, and increased operational costs. This blog highlights key database hygiene and optimization strategies for […]

Organizations modernizing transactional database environments are increasingly adopting MySQL HeatWave to simplify operations, improve scalability, increase availability, enhance security and enable real-time analytics without separating OLTP and OLAP systems. However, successful adoption requires more than simply provisioning a new database instance. This blog explores practical best practices for provisioning and migrating OLTP and OLAP workloads […]

As organizations modernize their data platforms, MySQL HeatWave has emerged as a powerful solution for running online transactional processing (OLTP) and real-time online analytics processing (OLAP) together without ETL complexity. However, achieving optimal performance and cost efficiency requires thoughtful capacity planning. This blog explains how to monitor and estimate MySQL HeatWave capacity using SQL queries, […]

Modern cloud applications are expected to remain available even during infrastructure interruptions, replication failovers, maintenance events, and transient network failures. In distributed database environments, it requires applications to treat transient failures as a normal part of production operations. This blog discusses practical API reliability designs for applications using MySQL HeatWave High Availability and Read Replicas, […]

Many applications start with a simple database setup: create one MySQL user, give it access to the application schema, put the credentials in the app config, and move on. That may work at first, but it is not a good long-term security model. A better approach is to use separate MySQL users for separate application […]

Once you move from self-managed MySQL to a MySQL DB System with HeatWave on OCI, the tuning story changes in an important way. On a self-managed server, you worry about two layers: MySQL and the operating system. On OCI MySQL DB Systems with HeatWave, Oracle runs your MySQL instance as a fully-managed service and explicitly […]

MySQL HeatWave Service on Oracle Cloud Infrastructure (OCI) provides built-in telemetry and logging capabilities that help organizations monitor database activity, troubleshoot issues, and maintain operational health. These logs are valuable not only for operations and performance tuning, but also for governance and regulatory compliance, where audit logging can be essential for tracking database activity and […]

Announcing MySQL HeatWave Telemetry data publishing into OCI Log Analytics — the easiest way to view , analyze the MYSQL Heatwave Logs New build-in feature to publish the MySQL Logs to OCI Log Analytics Telemetry Data: The Following data will be published based on the user selection1. Error log: Contains a record of mysqld startup and shutdown […]

Moving from Ops Insights/Database Management to OCI Monitoring and Unified Log Analytics OCI is updating the recommended approach for observing MySQL HeatWave. This includes changes to existing integrations, along with a path forward that provides stronger log analytics and AI-assisted analysis—while continuing to use OCI Monitoring as the foundational layer for metrics and alarms. What’s […]

In the world of database management, MySQL HeatWave offers powerful in-memory analytics capabilities that can supercharge your OLTP queries. But what happens when you introduce views into the mix? A common question I get is: “If I create a view in MySQL, does this view run against the data stored in the tables in HeatWave […]