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)