MySQL is among the most popular open-source SQL databases in the world. Some of the most disruptive technology companies in the world such as Facebook and Uber run their core applications on MySQL. The rapid pace of digital transformation has led organizations to develop, test, deploy, and go-live with their innovations faster than ever before. With the MySQL database management system, multiple users can create and manage databases as required, address complex queries due to the Oracle MySQL Heatwave’s in-memory offering and accelerate innovation and ‘go-to-market’ with their new product features.
Why does MySQL Heatwave score over other options?
MySQL’s Heatwave Solutions cloud-first design – MySQL Heatwave Solution was designed for the cloud and equipped with the latest algorithms to ensure distributed processing, prioritization, and seamless handling of an assortment of simple and complex queries. MySQL Heatwave Solution can manage both OLTP and OLAP workloads simultaneously. It has been optimized for Oracle Cloud Infrastructure (OCI) which means that it can deliver the most cost-effective and seamless allocation of compute, network, storage, and virtual machine (VMs) for the organizations that run their workloads on MySQL Heatwave Service. Such organizations can also seamlessly adopt the cloud and transition faster from legacy environments that may be an impediment in their digital transformation journey.
The power of Machine Learning (ML) and AutoPilot model – With Machine Learning technology of Oracle, it moves algorithms towards to data and runs ML on it, thereby eliminating the need for complex ETL or data movements across environments. IT also enables seamless scalability and enhances security, while accelerating decision making and time-to-market. The Autopilot in Oracle MySQL Heatwave can adapt to changing workloads without any human intervention or reprogramming. It can predict the improvement expected with the predicted changes as well. By providing both the change recommendation and its explanation, Autopilot can give business users the comfort to scale-up in real-time and enhance the performance of their MySQL databases.
A bit more on the ML-enabled automation – The key Autopilot feature includes auto-provisioning, improvement in data load performance through auto parallel loading, auto data placement, auto encoding, immediate handling, and resolution of failure through auto error recovery, and query optimization through auto scheduling, auto change propagation, auto query time estimation and auto query plan improvement.
Scale-Out Data Management for MySQL HeatWave: Now, customers can upload as much data as they want into the MySQL Heatwave. With Scale-Out data management, MySQL Heatwave enables to portion and store data in the in-memory format. This enables data to be loaded in parallel by multiple nodes of a Heatwave cluster. While the performance is improved by over 100x for a 10TB data size, the data is encrypted to ensure security.
The MySQL Heatwave Value – Price to Performance Comparison
The MySQL Heatwave offering, based on 4TB TPCH, delivers a 6.3 second GeoMean of query time in comparison to Aurora’s 2.5 hours, 1400x faster. In addition, HeatWave’s annual costs, based on 10 E3 nodes, are $34,073, which is half the price compared to Aurora’s calculated $67,336 annual cost,both based on list pricing, as per a report by FUTURUM. The report also shares more interesting insights as below.
MySQL Heatwave on OCI v/s MySQL Heatwave on AWS –
MySQL HeatWave delivers comparable advantages against Amazon’s RDS MySQL offering as the 6.3 second GeoMean of query time is a remarkable 5400x faster than Amazon’s RDS MySQL’s 11 hours GeoMean of query time and the MySQL HeatWave’s $34,073 annual cost, based on 10 E3 nodes, is @2/3 the cost of the RDS MySQL annual cost of $54,393.
The price/performance advantage is more significant when comparing MySQL HeatWave on OCI against competitors such as Snowflake on AWS, Redshift, Azure Synapse, and Google BigQuery.
MySQL HeatWave yields an overall thirteen-fold price/performance edge compared to Redshift AQUA as HeatWave requires only 346.5 seconds to Redshift’s 2380 seconds to complete the TPC-H benchmark,6.8x faster performance, while costing 1.9x less with an $80,536 calculated annual cost compared to Redshift’s $150,784 annual cost (based on the 10TB TPC-H third party independent benchmark using 25 nodes of HeatWave, 4 nodes of RA3.4xLarge).
MySQL HeatWave v/s Snowflake?
Based on the 10TB TPC-H third party independent benchmark using 25 nodes of HeatWave, X-Large Cluster, the price/performance gap increases significantly to an overall 35x differential when compared with Snowflake. This includes HeatWave’s having a 6.8x faster performance edge, requiring only 346 seconds in relation to Snowflake’s 2350 seconds, and a 5.2x cost edge shown by HeatWave’s $80,536 annual cost compared to Snowflake’s $420,480 annual cost.
And most importantly,
MySQL database for both transactional and analytical workloads. It assures the smooth running of complex queries against a customer’s MySQL DB without any ETL (Extract, Transfer, Load) operations requirement. Through HeatWave’s ability to scale to thousands of cores, customers can maintain a single MySQL DB for all their applications. While it works seamlessly for OLTP, the intelligent MySQL Heatwave system can also prioritize queries to give precedence to the ones that require an immediate result and would take a resolution time of a few seconds while pushing back the queries that may not be needed immediately and may take a longer time to process.
MySQL HeatWave will bring about a tectonic shift in the world of databases. Are you ready to leverage MySQL HeatWave? Consult our experts for an hour-long MySQL session to understand how it can enable you to get maximum value from your investment in critical databases with in-memory capabilities. Write to us at email@example.com today!
Know more about Clover Infotech’s MySQL Database Service offering here.