Tuesday, August 10, 2021 | Original broadcast
HeatWave is a tightly integrated, high performance, in-memory query accelerator for the MySQL Database Service. It allows customers to run very fast analytics queries directly against their MySQL databases entirely avoiding the step of data ETL into a second analytics database. HeatWave scales out to thousands of cores, is 1,100 times faster at query performance than Amazon Aurora, and is 2.7 times faster than Amazon Redshift—at one-third the cost.
Learn about a series of powerful innovations to the MySQL Database Service that will increase automation, further improve performance vs. a number of competitors, and increase the set of workloads that are accelerated by HeatWave.
Edward Screven, Chief Corporate Architect, Oracle
Nipun Agarwal, Vice President, MySQL HeatWave and Advanced Development, Oracle
Pablo Lemos, Co-Founder, CTO, Tetris.co (Brazil)
Nipun Agarwal walks through several of the exciting Autopilot features of MySQL HeatWave which help increase automation, provide higher performance, and lower costs.
Discover how Tetris.co, the Brazilian MarTech company, accelerates marketing insights in milliseconds and at half the costs with MySQL HeatWave on Oracle Cloud Infrastructure compared to AWS Aurora and RedShift.
Discover how Japan’s leading advertising network delivers real-time insights for performance-based marketing and significantly reduced costs with MySQL HeatWave on Oracle Cloud Infrastructure after migrating from AWS Aurora.
The Brazilian martech company accelerates marketing insights in milliseconds and at half the cost with MySQL HeatWave on Oracle Cloud Infrastructure.
Digital marketing firm accelerates media and advertising insights by 1,000X and saves 60% in costs using MySQL HeatWave on Oracle Cloud Infrastructure.
Japan's leading advertising network delivers real-time insights and significantly reduced costs with MySQL HeatWave and Autonomous Database.
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:
MySQL HeatWave offers significant performance advantages and cost savings:
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.