Open the navigation menu, and select Databases. Under HeatWave MySQL, click DB systems.
Click Create DB system.
Select one of the following:
Production: Set up a high availability DB system with the following default values suitable for a production environment:
High availability: Enabled
Shape: MySQL.8
Storage size: 1024GB
Automatic backups: Enabled
Point-in-time recovery: Enabled
Delete protected: Enabled
Automatic backups retention: Enabled
Final backup: Require final backup
Development or testing: Set up a standalone DB
system the following default values suitable for a development or testing
environment:
High availability: Disabled
Shape: MySQL.2
Storage size: 50GB
Automatic backups: Enabled
Point-in-time recovery: Enabled
Delete protected: Disabled
Automatic backups retention: Disabled
Final backup: Skip final backup
Provide DB system information:
Create in compartment: If you want to launch the DB
system in a compartment other than the current one, select the compartment
from the list.
Name: Specify a display name for the DB system. The
name need not be unique. An Oracle Cloud Identifier (OCID) uniquely
identifies the DB system.
Description: (Optional) Specify a description of the
DB System and its purpose.
Create Administrator credentials:
Username: Specify the user name of the administrator. See Reserved Usernames. The Administrator has a specific set of privileges that differs from the root user. See Default MySQL Privileges.
Password: Specify the administrator password.
Confirm password: Confirm the administrator password.
Note the username and password of the DB system administrator. You can later change the password using SQL commands such as ALTER USER or SET PASSWORD.
Select the type of DB system:
Standalone: Select for a single-instance DB system.
High availability: Select for a three-instance DB system that contains one primary instance and two secondary instances. If you select a regional subnet, the instances are spread across the availability domains. If you do not select a regional subnet, or your region comprises a single availability domain, the instances are spread across the fault domains. See High Availability.
Configure networking:
Virtual cloud network: Select the VCN in which you
want to create the DB system.
Subnet: Select the private subnet of your
VCN.
Configure placement:
Availability domain: For Standalone DB systems, specify the availability domain in which the DB system resides. For high availability DB systems, selecting an availability domain affects instance placement. See High Availability.
Choose a fault domain: Choose this option to enable
you to select a fault domain. If you do not choose a fault domain, Oracle
chooses one for you. See Fault
Domains.
Configure hardware:
Enable HeatWave cluster: Enabled by default. Deselect to create a DB system without HeatWave cluster.
Note
You can still add a HeatWave cluster to the DB system later if the DB system has a HeatWave cluster supported shape.
Shape details: If you want to change the default shape, click Change shape. In the Browse all shapes panel, do the following:
Select the compute model.
ECPU: Based on an architecture-agnostic of ECPU with an abstracted measure of CPU cores, memory, and other resources.
OCPU: Based on physical core of a processor with hyper-threading enabled. Filter the shapes by selecting the machine type:
All types: Displays all available shapes.
Virtual machine: Displays the Virtual Machine-based shapes only.
Bare metal: Displays the Bare Metal-based shapes only.
Note
All OCPU shapes are deprecated and are not available to new users created after Sept 5, 2024; existing users can still use them until Sept 5, 2025.
HeatWave cluster configuration: This option is shown when Enable HeatWave cluster is selected. If you want to change the default configuration, click Configure HeatWave cluster and do the following in the Configure HeatWave cluster panel:
Shape details: The shape for the HeatWave nodes. If you want to change the shape, click Change shape to select a shape for the HeatWave nodes. See Supported Shapes.
Node: Specify the number of HeatWave nodes to create. The minimum is 1 node and the maximum depends to the following:
HeatWave.Free shape: 1 node
HeatWave.32GB shape: 16 nodes
HeatWave.512GB or MySQL.HeatWave.VM.Standard shape: 64 nodes
HeatWave.512GB or MySQL.HeatWave.VM.Standard shape with Lakehouse enabled: 512 nodes
HeatWave Lakehouse: Enable query processing on the data residing in Object Storage. Prior to MySQL 8.4.0-u3, HeatWave Lakehouse is supported on the MySQL.HeatWave.VM.Standard and HeatWave.512GB shapes only. See HeatWave Lakehouse.
Note
Prior to MySQL 8.3.0-u2, you must disable point-in-time recovery, high availability, read replicas, and outbound replication in order to enable HeatWave Lakehouse.
Click Save changes.
Storage size: Configure the storage size of the DB system. The data storage size is independent of the shape you select.
Initial data storage size (GB): Specify the initial data storage size, in GB, to allocate to the DB system. The value should be greater than 50 and less than 131072.
The initial storage value has an impact on your ability to increase the storage size later and the performance of the increased storage. See DB System Storage. Also, if you are importing data, ensure you specify sufficient data storage.
Automatic storage expansion: Enable automatic data storage expansion when space usage grows near to the database instance Health Monitor read-only limits for any instance in the DB system.
Note
Automatic storage expansion is enabled by default when high availability is enabled, and it cannot be disabled.
Maximum data storage size (GB): Specify the maximum data storage size, in GB, to which the storage size can be expanded. The value must be greater than the initial data storage size.
Note
Whenever the storage size is expanded, the billing for storage usage will increase accordingly. Use the maximum storage size to prevent cost overrun.
Configure backup plan:
Enable automatic backups: (Optional) Select the option to enable automatic backups. If you do not select automatic backups, manage your backups manually. It is recommended to enable automatic backups.
Backup retention period: (Optional) Specify how many days you want to retain the backup. By default, the DB system retains the backup for seven days. Once you define the retention period of an automatic backup, you can not edit it later.
Enable point-in-time recovery: (Optional) Select the option to enable you to restore a DB system at a point-in-time to a new DB system.
Select backup window: (Optional) Select the option to enable you to select the backup window start time.
Window start time: (Optional) Specify the time (in UTC timezone) when you want to start the backup of your DB system. Your backup starts in the 30 minutes following the window start time.
Note
Do not set the backup window start time too near to the maintenance window start time. The automatic backup cannot start if a conflicting operation such as maintenance or upgrade is currently running. It has to wait until the conflicting operation completes. If the conflicting operation does not complete within two hours of the backup window start time, the automatic backup will be skipped and it will try again in the next backup window in the following day.
Show backup windows per region: (Optional) Click the option to see the default window start time of your region.
Provide contacts for operational notifications and announcements: (Optional) Enter one or more contact emails to receive operational notices and announcements as well as scheduled and unplanned maintenance notifications. Click Add contact to add more contacts. You can add up to a maximum of 10 contacts. Duplicate and invalid email addresses are not allowed.
Note
Oracle recommends that you set the contact emails so that administrators receive notifications related to the DB system.
Show advanced options: Click to open a group of tabs that enable you to
further configure the DB system. See Advanced Options.
To create the DB system, click Create.
(Optional) To save the resource configuration as a stack, click Save as
stack. You can later use the stack to install, configure, and manage the
resources through the Resource Manager service. See Managing Stacks.
adminUsername: Specify the username of the root user of
the DB system. Some usernames are reserved and you cannot use them in the definition
of a DB system. See Reserved Usernames.
adminPassword: Specify the password of the root user of
the DB system.
compartmentId: Specify the OCID of the compartment in
which you create the DB system.
availabilityDomain: Specify the name of the
availability domain in which you create the DB system.
configurationID: (Optional) Specify the OCID of the
configuration to apply to the DB system. If you do not define a configuration ID, the
DB system uses the default configuration associated with the selected shape. If you
define a custom configuration, use the same shape as you define in the request.
shapeName: Specify the name of the shape. For example, MySQL.8.
subnetId: Specify the OCID of the VCN subnet to which
the DB system is attached.
dataStorageSizeInGbs: Specify the amount of data storage, in GBs, for the DB system. The value should be greater than 50 and less than 131,072, and ensure you define enough storage to accommodate imported data. The data storage size is independent of the shape you select.
hostnameLabel: (Optional) Specify the hostname for
your DB system. The option is available only if you enable USE DNS HOSTNAMES
IN THIS VCN option on the selected VCN. The hostname must begin with an
alphabetic character, contain only alphanumeric characters and hyphens (-), and not
use more than 30 characters. The hostname must be unique within the subnet. If it is
not unique, the DB system fails to provision. When you specify a hostname, Oracle
assigns it to the VCN and subnet domain, which is automatically created during the
instance launch, in the following
format:
<hostnameLabel>.<subnet DNS label>.<VCN DNS label>.oraclevcn.com
For
example, if you specify a value of myhost for
hostnameLabel, on a subnet named myprivatesubnet,
on a VCN named myvcn the fully qualified domain name of your DB
system is set to the
following:
myhost.myprivatesubnet.myvcn.oraclevcn.com
description: (Optional) Specify a brief description of
the DB system.
displayName: (Optional) Specify the display name of the
DB system. If you do not define a display name, Oracle generates one for you in the
format mysqldbsystemYYYYMMDDHHMMSS.
backupPolicy: (Optional) Specify the container for the
backup policy parameters. The following parameters define the schedule for automatic
backups of your DB system:
isEnabled: Set it to true to
enable backups.
retentionInDays: Specify the number of days to
retain the automatic backups. By default, your data is retained for seven
days.
windowStartTime: Specify the start of a 30-minute
window for your daily automated backups. It uses the UTC timezone in
HH:MM format. You can also define offsets, for example:
00:00-08:00, which sets the time to 8 hours behind midnight
UTC.
pitrPolicy: Set isEnabled to true to enable point-in-time recovery that restores data from a DB system to a new DB system at a given point-in-time.
source: (Optional) Specify the container for the
import parameters. The following parameters specify the data import type and source
URL:
sourceType: IMPORTURL: Specify
the import type as a PAR URL.
sourceUrl: Specify the Pre-Authenticated Request
(PAR) URL for the bucket or bucket prefix.
mysqlVersion: (Optional) Specify the version of MySQL
to use in your DB system. If you do not specify it, the latest available version is
used. See DB System Upgrades and MySQL Server Versions.
c: Specify the OCID of the compartment in
which you create the DB system.
configuration-id: (Optional) Specify the
OCID of the configuration to apply to the DB system. If you do not
define a configuration ID, the DB system uses the default configuration
associated with the selected shape. If you define a custom
configuration, use the same shape as you define in the request.
shape-name: Specify the name of the shape. For example, MySQL.8.
availability-domain: Specify the name of
the availability domain in which you create the DB system.
subnet-id: Specify the OCID of the VCN
subnet to which the DB system is attached.
admin-username: Specify the username of the
root user of the DB system. Some usernames are reserved and you cannot
use them in the definition of a DB system. See Reserved Usernames.
admin-password: Specify the password of the
root user of the DB system.
data-storage-size-in-gbs: Specify the amount of data storage, in GBs, for the DB system. The value should be greater than 50 and less than 131,072, and ensure you define enough storage to accommodate imported data. The data storage size is independent of the shape you select.
display-name: (Optional) Specify the
display name of the DB system. If you do not define a display name,
Oracle generates one for you in the format
mysqldbsystemYYYYMMDDHHMMSS.
description: (Optional) Specify a brief
description of the DB system.
hostname-label: (Optional) Specify the
hostname for your DB system. The option is available only if you enable
USE DNS HOSTNAMES IN THIS VCN option on the
selected VCN. The hostname must begin with an alphabetic character,
contain only alphanumeric characters and hyphens (-), and not use more
than 30 characters. The hostname must be unique within the subnet. If it
is not unique, the DB system fails to provision. When you specify a
hostname, Oracle assigns it to the VCN and subnet domain, which is
automatically created during the instance launch, in the following
format:
<hostnameLabel>.<subnet DNS label>.<VCN DNS label>.oraclevcn.com
For
example, if you specify a value of myhost for
hostnameLabel, on a subnet named
myprivatesubnet, on a VCN named
myvcn the fully qualified domain name of your DB
system is set to the
following:
myhost.myprivatesubnet.myvcn.oraclevcn.com
backup-policy: (Optional) Specify the
container for the backup policy parameters. The following parameters
define the schedule for automatic backups of your DB system:
isEnabled: Set it to
true to enable backups.
retentionInDays: Specify the
number of days to retain the automatic backups. By default, your
data is retained for seven days.
windowStartTime: Specify the start
of a 30-minute window for your daily automated backups. It uses
the UTC timezone in HH:MM format. You can also
define offsets, for example: 00:00-08:00, which
sets the time to 8 hours behind midnight UTC.
pitr-policy: Set isEnabled to true to enable point-in-time recovery that restores data from a DB system to a new DB system at a given point-in-time.
source: (Optional) Specify the container
for the import parameters. The following parameters specify the data
import type and source URL:
sourceType:
IMPORTURL: Specify the import type as a PAR
URL.
sourceUrl: Specify the
Pre-Authenticated Request (PAR) URL for the bucket or bucket
prefix.
mysqlVersion: (Optional) Specify the
version of MySQL to use in your DB system. If you do not specify it, the
latest available version is used. See DB System Upgrades and MySQL Server Versions.
The command creates a DB system with backup and imports data from Object
Storage using a pre-authenticated request (PAR) URL and you get a response similar
to the following, which summarizes the request and creates your DB system: