Viewing DB System Details
View the DB system details page to see information about the DB system and the resources associated with it.
Using the Console
Use the Console to view the details of a DB system.
- Open the navigation menu and select Databases. Under HeatWave MySQL, click DB systems.
- Choose your compartment from the List scope.
- In the list of DB systems, click the name of the DB system to open the DB system details page.
DB System Details
Use the DB system details page to see information about the DB system and the resources associated with it.s
Table 8-3 DB System Details page
Name | Description |
---|---|
DB system information | Summary information about this DB system and its configuration. See DB System Information. |
Connections | Details about networking, endpoint, and security certificate. See Connections. |
Tags | Details about the tags present on this DB system. See Managing Tags. |
Resources |
|
DB System Information
Use the DB system information section of the DB system details page to see an overview of the DB system's configuration and resources.
Table 8-4 DB system Information
Field | Description |
---|---|
General information |
|
DB system configuration |
|
Backup |
|
Maintenance |
|
Associated services |
|
High availability |
|
HeatWave cluster |
|
Deletion plan |
|
Placement |
|
Read replicas |
|
Inbound replication channel | Displayed only if a channel is associated with the DB
system. See Inbound Replication.
|
Connections
Use the Connections section of the DB system details page to see the details of networking, endpoints and securty certificate.
Table 8-5 DB system Information
Field | Description |
---|---|
Networking |
|
Security certificate | The details you see depends on the settings in Advanced Option: Connections:
|
Primary endpoint |
|
Resource: Metrics
The Metrics resource on the DB system details page shows measurements of resource utilization in the DB system, such as its CPU and memory utilization and disk activity.
Table 8-6 DB System Metrics
Field | Description |
---|---|
Start/end time | Specify a time range for the metric display. |
Quick selects | Select a predefined range. |
Metric graphs | For more information on the DB system metrics, see Events. |
Filters: Metrics data | Displayed only for DB systems with HeatWave clusters attached. Filters the metric
data. The following selections are possible:
|
Aggregated HeatWave cluster metrics data | Displays the aggregated metric data for the HeatWave cluster attached to the DB
system.
|
Resource: Endpoints
The Endpoints resource on the DB system details page shows the details and current state of the DB system's read/write endpoint, which clients and connectors can use to connect to the MySQL instance.
Table 8-7 Endpoints Overview
Field | Description |
---|---|
Endpoint | The name of the endpoint. |
State | Current state:
|
Modes | One of the following values:
|
Type | The type of the endpoint:
|
Hostname | The hostname of the endpoint. If you did not define a hostname, this field is left blank. |
Address | The IP address of the endpoint. |
Database port | The classic MySQL protocol port of the endpoint. Default is 3306. |
Database X protocol port | The MySQL X Protocol port of the endpoint. |
Resource: Read Replicas
The Read replicas resource on the DB system details page shows the details and current state of the read replicas present on the DB system.
Table 8-8 Read Replicas Overview
Field | Description |
---|---|
Name | The name of the read replica. |
State | Current state:
|
Address | The IP address of the read replica. |
Created | The date and time the read replica was created. |
Last updated | The date and time the read replica was last updated. |
Resource: HeatWave cluster
The HeatWave cluster resource on the DB system details page shows information related to the HeatWave cluster and nodes. You can view and manage the HeatWave cluster attached to this DB system.
Table 8-9 HeatWave Cluster Information
Field | Description |
---|---|
Shape | The shape used for HeatWave cluster nodes. |
State | The state of the HeatWave cluster. See HeatWave Cluster States. |
Node | The number of nodes in the cluster. |
Memory | The amount of RAM allocated to the HeatWave cluster, which depends on the number of nodes you select. |
HeatWave Lakehouse | Displays whether HeatWave Lakehouse is enabled or disabled. |
Created | The date and time the HeatWave cluster was created. |
Last updated | The date and time the HeatWave cluster was last updated. |
Table 8-10 HeatWave nodes
Column | Description |
---|---|
Node Id | The name of the HeatWave node. |
State | Current state of the HeatWave node. See HeatWave Cluster States. |
Created | The date and time the HeatWave node was created. |
Resource: Backups
The Backups resource on the DB system details page shows the details of the backup plan for the DB system, and lists all backups of the DB system.
Table 8-11 Backups Overview
Field | Description |
---|---|
Create Manual Backup | Opens the Create manual backup dialog box. |
Name | Name of the backup |
State | State of the backup |
Retention Days | Retention period of the backup. |
Size | The size of the backup. |
Created | The date the backup was created. |
Actions (three dot) menu |
The Actions (three dot) menu contains the following:
|
Resource: Channels
The Channels resource on the DB system details page shows the replication channels that are configured for this DB system, and their current status.
Table 8-12 Channels Overview
Field | Description |
---|---|
Name | The display name of the channel. |
Source | The IP address or hostname of the MySQL Source. |
Target | The name of the target DB system. |
State | Current state:
|
Details | Information or errors relating to the current state of the channel. |
Enabled | Whether the channel is enabled. |
Created | Date and time the channel was created. |
Actions menu | The actions (three dot) menu contains the following:
|
Resource: Work Requests
The Work requests resource on the DB system details page lists the activity logs for ongoing and recent operations on the DB system. Work requests are retained for 12 hours.
Table 8-13 Work Requests
Field | Description |
---|---|
Operation | One of the following operation names:
For more information on Work Requests, see Work Request Overview. |
State | Current state:
|
Progress | A progress bar for the work request. |
% Complete | The percentage completion. |
Accepted | Date and time the operation was accepted. |
Started | Date and time the operation started. |
Finished | Date and time the operation finished. |
Action menu (3 dots) | Opens the Action menu. The following actions are possible:
|
Using the CLI
Use the command-line interface to view the details of a DB system.
- A DB system Oracle Cloud Identifier (OCID).
- A properly configured CLI installation and the requisite SSH keys. See Command Line Interface.
oci mysql db-system get
command validates and runs
successfully, you get a response similar to the following, which retreives the DB system
details:{
"data": {
"availability-domain": "UK-CARDIFF-1-AD-1",
"backup-policy": {
"defined-tags": null,
"freeform-tags": null,
"is-enabled": true,
"pitr-policy": {
"is-enabled": false
},
"retention-in-days": 10,
"window-start-time": "03:42"
},
"channels": [],
"compartment-id": "ocid1.compartment.oc1..<ID>",
"configuration-id": "ocid1.mysqlconfiguration.oc1..<ID>",
"crash-recovery": "ENABLED",
"current-placement": {
"availability-domain": "UK-CARDIFF-1-AD-1",
"fault-domain": "FAULT-DOMAIN-1"
},
"data-storage-size-in-gbs": 1024,
"defined-tags": {
"Oracle-Tags": {
"CreatedBy": "<Username>",
"CreatedOn": "2023-04-18T07:00:48.996Z"
}
},
"deletion-policy": {
"automatic-backup-retention": "RETAIN",
"final-backup": "REQUIRE_FINAL_BACKUP",
"is-delete-protected": true
},
"description": null,
"display-name": "mysql20230418075107",
"endpoints": [
{
"hostname": null,
"ip-address": "10.0.1.99",
"modes": [
"READ",
"WRITE"
],
"port": 3306,
"port-x": 33060,
"resource-id": "ocid1.mysqlinstance.oc1.<ID>",
"resource-type": "DBSYSTEM",
"status": "ACTIVE",
"status-details": null
}
],
"fault-domain": "FAULT-DOMAIN-1",
"freeform-tags": {
"Template": "Production"
},
"heat-wave-cluster": null,
"hostname-label": null,
"id": "ocid1.mysqldbsystem.oc1.uk-cardiff-1.<ID>",
"ip-address": "10.0.1.99",
"is-heat-wave-cluster-attached": false,
"is-highly-available": false,
"lifecycle-details": null,
"lifecycle-state": "UPDATING",
"maintenance": {
"window-start-time": "THURSDAY 05:50"
},
"mysql-version": "8.0.32",
"point-in-time-recovery-details": null,
"port": 3306,
"port-x": 33060,
"shape-name": "MySQL.VM.Standard.E4.4.64GB",
"source": null,
"subnet-id": "ocid1.subnet.oc1.uk-cardiff-1.<ID>",
"time-created": "2023-04-18T07:00:50.576000+00:00",
"time-updated": "2023-04-18T07:46:27.778000+00:00"
},
"etag": "qw1212cee7aff69c2880adc9c432f9eda03f978320e6719c4006c89--gzip"
}