Oracle’s MySQL Heatwave is now available on Amazon Web Services
MySQL Heat wavecombined OLTP(online transaction processing), analytics, machine learning, and machine learning-based automation within a single MySQL database.
- It allows
AWSusers to run transaction processing, analytics, and machine learning workloads in a single service, without requiring tedious duplication between separate databases. Oraclealso adds new features and benchmarks for the service on AWS, such as autopilot and security features.
Software giant Oracle said Friday that MySQL Heatwave is now available on Amazon Web Services (AWS). MySQL Heatwave combines OLTP (online transaction processing), analytics, machine learning, and machine learning-based automation in a single MySQL database.
This service allows AWS users to run transaction processing, analytics, and machine learning workloads in a single service, without requiring tedious duplication between separate databases such as Amazon Aurora to transaction processing and Amazon Redshift or Snowflake on AWS for analytics and SageMaker for machine learning. , Oracle said in a statement.
“We wanted to broaden the horizon and facilitate faster innovation for the country. Now that AWS users can take advantage of the various benefits of MySQL, all MySQL HeatWave functionality is delivered natively on AWS, so these data transfers and associated high egress charges will no longer be necessary. For AWS application users using MySQL implementations other than HeatWave, they can now upgrade to MySQL HeatWave, without having to change a single line of code,” said P Saravanan, VP, Cloud Engineering, Oracle India.
Oracle is also adding new features and benchmarks for the service on AWS. MySQL HeatWave on AWS is optimized to deliver higher performance and lower costs compared to competing offerings, the company said. To illustrate, on the 4TB TPC-H benchmark, MySQL HeatWave on AWS offers price performance 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 added a few additional security features, which provide further differentiation with Amazon Aurora, he added. These include server-side data masking and anonymization, asymmetric data encryption, and a database firewall.
It has also rolled out an Autopilot feature, which provides machine learning-based, workload-aware automation of various aspects of the application lifecycle, including provisioning, data management , query execution and fault handling, the company said.
“MySQL HeatWave on AWS simplifies our data platform with a consolidated database for transaction processing and analysis. We’ve seen complex queries 60-90x faster compared to AWS RDS and Aurora that generate the real-time analytics we need for targeted multi-channel campaigns. We now have greater scalability to integrate more data and new customers of all sizes without increasing IT administration,” said Thomas Henz, Managing Director of Germany’s digital agency for the web and app development company. .
Property demand could be hit this festive season after RBI rate hike
RBI interest rate hikes not over yet, but intensity could ease