Oracle MySQL HeatWave on AWS

Oracle MySQL HeatWave is an in-memory query accelerator that accelerates MySQL operations with the advantage of machine learning. With Oracle MySQL HeatWave on AWS, users can run transaction processing, analytics, and machine learning workloads in one service without using time-consuming ETL between databases. And MySQL HeatWave is the only service that combines Online Analytical Processing (OLAP), Online transaction processing (OLTP), and machine learning.

MySQL HeatWave

Oracle’s Heatwave is a service that delivers OLAP and OLTP with high performance, reliability, and security. The architecture of Heatwave consists of a MySQL DB System with HeatWave Plugin and a HeatWave Cluster with multiple nodes. HeatWave Plugin is responsible for the management and scheduling query and returning the query results to the MySQL DB System. HeatWave node will store the data and process the analytic and machine learning query. Also, it is responsible for hosting the instance of the HeatWave query processing engine. As a result, the Heatwave cluster will enable you to run OLAP, OLTP, and workloads from the same MySQL DB without ETL.

Heatwave Architecture

The access to the Machine learning by HeatWave cluster is a fully managed, highly scalable, and cost-efficient machine learning solution for data stored in MySQL. Analytics or machine learning query from MySQL Client/Application interacts to HeatWave cluster through MySQL DB System. And the results are sent back to the Client/Application through the same MySQL DB System.

HeatWave on AWS

Oracle MySQL HeatWave provides high performance and price performance over transactions, analytics, and machine learning. Developers can achieve these advantages without moving from Amazon Web Services. Oracle MySQL HeatWave on AWS brings a native experience for you, which results in low latency for applications and interactive consoles. With the support of MySQL HeatWave inside AWS, you will get the benefits of HeatWave without paying too many egress fees. Autopilot capability of MySQL HeatWave integrated with an interactive console. This will provide workload-aware machine learning automation in the application lifecycle. Also, you can monitor the query performance and the provisioned resources. MySQL HeatWave provides security features that include server-side data masking and de-identification, asymmetric data encryption, and a database firewall.

Import data from AWS to MySQL HeatWave

Here we will go through the steps for importing and exporting low data volume. Figure below shows the simple migration of low data volume

Simple migration of low volume data

Preparations for importing data from AWS to MySQL HeatWave:

1. Create and prepare Compute instances on OCI.
2. Install migration tool MySQL Shell (the latest 8.0.x) on OCI or EC2.
3. Check the capacity of local storage for logical dumb.
4. Check whether the source DB is already on MySQL 8. If not, upgrade before migration.
5. Install new MySQL HeatWave Instance on OCI.

Steps to export data from AWS

1. Connect to source instance on AWS :

2. Export data to VM’s local storage :

3. Check local disk on OCI VM, directory

Preparations for importing data from AWS to MySQL HeatWave:

1. Create and prepare Compute instances on OCI.
2. Install migration tool MySQL Shell (the latest 8.0.x) on OCI or EC2.
3. Check the capacity of local storage for logical dumb.
4. Check whether the source DB is already on MySQL 8. If not, upgrade before migration.
5. Install new MySQL HeatWave Instance on OCI.

Step to import data to MySQL HeatWave:

1. Connect to target instance on OCI:

Or from within MySQL-Shell:

2. Load the dump from VM’s local storage:

3. Check data on OCI instances.

MySQL Shell will be the best tool for high-performance data migration. For storage purposes, you can use local storage or OCI storage. With MySQL HeatWave, you will get secure and most performant migration.

Conclusion

MySQL HeatWave on AWS is a service where you can run the data plane, control plane, and console. And you can optimize MySQL HeatWave for AWS architecture. With MySQL HeatWave, there will be no change for your application much faster, and it is cheaper. Oracle MySQL HeatWave on AWS offers better performance, lower cost, and a single database is compatible with existing MySQL-based applications or workloads.

For customers looking for better performance and price performance, Metclouds technology can assist you with MySQL HeatWave on AWS.