Oracle has announced that MySQL HeatWave, a service that combines OLTP, analytics, machine learning, and machine learning-based automation within a single MySQL database, is available on AWS. AWS users can now run transaction processing, analytics, and machine learning workloads in one service, without requiring time-consuming ETL duplication between separate databases such as Amazon Aurora for transaction processing and Amazon Redshift or Snowflake on AWS for analytics and SageMaker for machine learning.
According to the company, MySQL HeatWave on AWS is optimized for AWS with a superior architecture that delivers higher performance and lower cost compared to competitive offerings, as demonstrated by industry standard benchmarks.
MySQL HeatWave on AWS delivers a true native experience for AWS customers through millisecond-level latencies for applications and a rich interactive console. It facilitates schema and data management, and executes queries interactively from the console. Users can monitor the performance of their queries and monitor the utilization of the provisioned resources. MySQL Autopilot is also integrated with the interactive console, making it easier to use.
MySQL HeatWave service now offers several comprehensive security features which provide additional differentiation with Amazon Aurora. These include server-side data masking and de-identification, asymmetric data encryption, and a database firewall.
Oracle is introducing additional Autopilot capabilities designed for OLTP workloads which further improve MySQL HeatWave price performance compared to Amazon Aurora.
HeatWave ML fully automates the ML lifecycle and stores all trained models inside the MySQL database, eliminating the need to move them to a separate machine learning tool or service.