Big Data Market Segment LS
Big Data Market Segment RS
Wednesday, 11 August 2021 10:15

Oracle announces MySQL Autopilot for MySQL HeatWave Service for blazing fast MySQL Featured

By

The Oracle MySQL Autopilot delivers nine new automations powered by machine learning. Oracle says MySQL HeatWave now has performance and scalability that can deliver 35x better price/performance compared to Snowflake and 13x better than Amazon Redshift with Aqua on industry-standard TPC-H benchmarks.

MySQL HeatWave is the in-memory query acceleration engine for Oracle Cloud Infrastructure’s (OCI) MySQL Database Service. Oracle has now announced MySQL Autopilot which applies machine learning to automate HeatWave, making it easier to use and further improve its performance and scalability.

Autopilot is available at no additional charge for MySQL HeatWave customers.

Autopilot automates many of the most important and often challenging aspects of achieving high query performance at scale. This includes provisioning, data loading, query execution, and failure handling. It uses advanced techniques to sample data, collect statistics on data and queries, and build machine learning models using Oracle AutoML to model memory usage, network load and execution time.

These machine learning models are then used by MySQL Autopilot to execute its core capabilities, resulting in continually improved system performance from the HeatWave query optimiser.

Oracle states this capability is not available on competing products such as Amazon Aurora, Amazon Redshift, Snowflake, or other MySQL-based database services.


The nine new automations Autopilot provides are:

  1. Auto provisioning to predict the number of HeatWave nodes required for running a workload - eliminating manual effort in estimating the optimal size of the cluster
  2. Auto parallel load to optimise the load time and memory usage by predicting the optimal degree of parallelism for each table being loaded into HeatWave
  3. Auto data placement to predict the column on which tables should be partitioned in memory to achieve the best query performance.
  4. Auto encoding to determine the optimal representation of columns being loaded into HeatWave
  5. Auto query plan improvement to feed statistics from query executions back into improving the execution plan of future queries
  6. Auto query time estimation to predict the execution time of a query prior to executing it, allowing customers to decide if it is too long and to alter their query
  7. Auto change propagation to intelligently determine the optimal time when changes in the MySQL database should be propagated to the HeatWave scale-out data management layer
  8. Auto scheduling to determine which queries in the queue are short running and prioritise them over long-running queries in an intelligent way to reduce overall wait time
  9. Auto error recovery provisions new nodes and reloads necessary data if one or more HeatWave nodes is unresponsive for any reason

“Oracle’s MySQL Database Service with HeatWave is the only MySQL database that efficiently supports both OLTP and OLAP, enabling users to run mixed workloads or real-time analytics against their MySQL database with 10 to 1,000 times better performance and less than half the cost compared to other analytical or MySQL-based databases,” said Edward Screven, Chief Corporate Architect, Oracle. “MySQL HeatWave is one of the fastest-growing cloud services on OCI and an increasing number of customers are moving their MySQL workloads to HeatWave. Today, we are announcing a number of innovations resulting from years of research and advanced development at Oracle. The combination of these innovations delivers massive improvements in automation, performance and cost—further distancing HeatWave from other database cloud services.”

Oracle is also introducing MySQL Scale-out Data Management, which can improve the performance of reloading data into HeatWave by up to 100 times. HeatWave now supports a cluster size of 64 nodes (up from 24) and is capable of processing up to 32 TB of data (up from 12 TB).

Oracle states HeatWave is a better choice for customers than competing products, claiming it offers improved price/performance for analytics and mixed workloads. Oracle says its tests are available for anyone to perform themselves and had these results:

  • 13x better price/performance than Amazon Redshift with AQUA—6.5 times faster at half the cost (TPC-H 10TB)
  • 35x better price/performance than Snowflake—7 times faster at 1/5 the cost (TPC-H 10TB)
  • 36x better price/performance than Google Big Query—9 times faster at 1/4 the cost (TPC-H 30TB)
  • 15x better price/performance than Azure Synapse—3 times faster at 1/5 the cost (TPC-H 30TB)
  • 42x better price/performance than Amazon Aurora for mixed workloads—18 times lower latency, and 110 times higher throughput at 42% the cost (CH-benCHmark 100G)

MySQL HeatWave is also incorporated into the Oracle lake house. OCI Data Catalog is the single catalogue for the lake house, including data from MySQL Database Service as well as Oracle Autonomous Database and OCI Object Storage. Lake house users can discover MySQL data through the catalogue and move it or analyse it as needed. Several other OCI services such as Oracle Analytics Cloud and Oracle Cloud Data Integration service are also integrated with MySQL HeatWave.

The new features introduced in the latest MySQL HeatWave release are available now on OCI across all 30 Oracle Cloud Regions.


Subscribe to ITWIRE UPDATE Newsletter here

PROMOTE YOUR WEBINAR ON ITWIRE

It's all about Webinars.

Marketing budgets are now focused on Webinars combined with Lead Generation.

If you wish to promote a Webinar we recommend at least a 3 to 4 week campaign prior to your event.

The iTWire campaign will include extensive adverts on our News Site itwire.com and prominent Newsletter promotion https://itwire.com/itwire-update.html and Promotional News & Editorial. Plus a video interview of the key speaker on iTWire TV https://www.youtube.com/c/iTWireTV/videos which will be used in Promotional Posts on the iTWire Home Page.

Now we are coming out of Lockdown iTWire will be focussed to assisting with your webinatrs and campaigns and assassistance via part payments and extended terms, a Webinar Business Booster Pack and other supportive programs. We can also create your adverts and written content plus coordinate your video interview.

We look forward to discussing your campaign goals with you. Please click the button below.

MORE INFO HERE!

INTRODUCING ITWIRE TV

iTWire TV offers a unique value to the Tech Sector by providing a range of video interviews, news, views and reviews, and also provides the opportunity for vendors to promote your company and your marketing messages.

We work with you to develop the message and conduct the interview or product review in a safe and collaborative way. Unlike other Tech YouTube channels, we create a story around your message and post that on the homepage of ITWire, linking to your message.

In addition, your interview post message can be displayed in up to 7 different post displays on our the iTWire.com site to drive traffic and readers to your video content and downloads. This can be a significant Lead Generation opportunity for your business.

We also provide 3 videos in one recording/sitting if you require so that you have a series of videos to promote to your customers. Your sales team can add your emails to sales collateral and to the footer of their sales and marketing emails.

See the latest in Tech News, Views, Interviews, Reviews, Product Promos and Events. Plus funny videos from our readers and customers.

SEE WHAT'S ON ITWIRE TV NOW!

BACK TO HOME PAGE
David M Williams

David has been computing since 1984 where he instantly gravitated to the family Commodore 64. He completed a Bachelor of Computer Science degree from 1990 to 1992, commencing full-time employment as a systems analyst at the end of that year. David subsequently worked as a UNIX Systems Manager, Asia-Pacific technical specialist for an international software company, Business Analyst, IT Manager, and other roles. David has been the Chief Information Officer for national public companies since 2007, delivering IT knowledge and business acumen, seeking to transform the industries within which he works. David is also involved in the user group community, the Australian Computer Society technical advisory boards, and education.

Share News tips for the iTWire Journalists? Your tip will be anonymous

WEBINARS ONLINE & ON-DEMAND

GUEST ARTICLES

VENDOR NEWS

Guest Opinion

Guest Reviews

Guest Research

Guest Research & Case Studies

Channel News

Comments