Oracle Cloud Infrastructure Documentation

Viewing the DB System Status

The DB system status is a summary, aggregating information about health, connectivity, operational indicators, and transaction set on the DB system.

The DB system status also includes details that indicate whether the transactions through the inbound replication channel have been applied on the target. This information can be helpful in assessing whether the source and target are ready for a successful failover or switchover.

This task requires a DB system in ACTIVE state.

Use the following methods to view the DB system status:

Using the Console

Use the Console to view the DB system status.

  1. On the DB systems list page, find the DB system that you want to work with. If you need help finding the list page or the DB system, see Listing DB Systems - Using the Console.
    The details page opens and displays information about the DB system.
  2. To generate the DB system status if it is not already generated, in the DB system status section, click Generate.
    On the Generate DB system status pane that appears, do the following:
    1. From the GTID set type list in the GTID information section, select the type of GTID set for which you want to view the status. To generate status of the set of GTIDs executed on the DB system, select Executed, or to generate status of the set of GTIDs available in the DB system binary logs, select Available.
    2. To determine whether a specific GTID set has been applied on the DB system, specify the GTID set in the GTID set to apply field. Use the following format for specifying the GTID set: source_id:tag:transaction_id. For example: ed102faf-eb00-11eb-8f20-0c5415bfaa1d:Domain_1:117.
    3. If you have a replication channel associated with the DB system, to view the status of the channel, select the channel in the Channels section.
    4. Click Generate to generate the status and exit the Generate DB system pane.
    The DB system status generation work request is created. After the DB system generation work request completes, the DB system status section displays the date and time the DB system's runtime status was last updated, the work request state, and errors related to the work request, if any.
    Note

    The generated status expires after 12 hours, after which you need to generate the DB system status again. The DB system status shown is a point-in-time snapshot. To view the latest information, you must regenerate the DB system status.
  3. To regenerate the DB system status, select Regenerate from the Actions menu (three dots) in the DB system status section.
    The Generate DB system status pane appears. Repeat the steps to generate the DB system status.
    Note

    If the last generated status has not expired, the regenerate request overwrites it.
  4. To view the last generated DB system status, select View details from the Actions menu (three dots) in the DB system status section.
    The DB system status is displayed in the DB system status pane.

DB System Status

Use the DB system status pane to view the DB system status.

Table 8-15 DB system status

Field Description
Status Information
  • Last Update: Date and time the status was last generated.
  • Work request state: Whether the status generation work request was successful.
DB system information
  • Can accept client connections: Indicates if the read/write endpoint of the DB system can accept client connections.
  • Offline mode: Indicates if the DB system is in offline mode based on the value of the MySQL system variable offline_mode. If true, access is allowed to users with specific privileges only. If false, access is allowed to all MySQL users.
  • Writable: Indicates if connected users can run write queries on the DB system.
  • All MySQL instances healthy: Indicates if the single MySQL instance in a standalone DB system or all MySQL instances in a highly available DB system (excluding read replicas) are healthy.
  • Storage full: Indicates if there is any MySQL instance (excluding read replicas) whose storage capacity is below the storage reserve. See Overview of Health Monitor.
GTID information
  • GTID set: The GTID set thet you specified, either executed or available on the DB system.
  • GTID set applied: Indicates whether the GTID set that you specified was applied on the DB system.
Channels status A list that shows the status of the selected channels attached to the DB system.
  • Name: The display name of the channel.
  • State: Current state of the channel. See Resource: Channels for information on the channel states.
  • Enabled: Whether the channel is enabled.
  • Healthy: Indicates if the channel is healthy or not. If healthy, replication target DB system is connected to the source and no replication errors are seen.
  • Received GTID set applied: Indicates if all transactions received by this channel are executed and if their GTIDs are part of the GTID executed set.
  • Lag duration: The channel lag, with respect to the immediate source of the channel. If the channel is configured with replication delay, the channel lag includes the replication delay.
  • Errors: Identified channel errors, if any.
  • Created: Date and time the channel was created.