Oracle launches Autopilot for MySQL Heatwave service

Oracle has recently announced MYSQL autopilot to enhance the capabilities of MYSQL heatwave service. Autopilot will be integrated with the heatwave service. Autopilot will serve as an in memory query acceleration engine for the oracle cloud infrastructure. 

 

Autopilot employs machine learning techniques for the automation in heatwave. ML techniques will provide better scalability and transparency in the business operations. Autopilot will be available free of cost to the customers using heatwave. 

 

Provisioning, data loading, query execution and failure handling are some of the important functions that autopilot will undertake. It will employ advanced techniques for data sampling, data collection and data evaluation. 

 

MYSQL autopilot will provide automated dashboards. With the aid of Autopilot, the heatwave query optimizer will also get a refreshed version. Query optimizer will become intelligent in data sampling. 

 

With every new query, the optimizer will improvise its features; this functionality is not available on Amazon Aurora, Amazon RedShift, and Snowflake. 

 

Advantages of MySQL Autopilot

 

• Auto Query Time Estimation: This feature will estimate the execution time of a query, before the query execution. 

 

• Auto Change Propagation: This feature will calculate the time required for making changes in the database. 

 

• Auto Scheduling: Auto Scheduling feature will arrange short run and long run queries. It will place short running queries before long running ones to save the user time. 

 

• Auto Error Recovery: It will automatically detect the era in the database post detection it suggests loading and reloading of data.

 

• Auto Data Placement: This feature provides details about column and partition in memory. It provides column recommendations and also suggests ways of speeding up the data arrangement. 

 

• Auto Encoding: It will provide details regarding the proper arrangement of columns. Properly arranged columns provide best query performance. 

 

(Must Check: Introduction to NoSQL)

Along with this new launch Oracle has also introduced MYSQL scale data management which will improve the reloading performance of heatwave upto 100 times. Heatwave will now support a cluster size of 64 nodes. 

 

According to InfoWorld, The Oracle Database is for large-scale enterprise deployments while MySQL is for developers  cloud-native open source applications, and companies who have never had an on-premises environment, company officials insist.