Heatwave Airport for Partners - Advanced | Lab 1: Create MySQL Da... [Link]
Heatwave Airport for Partners - Advanced
?
+ Introduction
Create MySQL HeatWave Database System
+ Get Started
- Lab 1: Create MySQL
Database System
Introduction
Task 1: Create Virtual
Cloud Network
Task 2: Configure security
list to allow MySQL
incoming connections
Task 3: Configure security
list to allow HTTP
incoming connections
Task 4: Create MySQL
Database for HeatWave
(DB System) instance
Acknowledgements Estimated Time: 15 minutes
Objectives
+ Lab 2: Connect to MySQL
HeatWave With Cloud Shell In this lab, you will be guided through the following tasks:
Private Access and OCI Shell
Create Virtual Cloud Network
+ Lab 3: Load HeatWave cluster Create MySQL HeatWave (DB System) Instance
+ Lab 4: Run Queries in
HeatWave and MySQL Prerequisites
+ Lab 5: Do HeatWave Machine An Oracle Trial or Paid Cloud Account
Learning
Some Experience with MySQL Shell
+ Lab 6: Do HeatWave
Lakehouse
Collapse All Tasks
+ Lab 7: Build a LAMP
application with MySQL Task 1: Create Virtual Cloud Network
HeatWave
1. You should be signed in to Oracle Cloud!
+ Lab 8: (Bonus) Build a real-
time dashboard in Oracle
Click Navigation Menu,
1 of 10 11/28/2023, 10:49 AM
Heatwave Airport for Partners - Advanced | Lab 1: Create MySQL Da... [Link]
+ Introduction
Heatwave Airport for Partners - Advanced
+ Get Started
- Lab 1: Create MySQL
Database System
Introduction
Task 1: Create Virtual
Cloud Network
Task 2: Configure security
list to allow MySQL
incoming connections
Task 3: Configure security
list to allow HTTP
incoming connections
Task 4: Create MySQL
Database for HeatWave
(DB System) instance
Acknowledgements
+ Lab 2: Connect to MySQL
HeatWave With Cloud Shell
Private Access and OCI Shell
+ Lab 3: Load HeatWave cluster
+ Lab 4: Run Queries in
HeatWave and MySQL
+ Lab 5: Do HeatWave Machine
Learning
+ Lab 6: Do HeatWave
Lakehouse
+ Lab 7: Build a LAMP
application with MySQL
HeatWave
+ Lab 8: (Bonus) Build a real-
time dashboard in Oracle
2 of 10 11/28/2023, 10:49 AM
Heatwave Airport for Partners - Advanced | Lab 1: Create MySQL Da... [Link]
?
+ Introduction
Heatwave Airport for PartnersVCN
- Advanced
Name:
+ Get Started
Copy
- Lab 1: Create MySQL HEATWAVE-VCN
Database System
Introduction
Compartment: Select (root)
Task 1: Create Virtual
Cloud Network
Your screen should look similar to the following
Task 2: Configure security
list to allow MySQL
incoming connections
Task 3: Configure security
list to allow HTTP
incoming connections
Task 4: Create MySQL
Database for HeatWave
(DB System) instance
Acknowledgements
+ Lab 2: Connect to MySQL
HeatWave With Cloud Shell
Private Access and OCI Shell
+ Lab 3: Load HeatWave cluster
+ Lab 4: Run Queries in
HeatWave and MySQL
Click 'Create' to create the VCN
+ Lab 5: Do HeatWave Machine
Learning
+ Lab 6: Do HeatWave
Lakehouse
+ Lab 7: Build a LAMP
application with MySQL
HeatWave
+ Lab 8: (Bonus) Build a real-
time dashboard in Oracle
3 of 10 11/28/2023, 10:49 AM
Heatwave Airport for Partners - Advanced | Lab 1: Create MySQL Da... [Link]
?
+ Introduction
Heatwave Airport for PartnersVCN'
- Advanced
+ Get Started
- Lab 1: Create MySQL
Database System
Introduction
Task 1: Create Virtual
Cloud Network
Task 2: Configure security
list to allow MySQL
incoming connections
Task 3: Configure security
list to allow HTTP
incoming connections
Task 4: Create MySQL
Database for HeatWave
(DB System) instance
Acknowledgements
+ Lab 2: Connect to MySQL
HeatWave With Cloud Shell
Private Access and OCI Shell
+ Lab 3: Load HeatWave cluster
+ Lab 4: Run Queries in
HeatWave and MySQL
+ Lab 5: Do HeatWave Machine
Learning
+ Lab 6: Do HeatWave
Lakehouse
+ Lab 7: Build a LAMP
application with MySQL
HeatWave
+ Lab 8: (Bonus) Build a real-
time dashboard in Oracle
Copy
[Link]/0
b. Destination Port Range
Copy
3306,33060
4 of 10 11/28/2023, 10:49 AM
Heatwave Airport for Partners - Advanced | Lab 1: Create MySQL Da... [Link]
?
+ Introduction c. Description
Heatwave Airport for Partners - Advanced
+ Get Started Copy
MySQL Port Access
- Lab 1: Create MySQL
Database System
Introduction d. Click 'Add Ingress Rule'
Task 1: Create Virtual
Cloud Network
Task 2: Configure security
list to allow MySQL
incoming connections
Task 3: Configure security
list to allow HTTP
incoming connections
Task 4: Create MySQL
Database for HeatWave
(DB System) instance
Acknowledgements
+ Lab 2: Connect to MySQL
HeatWave With Cloud Shell
Private Access and OCI Shell
+ Lab 3: Load HeatWave cluster
+ Lab 4: Run Queries in
HeatWave and MySQL
+ Lab 5: Do HeatWave Machine
Learning
+ Lab 6: Do HeatWave
Lakehouse
+ Lab 7: Build a LAMP
application with MySQL
HeatWave
+ Lab 8: (Bonus) Build a real-
time dashboard in Oracle
Navigation Menu > Networking > Virtual Cloud Networks
2. Open HEATWAVE-VCN
3. Click public subnet-HEATWAVE-VCN
4. Click Default Security List for HEATWAVE-VCN
5. Click Add Ingress Rules page under Ingress Rule
Add an Ingress Rule with Source CIDR
Copy
[Link]/0
Destination Port Range
Copy
80,443
Description
5 of 10 11/28/2023, 10:49 AM
Heatwave Airport for Partners - Advanced | Lab 1: Create MySQL Da... [Link]
Description
?
+ Introduction
Heatwave Airport for Partners - Advanced Copy
+ Get Started Allow HTTP connections
- Lab 1: Create MySQL
Database System 6. Click 'Add Ingress Rule'
Introduction
Task 1: Create Virtual
Cloud Network
Task 2: Configure security
list to allow MySQL
incoming connections
Task 3: Configure security
list to allow HTTP
incoming connections
Task 4: Create MySQL
Database for HeatWave
(DB System) instance
Acknowledgements
+ Lab 2: Connect to MySQL
HeatWave With Cloud Shell
Private Access and OCI Shell
+ Lab 3: Load HeatWave cluster
+ Lab 4: Run Queries in
HeatWave and MySQL
+ Lab 5: Do HeatWave Machine
Learning
+ Lab 6: Do HeatWave
Lakehouse
+ Lab 7: Build a LAMP
application with MySQL
HeatWave
+ Lab 8: (Bonus) Build a real- Click on Navigation Menu Databases MySQL
time dashboard in Oracle
6 of 10 11/28/2023, 10:49 AM
Heatwave Airport for Partners - Advanced | Lab 1: Create MySQL Da... [Link]
+ Introduction
Heatwave Airport for Partners - Advanced
+ Get Started
- Lab 1: Create MySQL
Database System
Introduction
Task 1: Create Virtual
Cloud Network
Task 2: Configure security
list to allow MySQL Setup the DB system
incoming connections
Create Administrator credentials
Task 3: Configure security
list to allow HTTP Configure Networking
incoming connections
Configure placement
Task 4: Create MySQL
Database for HeatWave Configure hardware
(DB System) instance
Exclude Backups
Acknowledgements
Set up Advanced Options
+ Lab 2: Connect to MySQL
HeatWave With Cloud Shell 4. For DB System Option Select Development or Testing
Private Access and OCI Shell
+ Lab 3: Load HeatWave cluster
+ Lab 4: Run Queries in
HeatWave and MySQL
+ Lab 5: Do HeatWave Machine
Learning
b. Enter Name
+ Lab 6: Do HeatWave
Lakehouse
Copy
+ Lab 7: Build a LAMP HEATWAVE-DB
application with MySQL
HeatWave
c. Enter Description
+ Lab 8: (Bonus) Build a real-
time dashboard in Oracle Copy
MySQL HeatWave Database Instance
d. Select Standalone and enable Configure MySQL HeatWave
Enter Password (write password to notepad for later use)
Confirm Password (value should match password for later use)
7 of 10 11/28/2023, 10:49 AM
Heatwave Airport for Partners - Advanced | Lab 1: Create MySQL Da... [Link]
+ Introduction
Heatwave Airport for Partners - Advanced
+ Get Started
- Lab 1: Create MySQL
Database System
b. Subnet: Private Subnet-HEATWAVE-VCN (Regional)
Introduction
Task 1: Create Virtual c. On Configure placement under 'Availability Domain'
Cloud Network
Select AD-1 … Do not check 'Choose a Fault Domain' for this DB System.
Task 2: Configure security
list to allow MySQL
incoming connections
Task 3: Configure security
list to allow HTTP
incoming connections
Task 4: Create MySQL
Database for HeatWave
(DB System) instance
Acknowledgements
+ Lab 2: Connect to MySQL
HeatWave With Cloud Shell
Private Access and OCI Shell
+ Lab 3: Load HeatWave cluster
b. For Data Storage Size (GB) Set value to: 1024
+ Lab 4: Run Queries in
HeatWave and MySQL
+ Lab 5: Do HeatWave Machine
Learning
+ Lab 6: Do HeatWave
Lakehouse
+ Lab 7: Build a LAMP
application with MySQL
HeatWave
+ Lab 8: (Bonus) Build a real-
time dashboard in Oracle
10. Click on Show Advanced Options
11. Go to the Networking tab, in the Hostname field enter (same as DB System Name):
Copy
HEATWAVE-DB
8 of 10 11/28/2023, 10:49 AM
Heatwave Airport for Partners - Advanced | Lab 1: Create MySQL Da... [Link]
+ Introduction
Heatwave Airport for Partners - Advanced
+ Get Started
- Lab 1: Create MySQL
Database System
Introduction
Task 1: Create Virtual
Cloud Network
Task 2: Configure security
list to allow MySQL
incoming connections
Task 3: Configure security
list to allow HTTP The state will be shown as 'Creating' during the creation
incoming connections
Task 4: Create MySQL
Database for HeatWave
(DB System) instance
Acknowledgements
+ Lab 2: Connect to MySQL
HeatWave With Cloud Shell
Private Access and OCI Shell
+ Lab 3: Load HeatWave cluster
+ Lab 4: Run Queries in
HeatWave and MySQL
+ Lab 5: Do HeatWave Machine
Learning
+ Lab 6: Do HeatWave
Lakehouse
+ Lab 7: Build a LAMP
application with MySQL
HeatWave
+ Lab 8: (Bonus) Build a real-
time dashboard in Oracle
Author - Perside Foster, MySQL Principal Solution Engineering
Contributors - Mandy Pang, MySQL Principal Product Manager, Nick Mader, MySQL Global Channel
Enablement & Strategy Manager
Last Updated By/Date - Perside Foster, MySQL Solution Engineering, July 2023
9 of 10 11/28/2023, 10:49 AM
Heatwave Airport for Partners - Advanced | Lab 1: Create MySQL Da... [Link]
?
+ Introduction
Heatwave Airport for Partners - Advanced
+ Get Started
- Lab 1: Create MySQL About Oracle Contact Us
Database System
Products A-Z Terms of Use & Privacy Cookie Preferences Ad Choices
Introduction
Task 1: Create Virtual
Cloud Network © Oracle
Task 2: Configure security
list to allow MySQL
incoming connections
Task 3: Configure security
list to allow HTTP
incoming connections
Task 4: Create MySQL
Database for HeatWave
(DB System) instance
Acknowledgements
+ Lab 2: Connect to MySQL
HeatWave With Cloud Shell
Private Access and OCI Shell
+ Lab 3: Load HeatWave cluster
+ Lab 4: Run Queries in
HeatWave and MySQL
+ Lab 5: Do HeatWave Machine
Learning
+ Lab 6: Do HeatWave
Lakehouse
+ Lab 7: Build a LAMP
application with MySQL
HeatWave
+ Lab 8: (Bonus) Build a real-
time dashboard in Oracle
10 of 10 11/28/2023, 10:49 AM