Oracle has announced availability of MySQL Autopilot, a new component of MySQL HeatWave service, the in-memory query acceleration engine for MySQL Database Service in Oracle Cloud Infrastructure (OCI). MySQL Autopilot uses advanced machine learning techniques to automate HeatWave which makes it easier to use and further improves performance and scalability.
MySQL Autopilot automates many of the most important and challenging aspects of achieving high query performance at scale—including provisioning, data loading, query execution and failure handling. It uses advanced techniques to sample data, collect statistics on data and queries, and build machine learning models using Oracle AutoML to model memory usage, network load and execution time. These machine learning models are then used by MySQL Autopilot to execute its core capabilities.
According to Oracle, MySQL Autopilot makes the HeatWave query optimizer increasingly intelligent as more queries are executed, resulting in continually improving system performance over time—a capability not available on Amazon Aurora, Amazon Redshift, Snowflake, or other MySQL-based database services.
“Oracle’s MySQL Database Service with HeatWave is the only MySQL database that efficiently supports both OLTP and OLAP, enabling users to run mixed workloads or real-time analytics against their MySQL database with 10 to 1,000 times better performance and less than half the cost compared to other analytical or MySQL-based databases,” said Edward Screven, chief corporate architect, Oracle. “MySQL HeatWave is one of the fastest growing cloud services on OCI and an increasing number of customers are moving their MySQL workloads to HeatWave. Today, we are announcing a number of innovations which are the result of years of research and advanced development at Oracle. The combination of these innovations delivers massive improvements in automation, performance and cost—further distancing HeatWave from other database cloud services.”
As part of this announcement, Oracle is also introducing MySQL Scale-out Data Management, which can improve the performance of reloading data into HeatWave by up to 100 times. HeatWave now supports a cluster size of 64 nodes—up from 24 nodes—and is capable of processing up to 32TB of data—up from 12TB. These new enhancements further strengthen the price/performance advantages of HeatWave relative to its primary competitors.
Oracle is making the benchmarking code publicly available, enabling customers to run the benchmarks themselves by visiting here. Oracle also announced that the industry standard TPC-DS benchmark can now be accelerated using HeatWave.
The new features introduced in the latest MySQL HeatWave release are available now on OCI across all 30 Oracle Cloud Regions.