We’re introducing a powerful set of enhancements aimed at boosting service availability and manageability thereby simplifying migrations from AWS Aurora, RDS, or MySQL on EC2, and improving performance.
Before diving into the updates, here’s a quick refresher: MySQL HeatWave on AWS runs natively on AWS infrastructure, with every component—from the service console to the control and data planes—built and optimized for AWS. This native integration delivers ultra-low latency, seamless performance, and exceptional price-performance for applications already deployed in AWS.
Support for MySQL high availability
MySQL HeatWave on AWS now supports high availability, enabling applications to achieve a 99.99% SLA with zero data loss for OLTP workloads.
A high availability DB system is built using three MySQL instances deployed across different Availability Zones, ensuring fault isolation and redundancy. These instances use MySQL Group Replication to keep data synchronized in real time.
Applications connect to a single endpoint for both reads and writes. In the event of a failure, the service automatically performs a seamless failover within minutes to a secondary instance—with no data loss and without any need to reconfigure the application.
See High availability.
Enhancements in monitoring capabilities: From Console to CloudWatch
MySQL HeatWave on AWS provides built-in monitoring capabilities through an intuitive console, offering immediate visibility into key metrics such as CPU usage, memory consumption, storage capacity, and buffer pool size. This monitoring is enabled by default, so you can start tracking your instance as soon as it’s created—no setup required.
Now, MySQL HeatWave on AWS extends its monitoring capabilities by integrating with Amazon CloudWatch, allowing you to view many additional metrics and track its history over time. With this integration, you can build customized dashboards for a centralized view, complementing the pre-built dashboards in the MySQL HeatWave Console. CloudWatch also enables you to define thresholds for key HeatWave metrics and receive alerts when those thresholds are breached.
With metrics available in both the MySQL HeatWave Console and Amazon CloudWatch, you gain a comprehensive view of your system’s health. This makes it easier to monitor application performance, troubleshoot issues, and proactively optimize resources.
Improved performance with new in-database LLMs
MySQL HeatWave GenAI now supports a broader range of in-database large language models (LLMs), delivering significant gains in response time and overall performance. By running these models directly within MySQL HeatWave, you avoid data movement and extra costs associated with external services.
The result is faster, lower-latency responses for tasks such as text summarization and content generation—making GenAI-powered applications more cost-effective, and efficient.
New in-database LLMs supported since MySQL 9.3.1:
- llama3.1-8b-instruct-v1
- mistral-7b-instruct-v3
- llama3.2-3b-instruct-v1
- llama3.2-1b-instruct-v1
Export query results to Amazon S3
MySQL HeatWave now supports writing query results directly to Amazon S3. With this feature, MySQL HeatWave becomes not only a high-performance analytics engine, but also a fast transformation engine.
When running a query in MySQL HeatWave, you can specify Amazon S3 as the destination for the query output. MySQL HeatWave processes the query, formats the results according to user-defined settings (e.g., CSV, Parquet), and writes them to the specified S3 location.
This capability enables a wide range of new use cases:
- Transform data at any scale – from small datasets to massive ones – using simple or complex analytic queries.
- Build silver and gold layers of a medallion architecture by creating and exporting aggregate tables.
- Convert data formats on the fly—for example, query data stored in CSV and output it in Parquet.
- Archive cold data to Amazon S3 to reduce costs while maintaining accessibility.
See Creating Lakehouse Mapping.
New capabilities for smaller workload
MySQL HeatWave GenAI is now available on the new HeatWave.16GB shape, making it easier to explore Generative AI capabilities with smaller workloads. See MySQL HeatWave GenAI Requirements.
MySQL HeatWave Lakehouse also supports the HeatWave.16GB shape, giving you more flexibility in how you run analytics on smaller datasets. For larger or more demanding use cases, the HeatWave.256GB shape remains the recommended option.
Support for AWS PrivateLink
Customers who want to connect their Services or VPC to MySQL HeatWave on AWS on a private network can now use AWS PrivateLink. This enhances security and ensures the data does not transit the public internet.
With this support, you can perform the following:
- Live migrate existing deployment on a private network from MySQL on EC2, RDS, or Aurora to MySQL HeatWave on AWS.
- Hybrid deployments that are ideal for scenarios where you cannot move your OLTP workload to HeatWave but still want to take advantage of HeatWave’s powerful features such as analytics, Lakehouse, AutoML, and GenAI. See Deploying an Egress PrivateLink.
- Connect your applications running in your VPC to MySQL HeatWave. See Deploying a Query PrivateLink.
Expanded region availability
MySQL HeatWave on AWS continues to grow with an expanded regional footprint, enabling you to deploy closer to your workloads. This reduces latency, improves performance, and eliminates inter-region data transfer costs.
MySQL HeatWave on AWS is now available in the following additional regions:
- Mexico Central (Queretaro)
- US West (Oregon)
- Asia Pacific (Seoul)
These new additions join the existing regions:
- US East (N. Virginia)
- Europe (London, Frankfurt)
- Asia Pacific (Tokyo, Mumbai)
See Region Availability.
Try out MySQL HeatWave on AWS for free
Get started with MySQL HeatWave on AWS using the Oracle Cloud Free Tier Account. You’ll receive $300 in free credits to explore MySQL HeatWave on AWS for up to 30 days. It’s also available across all OCI commercial regions, Oracle Alloy, and cloud@customer environments.
Let us know what you’re building with MySQL HeatWave on AWS—we’re excited to see what you create!
Additional Resources