Oracle is today moving forward with its announced plans to make its MySQL HeatWave database management systems available on Amazon Web Services Inc.’s cloud.
MySQL HeatWave is a major upgrade to the popular open-source database engine that combines online transaction processing, analytics, machine learning, and machine learning-based automation into a single mysql instance. Oracle said the new features, introduced two years ago, eliminate the need for fetch/transfer/load duplication between separate databases such as Amazon Aurora for transaction processing and Amazon Redshift for analytics. .
Oracle said the new offering is optimized for AWS and provides superior economy to services from Amazon and others. He cited a 4 terabyte TPC-H benchmark which he said showed that MySQL HeatWave performed seven times better than Redshift and 10 times better than Snowflake Inc.’s cloud data warehouse. machine learning performs 25 times better than Redshift ML.
MySQL HeatWave on AWS provides millisecond latencies for applications and a comprehensive console that makes it easy to manage schemas and data and execute queries interactively. MySQL Autopilot, a component that uses machine learning techniques to automate many HeatWave features, is included with the console. Its features include automated provisioning, parallel loading, encoding, data placement, scheduling, query plan enhancement, change propagation, and error handling.
Although Oracle and AWS compete in the public cloud, Oracle has always said that HeatWave will be available on other cloud platforms. AWS customers who want to use the platform face “several challenges, including exorbitant data egress fees charged by AWS, high database access latency from applications running on AWS and the need to integrate with other applications running in AWS,” Nipun said. Agarwal, senior vice president of research and advanced development at Oracle.
HeatWave is a central part of what Oracle calls a distributed cloud strategy that will make the engine available across multiple clouds as well as on-premises as part of Oracle Dedicated Region Cloud@Customer. “Customers can also replicate data from their on-premises MySQL OLTP applications to MySQL HeatWave on AWS or Oracle Cloud Infrastructure for near real-time analytics,” Agarwal said. “MySQL HeatWave always runs the latest version of the MySQL database, which most other MySQL-based services don’t.”
Oracle also said the offering does not compete with its own standalone database. The two “address very different markets,” Agarwal said. “MySQL HeatWave supports popular open source web applications such as WordPress, Magento, and Drupal, while Autonomous Database supports Oracle Fusion Cloud SaaS applications. HeatWave is currently intended for open source cloud database users and developers with databases under 50 terabytes [while] The autonomous database can scale to virtually unlimited levels. »
MySQL HeatWave has also been beefed up with new security features, including server-side data masking, anonymization, asymmetric data encryption, and a database firewall. Asymmetric data encryption allows developers and database administrators to use digital signatures to confirm the identity of people signing documents, Oracle said. The database firewall provides real-time protection against database-specific attacks, such as SQL injections.
HeatWave ML, which is an optional feature provided free of charge, provides in-database machine learning capabilities for training, inference, and explanations to enable customers to safely use machine learning on real-time data without ETL, Oracle said. HeatWave ML automates the machine learning lifecycle and stores all trained models in the MySQL database, eliminating the need to move them to a separate machine learning tool or service.
Although MySQL’s core engine is available under an open source license, “HeatWave is designed and optimized specifically for the cloud and as such is not open source,” Agarwal said.