MySQL Autopilot, this is the name of the new component of MySQL HeatWave service – the in-memory query acceleration engine for MySQL Database Service n Oracle Cloud Infrastructure (OCI) – that Oracle announced these days.
An innovation that will allow, with advanced automatic learning techniques, to automate and make the use of HeatWave easier and more efficient. Something that, in such an advanced way, is not present in the “database”, without forgetting that the Autopilot functionality will be available at no additional cost to customers who already use MySQL HeatWave.
MySQL Autopilot will then automate many of the most important and challenging aspects of achieving high performance on large-scale queries – including provisioning, data loading, query execution and error handling. Advanced techniques will be used to sample data, collect statistics on data and queries and create machine learning models using Oracle AutoML to model memory use, network load, execution times. These machine learning models are used by MySQL Autopilot to perform its key functionality.
MySQL Autopilot will make the HeatWave Query Optimizer smarter as more queries are run, resulting in continuously improving system performance over time – a capacity not available on Amazon Redshift, Amazon Aurora, Snowflake or other cloud offerings based on MySQL.
MySQL Autopilot: the features offered
“MySQL Database Service with HeatWave is the only MySQL database that efficiently supports both OLTP and OLAP, allowing users to run mixed workloads or real-time analytics on their MySQL database with 10 to 1,000 times better and less performance. half the cost of other analytical or MySQL-based databases, ”he said Edward Screven, Chief Corporate Architect, Oracle. “MySQL HeatWave is one of the fastest growing cloud services on Oracle Cloud and an increasing number of customers are moving their MySQL workloads to HeatWave. The series of innovations announced are the result of Oracle’s years of research and development, and their combination offers huge improvements in automation, performance and cost, further distancing HeatWave from other cloud services. “
As part of the announcement, Oracle also introduced MySQL Scale-out Data Management, which improves data reload performance in HeatWave up to 100 times. HeatWave now supports a cluster of 64 nodes – up from 24 previously available – and is capable of processing up to 32TB of data – previously 12TB.
Scalability is further improved to nearly 0.9 – and 1.0 is a perfect scaling factor. These new improvements further reinforce HeatWave’s price / performance advantages over its main competitors. HeatWave offers better performance at a lower price for analytical and mixed workloads than all other competitive analytics and database cloud services. In particular, according to the tests performed, HeatWave offers a price / performance ratio:
Oracle also makes the benchmark code publicly available for customers to run the benchmarks by visiting this site. Oracle also announced that the TPC-DS industry standard benchmark can now be accelerated using HeatWave.
Sunday commitments always turn out to be lively. Let's find out where to watch Bologna-UdineseI…
Welcome back to this new episode dedicated to the format of our most beloved superheroes!…
Android 15 Beta 1.2 is available for Pixel devices with improvements to stability, performance and…
In this test we take a closer look at the new Hyundai Kona Full Electric,…
Framework Laptop 13 can be dismantled by everyone. With just one small tool. This is…
The exit of the British designer from Red Bull could trigger a domino effect with…