After you register database instances with Data Management (DMS), you can modify the basic and advanced information of a single database instance or the shared information of multiple database instances at a time.

Prerequisites

You are a database administrator (DBA) or a DMS administrator.

Procedure

  1. Log on to the DMS console V5.0.
    Note To switch to the previous version of the DMS console, click the 5租户头像 icon in the lower-right corner of the page. For more information, see Switch to the previous version of the DMS console.
  2. In the top navigation bar, click Data Assets. In the left-side navigation pane, click Instance.
    Note If you are using the previous version of the DMS console, move the pointer over the More icon in the top navigation bar and choose System > Instance.
  3. Modify one or more database instances based on your business requirements.
    • Modify a single database instance
      1. On the Instance List tab of the Instance page, find the database instance that you want to modify.
      2. Move the pointer over More in the Actions column and click Edit.
      3. In the Edit dialog box, modify the basic and advanced information of the database instance.
        Section Parameter Description
        Basic Information Data Source The source of the database instance. In this example, select Cloud.
        Database Type The type of the database instance.
        Instance Region The region where the database instance resides.
        Entry mode The method that you use to log on to the database instance. Valid values: Instance ID and Connection string address.
        Instance ID or Connection string address The ID of the database instance or the endpoint of 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 for an ApsaraDB RDS for MySQL instance and Configure an IP address whitelist.
        Database Account The username that you use to log on to the database instance.
        Note You can use the specified database account to perform operations such as read and write operations on the data of the database instance in DMS. You must specify a database account that has the required permissions.
        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.
        Advanced Information Environment type The environment of the database instance.
        Note For more information, see Change the environment type of an instance.
        Instance Name The name that you specify for the database instance.
        Note When you register an ApsaraDB instance for the first time, the name of the ApsaraDB instance is synchronized to DMS. DMS does not synchronize the name when you perform subsequent operations. You can change the name of the instance when you modify the instance in the DMS console.
        Enable DSQL Specifies whether to enable the cross-database query feature for the database instance. For more information, see Cross-database query.
        Lock-free Schema Change Specifies whether to enable the lock-free schema change feature for the database instance. For more information, see DDL-based lockless change.
        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.

        SSL encrypts network connections at the transport layer to improve the security and integrity of data in transit. However, SSL increases the response time of network connections.

        Before you use SSL connections, make sure that the SSL encryption feature is enabled for the database instance. 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 you disable the SSL encryption feature for the database instance.
        • Close: DMS does not connect to the database instance by using SSL connections.
        This parameter is displayed only for MySQL databases.
        DBA The database administrator (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 of the statement 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 of the statement is terminated to protect the database.
      4. After you modify the parameters, click Test connection to verify the modifications.

        If the Success message appears, the modifications are valid. If an error message appears, adjust the modifications based on the error message.

      5. Click Submit.
    • Modify multiple database instances at a time
      1. On the Instance List tab of the Instance page, select the database instances that you want to modify.
        Note The database instances that you select must be of the same database type, such as MySQL.
      2. Click Batch edit in the upper part of the Instance List tab.

      3. In the dialog box that appears, select the parameters that you want to modify and enter the updated values in the corresponding fields.
        Parameter Description
        Database Account The username that you use to log on to the database instances. To modify this parameter for multiple database instances, make sure that the database instances use the same username and password for logons.
        Database password The password that you use to log on to the database instances.
        Instance Name The name that you specify for the database instances based on the business requirements.
        DBA The DBA of the database instances. The DBA can grant permissions to users.
        Control Mode The control mode that is used to manage the database instances. For more information, see Control modes.
        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 of the statement 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 of the statement is terminated to protect the database.
        Lock-free Schema Change Specifies whether to enable the lock-free schema change feature for the database instances. For more information, see DDL-based lockless change.
      4. Click OK.