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


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.

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 t


he complete list of today’s Zacks #1 (Strong Buy) Rank stocks here


Breakout Biotech Stocks with Triple-Digit Profit Potential

The biotech sector is projected to surge beyond $775 billion by 2024 as scientists develop treatments for thousands of diseases. They’re also finding ways to edit the human genome to literally erase our vulnerability to these diseases.

Zacks has just released

Century of Biology: 7 Biotech Stocks to Buy Right Now

to help investors profit from 7 stocks poised for outperformance. Our recent biotech recommendations have produced gains of +50%, +83% and +164% in as little as 2 months. The stocks in this report could perform even better.


See these 7 breakthrough stocks now>>

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


To read this article on Zacks.com click here.