Oracle HeatWave MySQL Foundations

Course details

This course is designed to introduce beginners to the parallel, high-performance, native in-memory query acceleration of MySQL HeatWave. Learn about configuring a cluster and using the innovative Autopilot features to accelerate your MySQL performance for analytics and mixed workloads. Along the way, discover the inner workings of HeatWave’s query accelerator, including how to use Auto Parallel Load, load data into a HeatWave cluster, offload queries, and much more, optimizing your HeatWave workloads using advisors, such as Auto Encoding Advisor, Auto Data Placement Advisor, Query Insights, and Auto Unload Advisor.

Learning objectives
Describe the architecture and features of MySQL HeatWave.
Create and manage database systems.
Add and manage a HeatWave cluster.
Load data and run queries on a HeatWave cluster.
Explain the inner workings of HeatWave query accelerator.
Load data into and run queries on a HeatWave cluster.
Optimize HeatWave workloads using advisors.

Concepts

1. Introducing MySQL HeatWave

01 - Overview of MySQL HeatWave
02 - Oracle Cloud infrastructure basics
03 - MySQL HeatWave architecture
04 - Practices for introducing MySQL HeatWave - Overview
05 - Cloud Shell overview
06 - Practice 1-1 - Preparing the lab environment
07 - Practice 1-2 - Inspecting the subnets of a VCN

2. Deploying a DB System

08 - Creating DB systems
09 - Connecting to DB systems
10 - Editing DB systems
11 - Managing DB systems
12 - Practices for deploying a DB system - Overview
13 - Practice 2-1 - Creating a MySQL DB system
14 - Practice 2-2 - Connecting to a MySQL system with Cloud Shell
15 - Practice 2-3 - Editing a DB system
16 - Practice 2-4 - Increasing the storage size of a DB system
17 - Practice 2-5 - Stopping, starting, and restarting a MySQL DB system

3. Deploying a HeatWave Cluster

18 - Adding a HeatWave cluster
19 - Loading data and running queries
20 - Managing a HeatWave cluster
21 - Practices for deploying a HeatWave cluster - Overview
22 - Practice 3-1 - Adding a HeatWave cluster to a DB system
23 - Practice 3-2 - Loading data into HeatWave and running queries on HeatWave
24 - Practice 3-3 - Stop, start, restart, resize, and delete a HeatWave cluster

4. Introducing HeatWave Query Accelerator

25 - Overview of HeatWave query accelerator
26 - Practice 1-1 - Preparing the lab environment

5. Loading Data into HeatWave Cluster

27 - Loading data into a HeatWave cluster - Overview
28 - Loading data manually
29 - Loading data using Auto Parallel Load
30 - Monitoring data loading
31 - Unloading data
32 - Practice 2 - Overview
33 - Practice 2-1 - Loading data manually into a HeatWave cluster
34 - Practice 2-2 - Loading data with Auto Parallel Load
35 - Practice 2-3 - Monitoring data loading into a HeatWave cluster
36 - Practice 2-4 - Unloading data from a HeatWave cluster
37 - Offloading queries to HeatWave
38 - Debugging queries
39 - Practice 3 - Overview
40 - Practice 3-1 - Offloading queries to HeatWave cluster
41 - Practice 3-2 - Debugging queries that are not offloaded to HeatWave cluster

6. Optimizing HeatWave Workload

42 - Overview of advisors
43 - Auto Encoding Advisor
44 - Auto Data Placement Advisor
45 - Query Insights
46 - Auto Unload Advisor
47 - Practice 4 - Overview
48 - Practice 4-1 - Viewing query runtime with Query Insights
49 - Practice 4-2 - Identifying tables to unload with Auto Unload Advisor
50 - Practice 4-3 - Optimizing string column encoding with Auto Encoding Advisor
51 - Practice 4-4 - Optimizing partitioning columns with Auto Data Placement Advisor

Oracle HeatWave MySQL Foundations

Authors

Oracle University