HeatWave on AWS  /  ...  /  MySQL DB System Details

3.5.1 MySQL DB System Details

The MySQL DB System Details page has the following tabs.

Table 3-7 Tabs on the MySQL DB System Details Page

Name Description
Details DB System details summary. See Table 3-8.
Backups DB System backup details. See Table 3-9.
PrivateLinks List of PrivateLinks whose targets are this DB System. Click on each PrivateLink to see Table 3-10.
Shape Advisor Shape Advisor details. See Auto Shape Prediction Data.
Metrics Details on the resources used by the DB System. See Table 3-11.
Events DB System event details. See Table 3-12.

Table 3-8 MySQL DB System Details Summary

Field Description
General Information
  • Name: The name of the DB System.
  • State: The state of the DB System:
    • CREATING: Resources are being reserved for the DB System, the system is booting, and the initial database is being created. Creating can take several minutes. The system is not ready to use yet.
    • ACTIVE: The DB System was successfully created and is ready to be used.
    • STARTING: The DB System is being started.
    • STOPPING: The DB System is being stopped.
    • RESTARTING: The DB System is being restarted.
    • INACTIVE: The DB System is powered off.
    • UPDATING: The DB System is in the process of being updated.
    • UPGRADING: The DB System is in the process of being upgraded.
    • DELETING: The DB System is being deleted.
    • DELETED: The DB System has been deleted and is no longer available.
    • FAILED: An error condition prevented the creation or continued operation of the DB System.
    • STARTING_ERROR: An attempt to start the DB System failed.
    • STOPPING_ERROR: An attempt to stop the DB System failed.
    • RESTARTING_ERROR: An attempt to restart the DB System failed.
    • UPDATING_ERROR: An attempt to update the DB System failed.
    • UPGRADING_ERROR: An attempt to upgrade the DB System failed.
    • DELETING_ERROR: An attempt to delete the DB System failed.
  • Resource ID: The unique resource identifier assigned to the DB System when it is created.
  • Description: The user-defined description of the DB System.

  • Last Updated: The date and time the DB System was last updated.

  • Created: The date and time the DB System was created.

DB System Configuration
  • High Availability: Whether High Availability is enabled for the DB System.

  • Shape: The resource template for the MySQL instance. For information about shapes, see Supported Shapes.
  • Storage Size: The amount of storage available to the DB System.

  • vCPU count: The number of vCPUs of the DB System.

  • Memory: The size of the RAM of the DB System.

  • MySQL version: The MySQL Server version used by the DB System.

  • MySQL Configuration: The MySQL Configuration of the DB System.

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

Networking
  • Accessibility: Whether the DB System is accessible via the public internet (see Allowed public IP address ranges), PrivateLink, or console only.
  • Require SSL: Whether connections to the DB System require encryption.
  • Hostname: The host name of the DB System. The host name is a fully qualified domain name (FQDN).
  • PrivateLink Hostname Use this hostname to connect to the DB System over PrivateLink.
  • MySQL Port: The port on which the MySQL Server listens.
  • MySQL Port X: The port on which the MySQL Server listens for clients using MySQL X Protocol.

  • Allowed public IP address ranges: The public-facing client IPv4 addresses that are permitted to connect to the DB System endpoint, specified in CIDR format. For information about how IP addresses are specified in CIDR format, see Creating a DB System.

Placement The physical Availability Zone(s) where the DB System resides.
  • For a standalone DB System: Availability Zone of the DB System.

  • For a High Availability DB System:
    • Preferred Availability Zone for the primary instance.
    • Current Availability Zone of the primary instance.
    • Secondary Availability Zones of the secondary instances.
IAM roles
HeatWave Cluster
  • Name: The name of the HeatWave Cluster.

  • State: The state of the HeatWave Cluster.

    • CREATING: Resources are being reserved for the HeatWave Cluster, and the cluster is being created. Creating can take several minutes. The system is not ready to use yet.

    • ACTIVE: The HeatWave Cluster was successfully created and is ready to be used.

    • STARTING: The HeatWave Cluster is being started.

    • STOPPING: The HeatWave Cluster is being stopped.

    • RESTARTING: The HeatWave Cluster is being restarted.

    • INACTIVE: The HeatWave Cluster is powered off.

    • UPDATING: The HeatWave Cluster is in the process of being updated.

    • UPGRADING: The HeatWave Cluster is in the process of being upgraded.

    • DELETING: The HeatWave Cluster is being deleted.

    • DELETED: The HeatWave Cluster has been deleted and is no longer available.

    • FAILED: An error condition prevented the creation or continued operation of the HeatWave Cluster.

    • STARTING_ERROR: An attempt to start the HeatWave Cluster failed.

    • STOPPING_ERROR: An attempt to stop the HeatWave Cluster failed.

    • RESTARTING_ERROR: An attempt to restart the HeatWave Cluster failed.

    • UPDATING_ERROR: An attempt to update the HeatWave Cluster failed.

    • UPGRADING_ERROR: An attempt to upgrade the HeatWave Cluster failed.

    • DELETING_ERROR: An attempt to delete the HeatWave Cluster failed.

  • Node count: The number of Table 8-4 nodes.

Backup policy
  • Automatic backups: Is automatic backups Enabled or Disabled.
  • Retention in days: Backup retention period in days.
  • Window start hour: The time to start a backup.
Channel
  • Channel name: Name of the inbound replication channel.
  • State: State of the inbound replication channel. See Table 8-4 for the list of possible states.
  • Enabled: Whether the inbound replication channel is enabled.

Table 3-9 MySQL DB System Backup Details

Field Description
Name The name of the backup
State

The state of the backup

  • CREATING: Resources are being reserved for the DB System backup and the backup is being created. Creating can take several minutes. The backup is not ready to use yet.

  • ACTIVE: The backup was successfully created.

  • UPDATING: The backup is in the process of being updated.

  • INACTIVE: The backup is not available.

  • DELETING: The backup is being deleted.

  • DELETED: The backup has been deleted and is no longer available.

  • FAILED: An error condition prevented the creation or continued availability of the backup.

Snapshot DB System ID The ID of the DB System used to create the backup.
Snapshot DB System The name of the DB System used to create the backup.
Type Type of backup: Scheduled or Manual
Size (GiB) The size of the backup - note that a backup is the size of the whole storage allocation for the DB System from which it was created, even if the volume does not contain that much data.
Created The date and time the backup was created.

See Backups for details on MySQL DB System backups.

Table 3-11 MySQL DB System Metrics

Field Description
CPU Utilization The percentage of CPU utilization on the MySQL DB System.
Memory Utilization The percentage of memory utilization on the MySQL DB System,
Disk Utilization The message body of the event report.
Disk Usage The date and time the event report was created.
Disk Operations The number of disk operations on the MySQL DB System (write, read, and miscellaneous).
Connections The number of idle and active client connections on the MySQL DB System.
Buffer Pool The buffer pool size on the MySQL DB System.

Table 3-12 MySQL DB System Event Details

Field Description
Type The event and its status.
Severity The severity level of the event, which can be one of
  • INFO: General information is provided. No special concerns
  • WARNING: Warning on an event that might impact the DB System's operation if no actions are taken.
  • CRITICAL: A critical event. An urgent action is required to avoid adverse impact on your DB System.
Message The message body of the event report.
Created The date and time the event report was created.

See Events for details on event reports.