Events for External MySQL

You can use Oracle Cloud Infrastructure Events to create rules that trigger an action when the state of an External MySQL DB system or connector resource changes.

For example, you can create a rule to be notified when the External MySQL DB system is registered or when the Database Management enablement process begins or ends.

For information on:

Events service, see Overview of Events
Permissions required to create and view event rules, see Additional Permissions Required to Use Database Management for External MySQL

Database Management Events for External MySQL DB Systems

Friendly Name	Event Type
External MySQL DB System - Deregister Begin	`com.oraclecloud.databasemanagement.externalmysqlresource.dbsystem.deregister.begin`
External MySQL DB System - Deregister End	`com.oraclecloud.databasemanagement.externalmysqlresource.dbsystem.deregister.end`
External MySQL DB System - Disable Database Management Begin	`com.oraclecloud.databasemanagement.externalmysqlresource.dbsystem.disablemgmt.begin`
External MySQL DB System - Disable Database Management End	`com.oraclecloud.databasemanagement.externalmysqlresource.dbsystem.disablemgmt.end`
External MySQL DB System - Enable Database Management Begin	`com.oraclecloud.databasemanagement.externalmysqlresource.dbsystem.enablemgmt.begin`
External MySQL DB System - Enable Database Management End	`com.oraclecloud.databasemanagement.externalmysqlresource.dbsystem.enablemgmt.end`
External MySQL DB System - Register	`com.oraclecloud.databasemanagement.externalmysqlresource.dbsystem.register`
External MySQL DB System - Update	`com.oraclecloud.databasemanagement.externalmysqlresource.dbsystem.update`

Here's an example of the External MySQL DB System - Register event type:

{
  "eventType": "com.oraclecloud.databasemanagement.externalmysqlresource.dbsystem.register",
  "cloudEventsVersion": "0.1",
  "eventTypeVersion": "2.0",
  "source": "DatabaseManagement",
  "eventTime": "2024-05-06T12:08:21.000Z",
  "eventID": "unique_ID",
  "contentType": "application/json",
  "data": {
    "compartmentId": "ocid1.compartment.oc1..unique_ID",
    "resourceName": "example_resource",
    "resourceId": "ocid1.dbmgmtexternalmysqldb.oc1.phx.unique_ID",
    "freeFormTags": null,
    "definedTags": {},
    "availabilityDomain": null,
    "additionalDetails": {
      "displayName": "External MySQL DB System - Register",
      "connectorId": "connector_OCID",
      "managementState": "Disabled",
      "lifecycleState": "Creating",
      "deploymentType": "External",
      "description": "when the External MySQL DB System is registered"
    }
  }
}

Database Management Events for External MySQL Connectors

Friendly Name	Event Type
External MySQL Connector - Create	`com.oraclecloud.databasemanagement.externalmysqlresource.connector.create`
External MySQL Connector - Delete Begin	`com.oraclecloud.databasemanagement.externalmysqlresource.connector.delete.begin`
External MySQL Connector - Delete End	`com.oraclecloud.databasemanagement.externalmysqlresource.connector.delete.end`
External MySQL Connector - Update Begin	`com.oraclecloud.databasemanagement.externalmysqlresource.connector.update.begin`
External MySQL Connector - Update End	`com.oraclecloud.databasemanagement.externalmysqlresource.connector.update.end`

Here's an example of the External MySQL Connector - Create event type:

{
  "eventType": "com.oraclecloud.databasemanagement.externalmysqlresource.connector.create",
  "cloudEventsVersion": "0.1",
  "eventTypeVersion": "2.0",
  "source": "DatabaseManagement",
  "eventTime": "2024-05-06T12:08:21.000Z",
  "eventID": "unique_ID",
  "contentType": "application/json",
  "data": {
    "compartmentId": "ocid1.compartment.oc1..unique_ID",
    "resourceName": "example_resource",
    "resourceId": "ocid1.dbmgmtmysqldbconnector.oc1.phx.unique_ID",
    "freeFormTags": null,
    "definedTags": {},
    "availabilityDomain": null,
    "additionalDetails": {
      "displayName": "External MySQL Connector - Create",
      "externalDatabaseId": "database_OCID",
      "timeUpdated": "2024-05-06T12:08:21.000Z",
      "timeCreated": "2024-05-06T12:08:21.000Z",
      "lifecycleState": "Creating",
      "databaseType": "External",
      "macsAgentId": "agent_OCID",
      "connectionStatus": "NOT_CONNECTED",
      "timeConnectionStatusUpdated": "2024-05-06T12:08:21.000Z",
      "description": "when the external MySQL connector is created"
    }
  }
}

Oracle Cloud Infrastructure Documentation