Oracle Cloud Infrastructure Documentation

MySQL HeatWave: DB System Event Types

MySQL HeatWave DB systems emit the DB systems events.

Table 18-1 MySQL HeatWave: DB System Event Types

Friendly Name Event Type Details
MySQL - Create DB System Begin com.oraclecloud.mysqlaas.createdbsystem.begin  
MySQL - Create DB System End com.oraclecloud.mysqlaas.createdbsystem.end  
MySQL - Delete DB System Begin com.oraclecloud.mysqlaas.deletedbsystem.begin  
MySQL - Delete DB System End com.oraclecloud.mysqlaas.deletedbsystem.end  
MySQL - Automatic Recovery Begin com.oraclecloud.mysqlaas.automaticrecovery.begin Indicates the start of any of the following event:
  • Failover of a high availability DB system: The additionalDetails.isFailover property is set to true in a failover. See Failover.
  • Recovery of a read replica: The read replica is added or removed from the read replica load balancer.
  • Recovery of a secondary instance of a high availability DB system
MySQL - Automatic Recovery End com.oraclecloud.mysqlaas.automaticrecovery.end Indicates the end of any of the following event:
  • Failover of a high availability DB system: The additionalDetails.isFailover property is set to true in a failover. See Failover.
  • Recovery of a read replica: The read replica is added or removed from the read replica load balancer.
  • Recovery of a secondary instance of a high availability DB system
MySQL - Restart DB System Begin com.oraclecloud.mysqlaas.restartdbsystem.begin  
MySQL - Restart DB System End com.oraclecloud.mysqlaas.restartdbsystem.end  
MySQL - Start DB System Begin com.oraclecloud.mysqlaas.startdbsystem.begin  
MySQL - Start DB System End com.oraclecloud.mysqlaas.startdbsystem.end  
MySQL - Stop DB System Begin com.oraclecloud.mysqlaas.stopdbsystem.begin  
MySQL - Stop DB System End com.oraclecloud.mysqlaas.stopdbsystem.end  
MySQL - Update DB System Begin com.oraclecloud.mysqlaas.updatedbsystem.begin  
MySQL - Update DB System End com.oraclecloud.mysqlaas.updatedbsystem.end  
MySQL - Upgrade DB System Begin com.oraclecloud.mysqlaas.upgradedbsystem.begin Indicates the start of a MySQL version upgrade or a scheduled maintenance.
MySQL - Upgrade DB System End com.oraclecloud.mysqlaas.upgradedbsystem.end Indicates the end of a MySQL version upgrade or a scheduled maintenance.
MySQL - Upgrade DB System - Update Crash Recovery Begin com.oraclecloud.mysqlaas.updatecrashrecoveryforupgrade.begin  
MySQL - Upgrade DB System - Update Crash Recovery End com.oraclecloud.mysqlaas.updatecrashrecoveryforupgrade.end  

DB System Event Example

This is a reference event for DB systems.

{
  "id": "ocid1.eventschema.oc1.phx.abyhqljrxqkzl5e7oxhcpirxvtfkjczhgjxi7b7fb36r2clncm5nkrmhvcqq",
  "exampleEvent": {
    "cloudEventsVersion": "0.1",
    "eventID": "3e74a48c-be5c-4002-8b3e-2196fa215528",
    "eventType": "com.oraclecloud.mysqlaas.createdbsystem.begin",
    "source": "Mysqlaas",
    "eventTypeVersion": "2.0",
    "eventTime": "2020-12-11T19:03:00.009Z",
    "contentType": "application/json",
    "extensions": {
      "compartmentId": "ocid1.compartment.oc1...<UniqueID>"
    },
    "data": {
      "compartmentId": "ocid1.compartment.oc1...<UniqueID>",
      "compartmentName": "my_compartment_name",
      "resourceName": "my_dbsystem",
      "resourceId": "ocid1.mysqldbsystem.oc1.iad...<UniqueID>",
      "availabilityDomain": "AD1",
      "freeFormTags": {},
      "definedTags": {},
      "additionalDetails": {
        "lifecycleState": "CREATING",
        "lifecycleDetails": "details message",
        "timeCreated": "2020-12-11T19:03:00.009Z",
        "timeUpdated": "2020-12-11T19:03:00.009Z",
        "configurationId": "ocid1.compartment.oc1...<UniqueID>",
        "shapeName": "VM.Standard.E2.1"
      }
    }
  }