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


MySQL HeatWave on AWS  /  DB Systems  /  Creating a DB System

3.2 Creating a DB System

This topic describes how to create a new DB System. A HeatWave Cluster is created by default when creating a DB System.

  1. In the MySQL HeatWave Console, select the MySQL tab.

  2. On the DB Systems panel, click Create MySQL DB System to open the Create MySQL DB System and HeatWave Cluster dialog.

  3. Provide the Basic information for the DB System:

    • Display Name: Specify a display name for the DB system or use the generated default name.

    • Description: Specify a user-friendly description of the DB System.

  4. Specify the Administrator credentials for the MySQL DB System.

    • Username: Specify a user name for the MySQL Administrator user (1 to 32 characters). The MySQL Administrator user is granted a specific set of MySQL Server privileges. For more information, see Section 3.1.2.9, “Default MySQL Privileges”.

      Certain names are reserved and cannot be used. See Section 3.1.2.10, “Reserved User Names”.

    • Password: Specify a MySQL Administrator password. The password must be 8 to 32 characters including at least one number, one uppercase letter, one lowercase letter, and one special (nonalphanumeric) character.

    • Confirm Password: Re-enter the MySQL Administrator password.

  5. Select the Hardware shape.

    • Shape: Select the shape to use for your DB system. The shape determines the resources allocated to the system. For information about shapes, see Supported Shapes. Selecting a MySQL shape for a DB System also selects the configuration associated with that shape. See Chapter 11, Configuration.

      Note

      Changing the MySQL shape later is not supported. To use a different shape requires creating a new DB System. You can restore the data from a backup of the old DB System to the new DB System.

    • Data Storage Size (GiB): Specify the amount of block storage, in GiB, to allocate to the DB System. This block storage stores all data, logs, and temporary files. Binaries are not stored in this block storage. The maximum storage allocation is 16384 GiB.

      Note

      If you are importing data, ensure that you specify sufficient data storage for the data you are importing.

    • Database Version: Select the MySQL Server version you want to deploy. The latest MySQL Server version is selected by default.

    • Maintenance Window: Select the start time for the maintenance window, which is a two-hour period. When updates are available, they are initiated during this window. The time required to apply patches and updates may extend beyond the maintenance window and require DB System restarts. For more information, see Chapter 14, Maintenance.

      • Select Automatic to have a maintenance window Start day and Start time chosen for you.

      • Select Manual to specify your own maintenance window Start day and Start time. Time is specified in Coordinated Universal Time (UTC).

      You can modify the Maintenance Window later by editing the DB System. See Section 3.3.2, “Editing a DB System”.

  6. Configure the Availability zone, which determines the physical location of the DB System:

    • Select Automatic to have the physical AWS Availability Zone selected for you.

    • Set Manual to select the physical AWS Availability Zone where the DB System will be created.

    Note

    A physical Availability Zone is identified by an Availability Zone ID (AZ ID). For information about AZ IDs and how to view them, see Availability Zone IDs for your AWS resources, in the AWS RAM User Guide. To help maximize performance, try to place the DB System in the same Availability Zone as the applications that will be using the HeatWave Cluster.

  7. Configure Networking settings:

    • Allowed Client Addresses: Specify the public-facing client IPv4 addresses that are permitted to connect to the DB System endpoint. These must all be public IP addresses (capable of accessing the Internet), not private IP addresses. For example, you might want to include any of the following:

      • The public IP address for the system you are using to set up MySQL HeatWave on AWS

      • The public IP address for a system that will be used by an administrator to manage the HeatWave Cluster

      • The public IP addresses of application servers where client applications that will use the HeatWave Cluster are running

      • A public IP address range assigned to your organization

      The IP addresses are specified in CIDR format; for example: 1.2.3.4/24. Multiple addresses in CIDR format can be specified in a semicolon-separated list; for example: 1.2.3.4/24; 1.2.3.4/32.

      CIDR (Classless Inter-Domain Routing) notation permits specifying a range of IP addresses in a single address. A CIDR address looks like a regular IP address but is suffixed with a forward slash followed by a number. The number is a compact representation of the subnet mask; for example, /24 is equivalent to 255.255.255.0, where 24 is the number of bits in the binary representation of 255.255.255.0 (11111111.11111111.11111111.00000000). 1.2.3.4/24 is equivalent to 1.2.3.4/255.255.255.0, which permits this IP address range: 1.2.3.0 to 1.2.3.255.

      The following table shows common subnet masks, the equivalent CIDR notation, and the number of IP addresses in the range.

      Table 3.3 CIDR Notation Examples

      Subnet Mask CIDR Notation Number of IP Addresses
      255.0.0.0 /8 16777216
      255.255.0.0 /16 65536
      255.255.255.0 /24 256
      255.255.255.128 /25 128
      255.255.255.192 /26 64
      255.255.255.224 /27 32
      255.255.255.240 /28 16
      255.255.255.248 /29 8
      255.255.255.252 /30 4
      255.255.255.254 /31 2
      255.255.255.255 /32 1

      You can specify a combination CIDR addresses to permit a specific range of IP address; for example, to permit five IP addresses in the range of 192.0.2.0 to 192.0.2.4, you would specify the following CIDR addresses: 192.0.2.0/30; 192.0.2.4/32. To permit a single IP address such as 192.0.2.10, you would specify 192.0.2.10/32. More information about CIDR notation including IP range to CIDR calculators can be found by searching online.

    • Port: The port on which the MySQL server listens. The default is port 3306. You can specify a port number between 1024 and 65535.

    • X Protocol Port: The X Protocol port on which the MySQL server listens, supported by clients such as MySQL Shell. The default port is 33060. You can specify a port number between 1024 and 65535.

  8. Click Next.

  9. Provide the Basic information for the HeatWave Cluster:

    • Display Name: Specify a display name for the HeatWave Cluster or use the generated default name.

    • Description: Specify a user-friendly description of the HeatWave Cluster.

  10. Specify the HeatWave Cluster configuration:

    • Shape: Select the shape to use for your HeatWave Cluster. The shape determines the resources allocated to each HeatWave node. For information about shapes, see Supported Shapes.

      Changing the HeatWave Cluster shape later is not supported. To use a different shape requires removing the existing HeatWave Cluster and creating a new one.

      Note

      If you intend to use HeatWave AutoML functionality, the HeatWave.256GB node shape is recommended when creating a HeatWave Cluster. The HeatWave.16GB node shape may not have enough memory for training on large data sets. If you see error messages about this (such as ML003024), use the larger shape instead.

    • Cluster Size: Specify the size of the cluster (the number of HeatWave nodes). You can specify a number between 1 and 128.

      Tip

      Because the new DB System does not yet contain any data, you cannot use MySQL Autopilot to estimate the required cluster size (as described in Section 4.1.1, “Estimating Cluster Size with MySQL Autopilot”). If you want to make an estimate, after loading the data to the DB System, you can delete the HeatWave Cluster and create a new one following the instructions in Section 4.1, “Creating a HeatWave Cluster”.

  11. Click Create.

    Your are returned to the DB Systems page where you can monitor the state of the operation, which may take some time to complete. The state will change from Creating to Active when the operation has completed successfully.