Oracle Announces MySQL HeatWave ML

AUSTIN, Texas, March 29, 2022 — Oracle today announced that Oracle MySQL HeatWave now supports in-database machine learning in addition to the previously available transaction processing and analytics—the only MySQL cloud database service to do so. This level of integration enables customers to securely use real-time data without the complexity, latency, and cost of ETL duplication. HeatWave ML fully automates the ML lifecycle and stores all trained models inside the MySQL database, eliminating the need to move them to a machine learning tool or service using data movers and connectors. HeatWave ML is available today at no additional charge for MySQL HeatWave customers in all OCI regions.

No other cloud database vendor or open-source database provides such advanced ML capabilities inside the database. For the first time in the industry, Oracle published ML benchmarks performed across a large number of publicly available classification and regression datasets. On average, HeatWave ML trains models 25 times faster, at 1 percent of the cost of Redshift ML, and scales with cluster size. MySQL HeatWave customers can now train models more often and keep them updated for increased prediction accuracy.

“Just as we integrated analytics and transactional processing within a single database, we are now bringing machine learning inside MySQL HeatWave,” said Edward Screven, chief corporate architect, Oracle. “MySQL HeatWave is one of the fastest growing cloud services at Oracle. An increasing number of customers have migrated from Amazon and other cloud database services to MySQL HeatWave because of the significant performance gains and lower costs. Today, we are also announcing a number of other innovations which enrich HeatWave features, improve availability and lower the cost. Our new and fully transparent benchmark results again demonstrate that Snowflake, AWS, Microsoft, and Google are slower and more expensive than MSQL HeatWave.”

HeatWave ML saves customers time and effort by fully automating the ML lifecycle inside the database, including pre-processing of data, algorithm selection, intelligent data sampling, feature selection, and hyper-parameter tuning. HeatWave customers now can accelerate ML initiatives securely at no additional charge or need for data scientists. In addition, all models trained by HeatWave ML are explainable, improving regulatory compliance, fairness, repeatability, causality, and increasing trust in machine learning.

New Benchmark Results Reinforce MySQL Heatwave Superior Price Performance 

Industry standard 10TB TPC-DS* benchmark results prove how other cloud services are slower and more expensive than MySQL HeatWave:

• Snowflake: 14.4 times slower and more expensive
• Amazon Redshift: 4.8 times slower and more expensive
• Azure Synapse: 14.9 times slower and more expensive
• Google BigQuery: 12.9 times slower and more expensive

These new TPC-DS* results follow last year’s TPC-H benchmark results that demonstrated that MySQL HeatWave is up to 7 times faster than Snowflake on AWS at 1/5 the cost and 6.5 times faster than Amazon Redshift with AQUA at half the cost. The TPC-DS benchmark includes more queries with more complex schemas. The benchmarking code for machine learning and TPC-DS is publicly available once again, enabling customers to run the benchmarks themselves by visiting here.

In addition to MySQL HeatWave ML, Oracle also released additional innovations, including real-time elasticity, which enables customers to upsize and downsize their HeatWave cluster to any number of nodes, without any downtime or read-only time and without the need to manually rebalance the cluster.  Also included is Data compression, which enables customers to process 2 times the data per node and lowers costs by nearly 50 percent, while maintaining the same price performance ratio. And a new Pause-and-resume function, which enables customers to pause HeatWave to save costs. Upon resuming, both the data and the statistics needed for MySQL Autopilot are automatically reloaded into HeatWave. The new features introduced in the latest MySQL HeatWave release are available now on OCI across all 37 Regions.

Customer and Partner Momentum on MySQL Heatwave

Astute Business Solutions is an Oracle PartnerNetwork software provider. “We recently had an opportunity to use the machine learning capabilities of HeatWave ML. We found it very innovative, easy-to-use, very fast and most important it is secure since the data or the model don’t leave the database,” said Arvind Rajan, Co-Founder and CEO of Astute Business Solutions. “We believe that providing in-database machine learning is of significant interest to our clients and will further accelerate the adoption of MySQL HeatWave.”

Estuda.com is an educational SaaS provider for K-12 student testing in Brasil. “MySQL HeatWave improved our complex query performance by 300x for responses in seconds and at 85% of the cost compared to Google BigQuery with no code changes. Now we can better deliver real-time analytics at a scale of 3 million users and continually improve our application to enhance student performance,” said Vitor Freitas, Co-founder and CTO, Estuda.com.

VRGlass is a Brasilian SaaS producer of metaverse apps and equipment for corporate clients.

“Motivated by the progress achieved within the Oracle for Startup program, VRGlass migrated all application data to MySQL HeatWave from AWS EC2. Within three hours, we achieved a 5x increase in database performance for a virtual event that accommodated more than 1 million visitors and 1.7 million sessions with greater security and at the half the cost,” said Ohmar Tacla, CEO, VRGlass.

Genius Sonority is video game designer, developer, and operator in Japan. “We found MySQL HeatWave improved performance by 90X which solved all our challenges and concerns we had in moving data to realize real-time analysis. It was a big surprise for us.  The extreme performance improvements help us to continually improve the gaming experience for joyful entertainment to customers around the world,” said Masayuki Kawamoto, Director, CTO, Genius Sonority.

Neovera is a trusted provider of managed cybersecurity solutions for more than 20 years. “MySQL HeatWave on OCI increased our query performance by 300X with an 80% TCO reduction compared to our on-premises MySQL database environment. Now we can get real-time analytical reporting within our OLTP database to accelerate enhancing our security application,” said Arman Rawls, Sr. Oracle Database Architect, Neovera Inc.

“Oracle announced MySQL HeatWave with Autopilot last August, which may very well have been the single greatest innovation in open source cloud databases in the last 20 years to that point,” said Carl Olofson, Research Vice President, Data Management Software, IDC. “Now Oracle has gone beyond its original unifying of OLTP and OLAP in HeatWave, with MySQL HeatWave ML. Oracle is bringing all of the machine learning processing and models inside the database, so that customers not only avoid managing ML databases apart from the core database, but also eliminate the hassles of ETL, gaining speed, accuracy, and cost-effectiveness in the bargain.”

Source: Oracle