Oracle’s MySQL HeatWave, a MySQL cloud service for analytics and mixed workloads, is now available in the Amazon Web Services (AWS) cloud and will also be available on the Microsoft Azure cloud in the near future, the company said.
MySQL is the most popular Open-Source Relational SQL database management system.Oracle introduced HeatWave in May 2021. It lets users run Online Transaction Processing (OLTP), and Online Analytical Processing (OLAP) workloads directly from a single MySQL database.
Commenting on its availability in the India market, P. Saravanan, vice-president, cloud engineering, Oracle India, said, “AWS applications using non-HeatWave implementations of MySQL, they can now upgrade to MySQL HeatWave, without needing to change a single line of code. We are sure that it will pave a way towards an exceptional customer experience.”
In other words, AWS users can now run transaction processing, analytics, and machine learning workloads in one service, without requiring time-consuming extract transform and load (ETL) duplication - data integration process that combines data from multiple data sources into a single, consistent data store that is loaded into a data warehouse - between separate databases such as Amazon Aurora for transaction processing and Amazon Redshift or Snowflake on AWS for analytics and SageMaker for machine learning.
“In India, MySQL has been a critical element in the digitization journey of many of the organizations be it startups, digital native, enterprise and public sector and we are keen to expand the horizon and facilitate faster innovation for the country,” said Sarvanan.
A key factor in managing cloud computing costs is the cloud egress charge. With cloud data transfers, a customer doesn't pay for data when it goes in; the transfer charges occur when data goes out. And these egress costs can add up fast. However, Edward Screven, chief corporate architect, Oracle, said, “With the latest announcement, we aim to reduce data egress fees charged by AWS leading to improved efficiency, cost effectiveness and better performance for the customers.”
MySQL HeatWave also offers comprehensive security features, Oracle said, including server-side data masking and de-identification, asymmetric data encryption, and a database firewall.
The largest cloud companies in the world—from Microsoft, Amazon Web Services, and Google to Oracle and IBM—are battling for leadership position in the growing database management systems industry as the overall market continues to shift to the cloud.
Analyst firm Gartner predicts that cloud database management systems will account for a whopping 75% of all databases by 2022-end. This trend will largely be due to databases used for analytics, and the SaaS model. In 2021, revenue for managed cloud services (dbPaaS) rose to $39.2 billion, and it now represents over 49% of all DBMS revenue, said Gartner.