Oracle has expanded its HeatWave database query accelerator, introduced last year, with machine learning-based automation features, MySQL Autopilot, including auto-provisioning, parallel loading, data placement, query plan enhancement, scheduling, and error recovery. The announcement was the culmination of nearly a decade of research, during which more than 60 patients were obtained.
Kyiv. Ukraine. Ukraine Gate – August 12, 2021 – Technology
This technology, according to Oracle, can run queries 10 to 1,000 times faster than competing databases for less than half the cost. Specifically, MySQL HeatWave was 1,400 times faster than Amazon Aurora in a suite based on TPC-H benchmarks.
By creating an in-memory copy of the data in object storage and reading it from there instead of the MySQL database, MySQL Autopilot reduces the load time of a 10TB database from 7.5 hours to four minutes.
The company claims that as more queries are executed, the optimizer gradually grows smarter, consistently improving its performance.
Oracle also introduced the MySQL Scale-out Data Management service, which it says will improve HeatWave’s data reload performance by two orders of magnitude. The maximum cluster size has been increased from 24 to 64 nodes, and the total computing power has been increased from 12 terabytes to 32 terabytes.
The service is immediately available in all 30 Oracle Cloud regions. MySQL Database for HeatWave-Standard-E3 costs less than 34 cents per node per hour.
With the introduction of managed services, Oracle has the opportunity to monetize the second most popular relational engine on the market after the Oracle product of the same name. The company does not consider the managed service to be a competitor to its flagship database management system, as their use cases are completely different. MySQL is more prevalent in large web environments, while Oracle is typically used for transactions.
The combination of analytical and transactional processing in one engine has been practiced for several years by vendors such as SAP or MariaDB who are looking to make decision support functions available in their underlying engines. It also improves security by reducing the attack surface, Oracle says. HeatWave communications are additionally encrypted using keys and certificates controlled by Identity and Access Management in Oracle Cloud.
Read Also: Facebook Asked to Allow Data Collection to “Stay Free”
Source: Ukrgate
