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
Log on to the DMS console.
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.
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
On the Instance List tab, find the target instance that you want to modify.
Move the pointer over More in the Actions column and select Edit instance.
In the dialog box that appears, set the parameters on the Basic information and Advanced information tabs.
Tab Parameter Description Basic Information Database Source The category of the data source. Database type The type of the database to be registered. Instance Area The region where the database gateway resides. Gateway ID The 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 Address The endpoint that is used to connect to the database. Port The port that is used to connect to the database. Database account The username that you use to log on to the database. Database password The password that you use to log on to the database. Control Mode The control mode that is used to manage the instance in DMS. For more information, see Control modes. Advanced Information Environment type The type of environment where the database is deployed. Instance Name The name that you specify for the instance in DMS. Enable DSQL Specifies whether to enable the cross-database query feature for the database. For more information, see Cross-database query. OnlineDDL Specifies whether to allow changing schemas without locking tables for the database and the specific method. For more information, see Change schemas without locking tables. DBA The 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. - 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. - Click Submit.
Modify multiple instances at a time
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.
Click Batch edit in the upper part of the tab.
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.