Creating an Amazon Aurora MySQL connection

Create an Amazon Aurora MySQL connection by performing the following steps:

  1. Log in into the OCI Console with your user credentials and the necessary policies to be able to create database connections.
  2. Open the navigation menu. Under Database Migrations click Database Connections.
  3. Click Create Connection.
  4. On the General information step, in the Name field, enter a display name for the database connection resource.

    This is not the actual database name, but a name that will appear in a list of databases connections on completion of this procedure.

  5. Add an optional Description enter a description that helps you distinguish for the database connection resource.
  6. In Compartment select the compartment in which the Database Connection resource will be created.
  7. In Type, select a connection type. Select the connection type as Amazon Aurora MySQL.
  8. In Vault in Compartment select the security vault.

    Database Migration Service uses the OCI Vault service to store your secrets such as passwords, wallets, and keys, and encrypts them with the encryption key that you provide. All of these are always stored in your tenancy and are in your full control.

    You can select a vault in a different compartment by clicking Change Compartment.

  9. In Encryption Key in Compartment select the keystore that you configured in the vault.

    Only AES algorithm type keys are supported.

  10. The Advanced Options section allows you to optionally create tags.
  11. In the Connection details page, enter the connection details for the Azure Database for MySQL as follows:
    • Database name: The database name

    • Host: listener host IP address
    • Port: listener port number
    • Enter the database administrator credentials in Initial load database username and Initial load database password.

  12. Select Use different credentials for replication to enter the credentials for replication. Select this option if you want to use a separate database user for performing replication for your online migrations. The following options are available
    • Replication database username
    • Replication database password
  13. In the SSL details, select the security protocol.
    • Plain
    • TLS, and then select the SSL mode
    • MTLS, then select the SSL mode. Upload the Client certificate and Client private key.
  14. (Optional) Under Advanced Options, add Connection attributes. Click + Another attribute to add more.
  15. Click Create.
Note

After you click Create, the database connection name appears in the Connection list while the creating connection operation runs. The creating connection operation can take a few minutes.

You can monitor the operation status in the State column. When the state is Active, the database connection creation is complete and successful.