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

Prerequisites

  • Supported database instance types include ApsaraDB RDS for MySQL, ApsaraDB RDS for SQL Server, and ApsaraDB RDS for PostgreSQL.
    Note Make sure that the database instance to be registered does not belong to the current Alibaba Cloud account.
  • You are a database administrator (DBA) or a DMS administrator. For more information about how to view the role of a user, see View owned system roles.

Scenario

Your enterprise has multiple Alibaba Cloud accounts, and you want to use your own Alibaba Cloud account to manage the database instances that belong to different accounts in a centralized manner.

Procedure

  1. Log on to the DMS console V5.0.
  2. On the Home page of the DMS console, click the 增加 icon in the upper-right corner of the left-side instance list.
    Note Alternatively, click Data Assets in the top navigation bar and click Instances in the left-side navigation pane. On the Instances page, click New.
  3. In the Add Instance dialog box, click the Cloud tab and select a database instance type.
  4. 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 to DMS. For more information, see Manage users.
    Entry mode The method that you can use to register the database instance. Valid values: Instance ID and Connection string address. This parameter is set to Connection string address in this example.
    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 IP address whitelist of 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 that is used to manage the database instance. 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 security 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 Perform lock-free DDL operations.
    Enable SSL Specifies whether to allow DMS to connect to the database instance by using SSL connections. After this feature is enabled, DMS can connect to the database instance by using SSL connections. Valid values:
    • Default (DMS automatically checks whether self-negotiation is enabled for the database instance.): DMS automatically checks whether the SSL encryption feature is enabled for the database instance. If the SSL encryption feature is enabled, DMS connects to the database instance by using SSL connections. Otherwise, DMS connects to the database instance without encryption.
    • Open: DMS connects to the database instance by using SSL connections. This value is invalid if the SSL encryption feature is disabled for the database instance.
    • Close: DMS does not connect to the database instance by using SSL connections.
    Note This parameter is available only if you set the Database Type parameter to MySQL.
    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.
    Note After you set the parameters in the Basic Information section, click Test connection in the lower part of the dialog box. If the connection test fails, modify the parameters as prompted and try again.
  5. Click Submit.
    Note After the database instance is registered with DMS, the database instance is accessible to all DMS users that are managed by the current Alibaba Cloud account.