MySQL Database Service powered by HeatWave for your Analytics project on Oracle Cloud

This workshop will walk you through the process to deploy and configure MySQL Database Service & Heatwave to run Analytics workloads in Oracle Cloud.

HeatWave is a new, integrated, high-performance analytics engine for MySQL Database Service. HeatWave accelerates MySQL performance by 400X for analytics queries, scales out to thousands of cores, and is 2.7X faster at one-third the cost of Amazon Redshift. MySQL Database Service, with HeatWave, is the only service that enables database admins and app developers to run OLTP and OLAP workloads directly from their MySQL database, eliminating the need for complex, time-consuming, and expensive data movement and integration with a separate analytics database. The service is optimized for and exclusively available in Oracle Cloud Infrastructure (OCI).

At the end of the workshop you will be able to run some queries on a sample dataset loaded into MySQL Database Service and compare the execution times with and without Heatwave. Prepare yourself to be surprised!

Key Objectives:

• Learn how to deploy MySQL Database Service (MDS) DB System with HeatWave
• Learn how to enable an HeatWave cluster to MDS DB System
• Learn how to import data into MDS from an external data source
• Understand how tables are loaded to HeatWave
• Learn how to run queries on MDS leveraging or not HeatWave

Prerequisites:

• This workshop requires an Oracle Public Cloud account. You may use a paid cloud account or a trial cloud account.
• A Cloud tenancy where you have a compartment provisioned in.

Workshop Overview

All set? Let's start

Lab 0 - Create a Trial account on Oracle Cloud Infrastructure

Key Objectives:

• Learn how to create a Trial account on Oracle Cloud Infrastructure
• Choose an appropriate Cloud Region

Click here for Lab 0

Lab 1 - Create a Virtual Cloud Network and allow traffic through MySQL Database Service port

Key Objectives:

• Learn how to create a Virtual Cloud Network with internet connectivity
• Add ingress rules in the security list to allow traffic through MySQL Database Service ports

Click here for Lab 1

Lab 2 – Create a compute instance as a bastion host

Key Objectives:

• Learn how to create a compute instance in a specific compartment

Click here for Lab 2

Lab 3 - Create MySQL DB System (MDS) with Heatwave

Key Objectives:

• Learn how to deploy and configure MySQL Database Service with Heatwave
• Learn how to create the Administrator user for the MDS

Click here for Lab 3

Lab 4 – Connect to the bastion host, install MySQL Shell and download the workshop dataset

Key Objectives:

• Learn how to connect to the cloud shell and to the bastion host
• Learn how to launch MySQL shell
• Download and setup workshop material

Click here for Lab 4

Lab 4a – Create a compute instance, install mysqlrouter for Oracle Analytics Cloud

Key Objectives:

• Learn how to install mysqlrouter
• Learn how to configure mysqlrouter to allow Oracle Analytics Cloud to connect to MDS/HeatWave

Click here for Lab 4a

Lab 5 – Add HeatWave cluster to MySQL Database Service

Key Objectives:

• Learn how to enable the HeatWave cluster for MDS

Click here for Lab 5

Lab 6 – Import data into MDS and load tables to HeatWave

Key Objectives:

• Learn how to connect to MDS and import a dataset

Click here for Lab 6

Lab 7 – Execute queries leveraging HeatWave

Key Objectives:

• Learn how to enable Heatwave and compare the query execution time with and without HeatWave enabled

Click here for Lab 7

Bonus Lab 8a - Use OCI Bastion Service to manage MDS

Key Objectives:

• Learn how to use the free OCI Bastion Service to manage MDS remotely

Click here for Lab 8a

Bonus Lab 8b - Deploy your mission critical application on MDS High Availability

Key Objectives:

• Learn how to provision MDS with High Availability enabled for your mission-critical application

Click here for Lab 8b