MySQL HeatWave is a comprehensive program for Windows that allows you to quickly develop and deploy secure cloud native apps using the popular open source database called MySQL. The service provides you with a scalable, integrated, real-time query accelerator, and a fully automated machine learning engine.

Functioning principle

The software was designed to help you run analytics on data which is stored in MySQL databases, without the need for extracting, transforming, and loading the information. The distribution is built on a powerful engine which ensures scalability and improved performance. This results in a convenient solution for SQL analytics at a fraction of the cost compared to third-party products.

Deployment cases

A MySQL HeatWave deployment is a cluster consisting of a MySQL instance and several HeatWave nodes. When the technology is enabled, the server is installed on the database node. This component is responsible for cluster management, loading data into the memory, query scheduling and execution.

It is necessary to mention that MySQL applications written in Java, Ruby, PHP, and others may be integrated seamlessly with MySQL HeatWave via standard ODBC or JDBC connectors. Thus, all existing instruments and programs created using standard SQL will work without additional modification to queries.

Features

free to download and use;
compatible with modern Windows versions;
enables you to create cloud native applications;
you can integrated projects written in Java and Ruby;
it is possible to analyze data without ETL testing.