Oracle tweaks MySQL and boosts storage engine
HeatWave is getting additonal power from new automation tool
When you purchase through links on our site, we may earn an affiliate commission.Here’s how it works.
Oracle has announced a free upgrade to its MySQL HeatWave service which it says promises to make life easier for clients, while at the same time improving performance and stability.
The upgrade comes in the form of MySQL Autopilot, an entirely new component to Oracle’scloud-hosted version of thedatabasesystem.
According to the company’s press release, MySQL Autopilot uses “advanced machine learning techniques” to automate much of HeatWave’s features - including provisioning, data loading, query execution and failure handling, to name a few - all of which should help users achieve high query performance at scale.
It works by sampling data, collecting statistics on data and queries, and then building machine learning models using Oracle AutoML to model memory usage, network load, and execution time, Oracle explained. MySQL Autopilot would then use these machine learning models to execute its core capabilities.
As more queries get executed, system performance gets improved over time. With MySQL Autopilot, Oracle promises, HeatWave query optimizer gets “increasingly intelligent”.
Improving performance while cutting costs
Among the different features of the new offering are auto provisioning and auto encoding. The former predicts the number of HeatWave nodes required for running a workload by adaptive sampling of table data on which analytics is required. As a result, customers are freed from manually estimating their clusters’ optimal size. The latter, on the other hand, determines the optimal representation of columns being loaded into HeatWave, taking the queries into consideration.
Through optimal representation, users get the best query performance, while minimizing cluster size and cutting costs.
Are you a pro? Subscribe to our newsletter
Sign up to the TechRadar Pro newsletter to get all the top news, opinion, features and guidance your business needs to succeed!
In the same announcement, Oracle also unveiled MySQL Scale-out Data Management, a service that improves the performance of reloading data into HeatWave “by up to 100 times”.
Cluster size support increased from 24 nodes up to 64 nodes now, with HeatWave now being able to process 32 TB of data, instead of the previous 12TB.
MySQL HeatWave users can now use Autopilot with no additional cost, the company concluded.
Sead is a seasoned freelance journalist based in Sarajevo, Bosnia and Herzegovina. He writes about IT (cloud, IoT, 5G, VPN) and cybersecurity (ransomware, data breaches, laws and regulations). In his career, spanning more than a decade, he’s written for numerous media outlets, including Al Jazeera Balkans. He’s also held several modules on content writing for Represent Communications.
Google puts Nvidia on high alert as it showcases Trillium, its rival AI chip, while promising to bring H200 Tensor Core GPUs within days
A new form of macOS malware is being used by devious North Korean hackers
OLED vs Mini-LED: which TV type is best?
