All Products
Search
Document Center

Modify an instance

Last Updated: May 28, 2020

Data Management Service (DMS) allows you to modify the basic and advanced configurations of a registered database instance in the console. You can also modify the shared configurations of multiple instances at a time.

Prerequisites

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

Procedure

  1. Log on to the DMS console.

  2. In the top navigation bar, choose System Management > Instance.

    You can also find the target instance in the left-side navigation pane, right-click the instance, and then select Edit instance to modify the instance configuration.

  3. On the Instance List tab of the Instance page, modify the configurations of one or more instances based on your business requirements.

    • Modify a single instance

      1. On the Instance List tab, find the target instance that you want to modify.

      2. Move the pointer over More in the Actions column and select Edit instance.

      3. In the dialog box that appears, set the parameters on the Basic information and Advanced information tabs.

        TabParameterDescription
        Basic InformationDatabase SourceThe category of the data source.
        Database typeThe type of the database to be registered.
        Instance AreaThe region where the database gateway resides.
        Gateway IDThe ID of the database gateway that is used to connect to the database. If you do not have a database gateway, click Click here to add a database gateway to create one.
        Login AddressThe endpoint that is used to connect to the database.
        PortThe port that is used to connect to the database.
        Database accountThe username that you use to log on to the database.
        Database passwordThe password that you use to log on to the database.
        Control ModeThe control mode that is used to manage the instance in DMS. For more information, see Control modes.
        Advanced InformationEnvironment typeThe type of environment where the database is deployed.
        Instance NameThe name that you specify for the instance in DMS.
        Enable DSQLSpecifies whether to enable the cross-database query feature for the database. For more information, see Cross-database query.
        OnlineDDLSpecifies whether to allow changing schemas without locking tables for the database and the specific method. For more information, see Change schemas without locking tables.
        DBAThe DBA of the instance who is allowed to grant permissions to users.
        query timeout(s)The timeout interval of the statement that is used to query data. When the specified time interval is reached, the target statement run in the SQL editor is stopped to protect the database security.
        export timeout(s)The timeout interval of the statement that is used to export statistics. When the specified time interval is reached, the target statement run in the SQL editor is stopped to protect the database security.
      4. After you complete the configuration, click Test connection on the Basic Information tab to check whether the database is connected.
        The system message Success appears when the database is connected. If an error message appears, modify the configuration as instructed.
      5. Click Submit.
    • Modify multiple instances at a time

      1. On the Instance List tab, select the target instances that you want to modify.

        To modify multiple instances at a time, you must select instances of the same type, for example, MySQL.

      2. Click Batch edit in the upper part of the 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 databases. To modify this parameter, make sure that the selected instances require the same username and password for database logons.
        Database password The password that you use to log on to the databases.
        Instance Name The name of the instances. You can specify a name based on the business feature.
        DBA The DBA of the instances who is allowed to grant permissions to users.
        Control Mode The control mode that is used to manage the instances. For more information, see Control modes.
        query timeout(s) The timeout interval of the statement that is used to query data. When the specified time interval is reached, the target statement run in the SQL editor is stopped to protect the database security.
        export timeout(s) The timeout interval of the statement that is used to export statistics. When the specified time interval is reached, the target statement run in the SQL editor is stopped to protect the database security.
        OnlineDDL Specifies whether to allow changing schemas without locking tables for the databases and the specific method. For more information, see Change schemas without locking tables.
        d. Click OK.