Register an External MySQL DB System
You can register an External MySQL DB system by creating a resource in Database Management. This resource acts as a handle to which you connect the External MySQL DB system.
The External MySQL DB system is deployed on premises and in the process of registering it, you:
- Create a resource that represents the External MySQL DB system in Database Management.
- Create a connector to connect to the External MySQL DB system.
- Enable Database Management for the External MySQL DB system.
Before you register an External MySQL DB system, you must:
- Complete the general Oracle Cloud Infrastructure prerequisite tasks listed in Perform General Oracle Cloud Infrastructure Prerequisite Tasks.
- Obtain the required permissions listed in Permissions Required to Register External MySQL DB Systems and Enable Database Management.
- Complete the External MySQL DB system-specific prerequisite tasks listed in the first four rows in Perform External MySQL DB System-related Prerequisite Tasks.
To register an External MySQL DB system:
The Register External MySQL DB system panel remains open
till the entire registration process is complete and automatically closes after Database Management is enabled successfully. If the connector
is not created successfully and an error is displayed, then you can review the
information you've provided in the Register External MySQL DB
system panel, make changes, and click Submit
again. The newly registered External MySQL DB system is listed on the MySQL
DB systems page. If the connector creation step fails and you've closed
the Register External MySQL DB system panel, then you can click
Register External MySQL DB system and start the registration
process again. While re-registering the External MySQL DB system, you can provide the
same name for the External MySQL DB system and it will replace the previous registration
for which the connector creation had failed.
You can click the
Actions icon () for the External MySQL DB system and perform the following tasks:
- View work request: Click to monitor the work request and view the associated log and error messages.
- View connector: Click to go to the Connector details page and view connector information.
- Disable Database Management: Click to disable Database Management. If you disable Database Management and want to enable it again, click Enable Database Management in the Management status column, select a connector, and click Enable.
- Copy OCID: Click to copy the OCID of the External MySQL DB system resource.
- Deregister: Click to deregister the External MySQL DB system.