This topic describes how to register a database instance that is accessible to multiple Alibaba Cloud accounts with Data Management (DMS). An ApsaraDB RDS for MySQL database instance is used in the example.

Prerequisites

  • Supported database types include ApsaraDB RDS for MySQL, ApsaraDB RDS for SQL Server, and ApsaraDB RDS for PostgreSQL.
    Note The database instance to be registered does not belong to your account or the Alibaba Cloud account that manages your account.
  • You are a database administrator (DBA) or a DMS administrator. For more information, see View owned system roles.

Background information

If you need to allow multiple Alibaba Cloud accounts in your enterprise to manage all the database instances in a uniform manner, you can add multiple users in DMS before you register these database instances. All the added DMS users in your enterprise can access these database instances.

Procedure

  1. Go to the DMS console V5.0.
  2. On the Home page of the DMS console, click the Add Instance icon in the upper-right corner of the left-side instance list.
  3. In the Add Instance dialog box, click the Cloud tab.
  4. Click MySQL.
  5. Set the following parameters for the database instance.
    Section Parameter Description
    Basic Information Data Source The source of the database instance. Cloud is selected in this example.
    Database Type The type of the database instance. MySQL is selected in this example.
    Instance Region
    1. The region in which the database instance resides.
    2. Click Cross-Alibaba Cloud account instances.
    Other primary accounts The Alibaba Cloud account to which the database instance belongs.
    Note If the Alibaba Cloud account is not in the list, you can click Add User to add the Alibaba Cloud account that is used to purchase the database instance. For more information, see Add a user.
    Entry mode The method that you can use to register the database instance. Set the parameter to Connection string address.
    Connection string address The endpoint for connecting to the database instance.
    Note When you register an ApsaraDB instance, DMS adds its own server IP addresses and CIDR blocks for the specified region to the whitelist of IP addresses that are allowed to connect to the ApsaraDB instance. If the IP addresses and CIDR blocks fail to be added, manually add them. For more information, see Configure an IP address whitelist.
    Database Account The username that you use to log on to the database instance.
    Database password The password that you use to log on to the database instance.
    Control Mode The control mode in which you want to manage the database instance in DMS. For more information, see Control modes.
    Sensitive Data Protection Specifies whether to enable the sensitive data protection feature for the database instance. For more information, see Overview.
    Advanced Information Environment type The environment of the database instance.
    Instance Name The custom name of the database instance in DMS.
    Enable DSQL Specifies whether to enable the cross-database query feature for the database instance if the database instance is managed in secure collaboration mode. For more information, see Query data across multiple database instances.
    Lock-free Schema Change Specifies whether to allow changing schemas without the need to lock tables for the database instance. For more information, see Overview.
    DBA The DBA of the database instance. The DBA can grant permissions to users.
    query timeout(s) The timeout period for the execution of an SQL query statement. If the execution of an SQL query statement lasts longer than the specified timeout period, the execution is terminated to protect the database.
    export timeout(s) The timeout period for the execution of an SQL export statement. If the execution of an SQL export statement lasts longer than the specified timeout period, the execution is terminated to protect the database.
  6. Click Basic Information to unfold the section and click Test connection in the lower-left corner of the dialog box.
    Note If the connection test fails, follow the instructions to modify the parameters.
  7. If the connection test succeeds, click Submit.