MySQL Autopilot uses advanced machine learning techniques to automate HeatWave which make it easier to use and further improves performance and scalability. MySQL Autopilot automates many of the most important and often challenging aspects of achieving high query performance at scale—including provisioning, data loading, query execution and failure handling. No other cloud vendor provides such advanced automation capabilities for their database offerings. MySQL AutoPilot provides machine-learning–based automation which helps configure, optimize, and tune MySQL HeatWave. Autopilot uses data and queries from the application workload in the machine learning model to make predictions. It enables customers to optimally provision, load, execute queries, and recover from failure without requiring any human intervention.

HeatWave offers better performance at a lower price for analytics and mixed workloads compared to all other competitive database and analytics cloud services. Specifically, HeatWave has:

• 13 times better price/performance than Amazon Redshift with AQUA—6.5 times faster at half the cost (TPCH 10TB)
• 35 times better price/performance than Snowflake—7 times faster at 1/5 the cost (TPCH 10TB)
• 36 times better price/performance than Google Big Query—9 times faster at 1/4 the cost (TPCH 30TB)
• 15 times better price/performance than Azure Synapse—3 times faster at 1/5 the cost (TPCH 30TB)
• 42 times better price/performance than Amazon Aurora for mixed workloads—18 times lower latency, and 110 times higher throughput at 42 percent the cost (CH-benCHmark 100G)

MySQL HeatWave offers significant performance advantages and cost savings:

• 5400X faster than Amazon RDS for MySQL at two-thirds the cost, resulting in 8100X better price performance.
• 1100X faster than Amazon Aurora at half the cost, resulting in 2200X better price performance.
• 7X faster than Amazon Redshift at half the cost, resulting in 13X better price performance.
• 7X faster than Snowflake at one-fifth the cost, resulting in 35X better price performance.

All the MySQL HeatWave benchmark scripts are available on GitHub. Learn more at https://www.oracle.com/heatwave/

When data is loaded from MySQL to HeatWave for the first time, a copy of the in-memory representation is made to the HeatWave scale-out data management layer. When an operation requires reloading of data to HeatWave, such as during error recovery, data can be accessed in parallel from the HeatWave data layer by multiple HeatWave nodes. This results in significant improvement in overall performance. In the largest Oracle Cloud Infrastructure (OCI) regions, a 10TB HeatWave cluster can now be reloaded in 4 minutes compared to 7.5 hours—over a 100X improvement.

No changes are required to existing MySQL applications. All applications work as-is. Queries that benefit from HeatWave are transparently offloaded and accelerated.

All existing BI tools that work with MySQL—such as Tableau, Looker, Qlik, PowerBI, and OAC—will tremendously benefit from the query acceleration of HeatWave.

Yes, MySQL Database Service with HeatWave is the only service that enables database administrators and app developers to run online transaction processing (OLTP) and online analytical processing (OLAP) workloads directly from their MySQL database. This eliminates the need to extract, transform, and load (ETL) from MySQL to an external analytics database. MySQL HeatWave performance for mixed workloads is significantly better than Aurora and half the cost.

Yes, MySQL Shell makes it easy to migrate from Amazon RDS, Aurora, or Redshift to MySQL HeatWave. Many customers have successfully migrated their databases to MySQL HeatWave. Learn more at https://blogs.oracle.com/mysql/migrate-from-amazon-aurora-to-mysql-database-service-and-start-saving.

MySQL HeatWave is available for a free 30 day trial. Sign up at https://www.oracle.com/cloud/free.