AWS users can now run transaction processing, real-time analytics, and machine learning in one service with MySQL
MySQL HeatWave delivers 7X better price performance compared to Amazon Redshift and 10X better than Snowflake, 25X faster than Redshift ML, and up to 10X higher throughput than Aurora
Oracle today announced that MySQL HeatWave is available on Amazon Web Services (AWS). MySQL HeatWave is the only service that combines OLTP, analytics, machine learning, and machine learning-based automation within a single MySQL database. AWS users can now run transaction processing, analytics, and machine learning workloads in one service, without requiring time-consuming ETL 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 believes in giving customers a choice. Many of our MySQL HeatWave customers migrated from AWS. Others wish to continue running parts of their application on AWS. Those customers face serious challenges including exorbitant data egress fees charged by AWS and higher latency when accessing a database service running in Oracle’s cloud,” said Edward Screven, chief corporate architect, Oracle. “We are addressing these issues while delivering outstanding performance and price performance across transaction, analytics, and machine learning compared to other database cloud providers—even Amazon’s own databases running on AWS, where you’d think they would have an advantage. We wanted to offer AWS customers this choice to benefit from MySQL HeatWave innovation without moving their data from AWS, or developers needing to learn a new platform.”
Johnny Bytes is an innovative digital agency for web and app development based in Germany. “MySQL HeatWave on AWS simplifies our data platform with a consolidated database for both transaction processing and analytics,” said Thomas Henz, chief executive officer, Johnny Bytes. “We have seen 60-90X faster complex queries compared to AWS RDS and Aurora that generates 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.”
As part of today’s news, Oracle is also introducing several new capabilities and benchmarks for MySQL HeatWave on AWS.
- Unmatched performance and price performance: MySQL HeatWave on AWS is optimized for AWS with a superior architecture that delivers higher performance and lower cost compared to competitive offerings, as demonstrated by industry standard benchmarks. 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. On a 10GB TPC-C* workload, MySQL HeatWave offers up to 10X higher and sustained throughput compared to Amazon Aurora at high concurrency. All of these fully transparent benchmark scripts are available on GitHub for customers to replicate.
- Native AWS experience: MySQL HeatWave on AWS delivers a true native experience for AWS customers through millisecond-level latencies for applications and a rich interactive console. It facilitates schema and data management, and executes queries interactively from the console. Users can monitor the performance of their queries and monitor the utilization of the provisioned resources. MySQL Autopilot is also integrated with the interactive console, making it easier to use.
- Advanced security features: MySQL HeatWave service now offers several comprehensive security features which provide additional differentiation with Amazon Aurora. These include server-side data masking and de-identification, asymmetric data encryption, and a database firewall. Asymmetric data encryption enables developers and DBAs to increase the protection of confidential data and implement digital signatures to confirm the identity of people signing documents. Database firewall provides real-time protection against database-specific attacks, such as SQL Injections. These features are designed to provide best in class security for database users and provide a contrast with Aurora, where security methods are layered on top of the database.
- MySQL Autopilot: Autopilot provides workload-aware, machine learning-based automation of various aspects of the application lifecycle, including provisioning, data management, query execution, and failure handling. Autopilot features include auto provisioning, auto parallel loading, auto encoding, auto data placement, auto scheduling, auto query plan improvement, auto change propagation, and auto error handling. Combined, these features improve performance of the application, reduce cost by predicting the optimal configuration to run a workload, and reduce manual database administration. Today, Oracle is introducing additional Autopilot capabilities designed for OLTP workloads which further improve MySQL HeatWave price performance compared to Amazon Aurora. Auto thread pooling provides higher and sustained throughput at high concurrency by determining the optimal number of transactions which should be executed. Auto shape prediction determines the optimal shape which should be provisioned to provide the best price performance for OLTP workloads. In a running system, the recommendation could be to continue using the existing shape, to upgrade to a larger shape for better performance or to downgrade to a smaller shape to reduce costs—whichever shape provides the best price performance.
- Machine Learning: HeatWave ML provides in-database machine learning capabilities, including training, inference, and explanations. This enables customers to securely use machine learning on real-time data without the complexity, latency, and cost of ETL. HeatWave ML fully automates the ML lifecycle and stores all trained models inside the MySQL database, eliminating the need to move them to a separate machine learning tool or service. It’s available at no additional charge for MySQL HeatWave customers. No other cloud database vendor or open source database provides such advanced ML capabilities inside the database. On average, HeatWave ML trains models 25 times faster than Redshift ML and scales with the cluster size. MySQL HeatWave customers can now train models more often and keep them updated for increased prediction accuracy.
Ready for the Distributed Cloud
MySQL HeatWave is available in multiple clouds today, including OCI, AWS, and Microsoft Azure in the near future. It’s available on-premises as part of Oracle Dedicated Region Cloud@Customer for organizations that cannot move their database workloads to the public cloud. Customers can also replicate data from their on-premises MySQL OLTP applications to MySQL HeatWave on AWS or OCI to obtain near real-time analytics. MySQL HeatWave is always running the latest version of the MySQL database which is not the case for many of the other MySQL based services.
“While AWS offers a smorgasbord of cloud database services specialized for each data type and capability, MySQL HeatWave on AWS follows Oracle’s converged database strategy—offering transaction, analytics, ML, and Autopilot automation all in one. For AWS users, this means no charges for add-on services, extra storage, data egress fees, connectors, and more. For cost conscious IT teams and developers, MySQL HeatWave on AWS represents a whole new TCO calculation with zero cost for what are add-on services on AWS and no data egress fees,” said Marc Staimer, senior analyst, Wikibon. “And just as Usain Bolt left all of his competitors in the dust and set new world records that have yet to be broken, the latest price performance benchmark results demonstrate that MySQL HeatWave on AWS is 7X better than Amazon Redshift. If you follow the money, the choice is easy.”
Customer Commentary
Additional customers commenting on today’s news include:
Anish Kumar, associate vice president at 6D Technologies, an India-based high-tech solution provider in the telecom industry with customers in over 80 countries, said “MySQL HeatWave on AWS has 139X faster complex queries compared to Amazon RDS and Aurora that gives us a great opportunity to simplify our data infrastructure for both OLTP and OLAP with sub-second response time. Also, the web console is easy to configure and provides us the visibility to workload-related performance metrics with interactive reporting. MySQL HeatWave is a great fit for our microservices and cloud native product roadmap to deliver a superior experience and performance for our customers.”
ITSP, Inc. is a high-tech solution provider and Oracle partner, based in Canada. “MySQL HeatWave on AWS is a game changer. We were pleasantly surprised with the ease-of-use and performance with 10-30X faster queries without complicated database tuning and performance improvement, using a similar database configuration,” said Wenjin Zhou, PhD, chief technology officer, ITSP, Inc. “With a single database for OLTP and OLAP workloads for large volume of data sets, we no longer need index creation and maintenance which accelerates time-to-value for our clients.”
U.S.-based Centroid Systems is a leading cloud services and technology company with over 200 customers and is an Oracle partner for more than 20 years. “We found MySQL HeatWave on AWS improved query performance by 15X with no changes to our application compared to using MariaDB on AWS RDS,” said Ajay Arora, chief technology officer, Centroid. “With MariaDB for analytics along with Tableau for visualization, we had been experiencing multiple outages because of the volume of data and patches impacting the SQL query performance. The performance gains from MySQL HeatWave gave our business confidence to expand and bring more offerings to the market.”
LeanTaaS is a predictive analytics and machine learning company that transforms healthcare operations through its platform, iQueue, for over 490 hospitals and 125 health systems in the United States. “MySQL HeatWave on AWS is an excellent solution for us as a small team. Having one database for both OLTP and OLAP workloads with 6X better performance compared to AWS RDS delivers real-time insights that helps us to continually enhance our iQueue platform, improve the user experience, and reduce complexity and administrative overhead for our team,” said Gokhan Oner, senior engineering manager, LeanTaaS.
Bionime is a Taiwan-based, leading medical device manufacturer for diabetes monitoring systems in more than 100 countries. “MySQL HeatWave on AWS has 50X faster complex queries compared to AWS RDS and that not only provides us with real-time insights to accelerate application development, but also helps us improve patients’ lives,” said Kyle Yang, assistant manager, Bionime.
Additional Resources
- Run your own benchmarks here
- Watch the MySQL HeatWave explainer video
* Benchmark queries are derived from the TPC benchmarks, but results are not comparable to published TPC benchmarks results since these do not comply with the TPC specifications.
Visit AITechPark for cutting-edge Tech Trends around AI, ML, Cybersecurity, along with AITech News, and timely updates from industry professionals!
