Documentation Home
MySQL HeatWave on AWS
Download this Manual
PDF (US Ltr) - 1.1Mb
PDF (A4) - 1.1Mb

MySQL HeatWave on AWS Service Guide


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 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-01-30 (revision: 74918)

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 Managing a DB System
3.3.1 Stopping, Starting, or Restarting a DB System
3.3.2 Editing a DB System
3.3.3 Upgrading MySQL Server
3.3.4 Increasing DB System Storage
3.3.5 Deleting a DB System
3.4 Viewing DB System Details
3.4.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 Managing HeatWave Data
8 Running Queries
8.1 Running HeatWave Queries
9 Performance Monitoring
9.1 HeatWave Cluster Performance
9.1.1 HeatWave Cluster Performance Data
9.2 Workload Performance
9.2.1 HeatWave Workload Performance Data
10 Backups
10.1 Creating a Backup
10.2 Viewing Backup Details
10.2.1 Backup Details
10.3 Restoring a Backup to a New DB System
10.4 Deleting a Backup
11 Configuration
11.1 User-Settable Session Variables
11.2 Global System Variables
11.3 Shape-Dependent Global System Variables
12 User and Group Management
12.1 Groups and Permissions
12.2 Groups and Policies
12.3 User Management
13 Account Management
13.1 Service Limits
13.2 Billing
14 Maintenance