Edit instance information
After you register an instance in Data Management (DMS), you can edit its Instance Owner, DBA, basic information (such as the database account, Security Hosting, and Security Rules), or advanced information (such as the Environment Type, Lock-free Schema Change, and query and export timeouts).
This page covers the following tasks:
Prerequisites
Before you begin, ensure that you have:
The Administrator or DBA system role in DMS
Change instance owner or DBA
Before you change ownership:
The new Instance Owner must be a registered DMS user. To add a user, see User Management.
The new DBA must be a registered DMS user with the DBA system role.
An instance can have multiple Instance Owners but only one DBA.
Log on to the .
In the database instance list on the left, find the target instance.
Right-click the instance name and change the DBA or Instance Owner.
Enable or disable Security Hosting
Change the environment type
Environment types
The Environment Type of an instance takes effect only in DMS. DMS provides eight environment types in two categories:
Category | Environment type | Environment ID |
Test | Development | dev |
Test | test | |
SIT | sit | |
UAT | uat | |
Performance test | pet | |
Staging | stag | |
Production | Production | product |
Pre-production | pre |
Steps
Log on to the Data Management (DMS) V5.0.
In the database instance list on the left, find the target instance.
Right-click the instance name and choose Edit.
In the Advanced Information section, find Environment Type and select the target type from the drop-down list.
Click Save.
Error "query execution was interrupted, maximum statement execution time exceeded" when exporting data
This error is triggered by the MySQL max_execution_time parameter. Take the following troubleshooting steps:
Connect to the instance and run
SHOW GLOBAL VARIABLES LIKE '%max_execution_time%'to check the parameter value. A value of 0 indicates no limit.If the value is not 0, log on to the ApsaraDB RDS console, open the instance details page, and go to Parameters. Set
max_execution_timeto 0, reconnect to the instance, and then export the data again.In the DMS instance list on the left, right-click the target instance, choose Edit, and in Advanced Information, increase the query timeout and export timeout.
Export instance configurations
Export instance configurations—such as Control Mode, Environment Type, and instance source—to manage instance resources offline.
For security reasons, exported configurations do not include the database account or password.
Log on to the .
In the top navigation bar, choose Data Assets > Instances.
NoteIf you use the DMS console in simple mode, move the pointer over the icon in the upper-left corner and choose .
On the Instance List tab, select the target instances.
Choose More > Export Configuration.
Your browser downloads an Excel file named instances.
Batch edit instance information
Log on to the .
In the top navigation bar, choose Data Assets > Instances.
NoteIf you use the DMS console in simple mode, move the pointer over the icon in the upper-left corner and choose .
On the Instance List tab, select the target instances and click Batch edit.
NoteAll selected instances must be of the same database type, for example, all MySQL.
In the dialog box, select the checkboxes for the configuration items you want to change and edit the instance information.
FAQ
Why do I get an "Access denied for user 'example_user'@'%' to database 'example_db'" error when creating a database in DMS?
The database account lacks permission to create databases. Either grant the necessary permissions in the instance console, or log on to DMS with a more privileged account. For details, see Modify account permissions.