MySQL Heatwave combinesOLTP (online transaction processing), analytics, machine learning, and machine learning-based automation within a single MySQL database.- It allows
AWS users to run transaction processing, analytics, and machine learning workloads in one service, without requiring time-consuming duplication between separate databases. Oracle is also adding new capabilities and benchmarks for the service on AWS such as autopilot and security features.
This service allows AWS users to run transaction processing, analytics, and machine learning workloads in one service, without requiring time-consuming duplication between separate databases such as Amazon Aurora for transaction processing and Amazon Redshift or Snowflake on AWS for analytics and SageMaker for machine learning, Oracle said in a statement.
“We were keen to expand the horizon and facilitate faster innovation for the country. Now, with users of AWS being able to leverage the various benefits of MySQL, all the capabilities of MySQL HeatWave are delivered natively on AWS, so such data transfers and associated high egress fees will no longer be necessary. For users with AWS applications using non-HeatWave implementations of MySQL, they can now upgrade to MySQL HeatWave, without needing to change a single line of code,” said P Saravanan, vice president, cloud engineering, Oracle India.
Oracle is also adding new capabilities and benchmarks for the service on AWS. MySQL HeatWave on AWS is optimised to deliver higher performance and lower cost compared to competitive offerings, the company said. To illustrate, on the 4TB TPC-H benchmark, MySQL HeatWave on AWS delivers price performance that is 7X better than Amazon Redshift, 10X better than Snowflake, 12X better than Google BigQuery, and 4X better than Azure Synapse. For machine learning, MySQL HeatWave on AWS is 25X faster than Redshift ML, the company said in a statement.
It has added some more security features, which provide additional differentiation with Amazon Aurora, it added. These include server-side data masking and de-identification, asymmetric data encryption, and a database firewall.
It has also rolled out an autopilot feature, which provides workload-aware, machine learning-based automation of various aspects of the application lifecycle, including provisioning, data management, query execution, and failure handling, the company said.
“MySQL HeatWave on AWS simplifies our data platform with a consolidated database for both transaction processing and analytics. We have seen 60-90X faster complex queries compared to AWS RDS and Aurora that generate real-time analytics we need for targeted, multichannel campaigns. We now have greater scalability to onboard more data and new clients of any size without increasing IT administration,” said Thomas Henz, chief executive officer of Germany-based digital agency for web and app development firm
SEE ALSO: