MySQL HeatWave on AWS Service Guide

Abstract

This document describes how to deploy and manage MySQL HeatWave on AWS. It covers registration, account management, user and group management, using the HeatWave Console to create and manage DB Systems and HeatWave Clusters, connecting, importing data, configuration, and performance monitoring.

For more information about using HeatWave and related utilities, refer to the MySQL HeatWave User Guide. For MySQL Server documentation, refer to the MySQL Reference Manual.

For information about the latest MySQL HeatWave features and updates, refer to the HeatWave Release Notes.

For legal information, see the Legal Notices.

For help with using MySQL, please visit the MySQL Forums, where you can discuss your issues with other MySQL users.

Document generated on: 2023-04-28 (revision: 75458)

Table of Contents

Preface and Legal Notices

1 Overview

1.1 MySQL Database

1.2 HeatWave

1.3 Integration with Oracle Cloud Infrastructure (OCI)

1.4 Regions and Availability Zones

1.5 Identity and Access Management

1.6 Security

2 Getting Started

2.1 Accessing MySQL HeatWave on AWS

2.2 Signing Up

2.2.1 Sign-up Overview

2.2.2 Sign-up Procedure

2.3 Signing In

2.4 Using the Console

2.4.1 Console Overview

3 DB Systems

3.1 About DB Systems

3.1.1 DB System Components

3.1.2 MySQL Server

3.2 Creating a DB System

3.3 Creating a MySQL Configuration

3.4 Managing a DB System

3.4.1 Stopping, Starting, or Restarting a DB System

3.4.2 Edit DB System

3.4.3 Update Networking

3.4.4 Update MySQL Configuration

3.4.5 Upgrade MySQL Version

3.4.6 Create Backup

3.4.7 Increasing DB System Storage

3.4.8 Deleting a DB System

3.5 Viewing DB System Details

3.5.1 MySQL DB System Details

4 HeatWave Clusters

4.1 Creating a HeatWave Cluster

4.1.1 Estimating Cluster Size with MySQL Autopilot

4.2 Managing a HeatWave Cluster

4.2.1 Starting, Stopping, or Restarting a HeatWave Cluster

4.2.2 Deleting a HeatWave Cluster

4.3 Viewing HeatWave Cluster Details

4.3.1 HeatWave Cluster Details

5 Connecting to a DB System

5.1 Connecting from the Console

5.2 Connecting from a Client

5.2.1 Connecting with MySQL Shell

5.2.2 Connecting with MySQL Command-Line Client

5.2.3 Connecting with MySQL Workbench

5.3 MySQL Connectors

5.4 Enabling Host Name Identity Verification

6 Importing Data

6.1 About MySQL Shell

6.2 MySQL Server Compatibility

6.3 Exporting Data with MySQL Shell

6.4 Importing Data with MySQL Shell

7 Manage HeatWave Data with Workspaces

8 Running Queries

8.1 Running HeatWave Queries

9 HeatWave AutoML

9.1 HeatWave AutoML Requirements

9.2 Create a HeatWave AutoML model

9.3 Evaluate a HeatWave AutoML model

10 System Variables

10.1 System Variables

11 Performance Monitoring

11.1 HeatWave Cluster Performance

11.1.1 HeatWave Cluster Performance Data

11.2 Workload Performance

11.2.1 HeatWave Workload Performance Data

11.3 Autopilot Shape Advisor

11.3.1 Autopilot Shape Advisor with MySQL HeatWave Console

11.3.2 Autopilot Shape Advisor with MySQL

12 Backups

12.1 Creating a Backup

12.2 Viewing Backup Details

12.2.1 Backup Details

12.3 Restoring a Backup to a New DB System

12.4 Deleting a Backup

13 Configuration

13.1 System Initialization Variables

13.2 User Configurable System Variables

13.3 User Configurable Shape Dependent System Variables

13.4 Service Specific System Variables

13.5 Shape Dependent System Variables

13.6 Session Variables

14 User and Group Management

14.1 Groups and Permissions

14.2 Groups and Policies

14.3 User Management

15 Account Management

15.1 Service Limits

15.2 Billing

16 Maintenance

17 Release Notes

17.1 Release notes for MySQL HeatWave on AWS (2023-4-27, General Availability)