Recently I’ve been playing with Oracle’s MySQL Database Service (MDS) and testing out the Heatwave option.  Heatwave is very impressive and enables MySQL to run OLAP workloads within a smaller database on the Oracle Cloud Infrastructure (OCI).  Within the MySQL Database Service there are only a few compute shapes that support the option for Heatwave.  These shapes are:

• MySQL.HeatWave.VM.Standard.E3
• MySQL.HeatWave.BM.Standard.E3

Both shapes support the usage of HeatWave clusters.  At the same time, you can see that there are only a few shapes that support the use of offloading queries.  Although this is not the point of this post, it is good to keep this in mind.  Not every shape will support the HeatWare api.

Once a MySQL Database Service (MDS) with HeatWave is running, queries can be offloaded.  There may be times when you don’t want to use the HeatWave option after it was enabled, yet the MDS System Details page doesn’t show an option to remove HeatWave.  Leaving the question of how to remove HeatWave from the MDS if it is not needed?

To remove HeatWave from an MySQL Database Services, do the following:

Validate that the MDS is configured with HeatWave.  This is done from the MDS DB System Details page.

Notice that the area highlighted only shows that HeatWave is enabled.  It also shows you that it is using two nodes with a memory capacity of one terabyte.

To remove HeatWave, you have to go to the bottom of the page, on the left hand side under the Resources section.  Under Resources, you will see an option for HeatWave.

By clicking the HeatWave option under Resources, opens up the sub-page that provides details on HeatWave itself. From here, you can see the size of the HeatWave cluster, Shape, status among the nodes that has been built.  At the same time, there are buttons for edit, start, stop and restart.  At the same time there is a big read delete button!

When you select the big red delete button, it will prompt you to confirm that you want to delete the HeatWave cluster.

By clicking the “Delete HeatWave Cluster” (big red button), this will remove all the HeatWave nodes in the cluster. After confirming that you want to remove the Heatwave Cluster, the Resource section will update with a status of “Deleting”

Once the delete process is done, your MySQL Database System is returned back to just a normal MDS configuration and HeatWave is disabled.

Oracle has made it very easy to take an existing MySQL Database Service (MDS) and plugin a HeatWave cluster.  At the same time, they made it easy to remove when you don’t need the extra processing power for queries.

Enjoy!!!