MySQL is one of the most popular open-source relational database management systems with tens of thousands of installations around the world. It provides a robust platform for data storage, retrieval, and management. MySQL is available in several editions, including Community Edition, Enterprise Edition, and HeatWave.
Though mySQL Community Edition is free to download and use, it does not come with any support. In addition, it lacks advanced features that can improve database performance, availability and security. If you find yourself in need of these features then you should consider MySQL HeatWave.
MySQL HeatWave is available in OCI, AWS and Azure. It is a cloud service with a built-in, high performance, in-memory query accelerator that increases MySQL performance by orders of magnitude. It supports analytics as well as mixed workloads and does not require any changes to your applications. Updates from transactions automatically replicate in real time to the HeatWave analytics cluster therefore analytics queries always access the most up-to-date data.
In addition, it supports Machine Learning using HeatWave AutoML (no additional cost). Data scientists can build and execute their machine learning models without having to move data to a separate machine learning application. In terms of security, data at rest and in transit between MySQL database and HeatWave nodes is always encrypted.
Analytics queries always access the most up-to-date data as updates from transactions automatically replicate in real time to the HeatWave analytics cluster. There’s no need to index the data before running analytics queries.
Data at rest and in transit between MySQL Database and the nodes of the HeatWave cluster is always encrypted.
HeatWave AutoML includes everything users need to build, train, deploy, and explain machine learning models within MySQL HeatWave, at no additional cost.