U.S. markets open in 30 minutes
  • S&P Futures

    -36.50 (-0.96%)
  • Dow Futures

    -286.00 (-0.94%)
  • Nasdaq Futures

    -119.75 (-1.03%)
  • Russell 2000 Futures

    -22.90 (-1.29%)
  • Crude Oil

    -0.05 (-0.06%)
  • Gold

    -9.70 (-0.56%)
  • Silver

    -0.78 (-3.69%)

    -0.0071 (-0.71%)
  • 10-Yr Bond

    +0.0940 (+2.60%)
  • Vix

    -0.63 (-2.09%)

    -0.0150 (-1.31%)

    +0.2660 (+0.18%)

    +80.62 (+0.40%)
  • CMC Crypto 200

    +8.11 (+1.82%)
  • FTSE 100

    -55.34 (-0.78%)
  • Nikkei 225

    +128.32 (+0.48%)

Oracle (ORCL) Rolls Out MySQL Autopilot Feature: Key Takeaways

·3 min read

Oracle ORCL rolled out MySQL Autopilot feature for its MySQL Heatwave service at no extra costs to Heatwave clients. The new capabilities are available on the Oracle Cloud Infrastructure (OCI) platform on all 30 Oracle cloud regions.

Powered by advanced machine learning technology, MySQL Autopilot offers nine new automation functionalities to bolster the performance of MySQL HeatWave. MySQL Heatwave is a “in-memory query accelerator” belonging to Oracle’s MySQL Database service.

The new feature automates several attributes of high-query performance like loading of data, execution of query, provisioning, and management of failures, noted Oracle.

Oracle also launched MySQL Scale-out Data Management solution. The solution is designed to boost the performance of data reload into HeatWave service by up to 100 times, per the company’s estimates.

Oracle Corporation Price and Consensus

Oracle Corporation Price and Consensus
Oracle Corporation Price and Consensus

Oracle Corporation price-consensus-chart | Oracle Corporation Quote

With the addition of latest features, HeatWave can now offer 13 times improved price/performance compared with Amazon’s AMZN Redshift with AQUA, according to the company.

HeatWave also offers 35 times and 15 times improved price/performance against Snowflake SNOW and Microsoft’s MSFT Azure Synapse, per Oracle’s estimates.

HeatWave can back a cluster size of 64 nodes and can process up to 32 terabyte (TB) of data. Earlier, Heatwave was supporting a cluster size of 24 nodes and could process 12 TB of data.

A Look at Some of Autopilot’s Capabilities

MySQL Autopilot includes capabilities like auto provisioning, auto data placement, auto encoding, auto query plan improvement, auto parallel load, auto change propagation, auto query time estimation, auto scheduling and auto error recovery.

Auto provisioning facilitates calculation of number of HeatWave nodes needed to run workloads by sampling table data on which analytics is needed, noted the tech giant. As a result, clients are not required to manually calculate the size of their cluster.

In cases where one or few nodes is/are unresponsive due to software/hardware glitch, auto error recovery helps procure new nodes and is capable of reloading essential data.

While most of the databases leverage the concept of First In, First Out (FIFO), HeatWave utilizes auto scheduling capability to schedule queries. Auto scheduling enables customers to split short running queries from the queue and “prioritize” these over long running queries to slash wait time.

With the new Autopilot functionality, HeatWave query optimizer can execute more queries and bolster overall system performance.

Lucrative Database Management Market Bodes Well

Oracle is one of the well-known players in the database management systems (“DBMS”) domain, supported by its strength in cloud technology. DBMS refers to software services aimed at creation, retrieval, storage management of data in the database.

The worldwide DBMS market is forecast to witness a CAGR of 12.4% between 2021 and 2026 and reach $125.6 billion, per a report from Expert Market Research.

Addition of new functionalities like MySQL Autopilot is expected to further boost the adoption of Oracle’s MySQL Database service and provide it a competitive edge in this lucrative space against the likes of Microsoft, Amazon and SAP SE as well as other big and small players.

In December 2020, Oracle announced the availability of its Oracle MySQL Database Service integrated with MySQL Analytics Engine.

At present, Oracle carries a Zacks Rank #3 (Hold). You can see the complete list of today’s Zacks #1 (Strong Buy) Rank stocks here

Want the latest recommendations from Zacks Investment Research? Today, you can download 7 Best Stocks for the Next 30 Days. Click to get this free report

Amazon.com, Inc. (AMZN) : Free Stock Analysis Report

Microsoft Corporation (MSFT) : Free Stock Analysis Report

Oracle Corporation (ORCL) : Free Stock Analysis Report

Snowflake Inc. (SNOW) : Free Stock Analysis Report

To read this article on Zacks.com click here.

Zacks Investment Research