Data Management Service (DMS) provides three control modes for you to manage instances. You can configure the control mode for each instance.
DMS Express, DMS Pro, and DMS Enterprise are integrated into the current version of DMS. For more information, see Upgrades.
Control modes
Control mode | Description | Scenario | Logon mode |
---|---|---|---|
Flexible Management | Allows you to manage data and schemas of ApsaraDB or user-built databases of more than 25 types in a visualized manner and provides abundant data management solutions. This simplifies the use and management of databases. |
| Access database instances with an account and a password. |
Stable Change |
|
| Access database instances with an account and a password. |
Secure Collaboration |
|
| Access database instances without using an account and a password after being authorized. |
Billing methods
In DMS, you can register instances based on multiple types of databases and set the control mode for each instance.
- Instances in the Flexible Management mode are free of charge.
The instances in the Stable Change and Secure Collaborate modes are charged based on the number of instances. For more information, see Pricing.
- Compared with the previous DMS Pro, the Stable Change mode provides more instance specifications and supports the pay-as-you-go billing method.
- Compared with an instance of the previous DMS Enterprise, an instance with the same specification in the Secure Collaboration mode reduces by 68% at most in terms of the price.
View and set the control mode
For more information, see the following topics:
Procedure
- Flexible Management
- Register an instance and set the control mode to Flexible Management as a DMS administrator or DBA. For more information, see Instance management.
- Log on to the instance.
- If you assume the role of DMS administrator or DBA, use a database account and password to log on to the instance.
- If you assume the role of common user, you must first obtain the permission to access the database instance and then use a database account and password to log on to the instance. For more information, see Manage permissions.
- Manage data and schemas.
- You can edit data and schemas by using SQL statements or visualized operations on the SQLConsole tab. You can also find and right-click the target instance, database, or table in the left-side pane and select a shortcut as required to manage them.
- To import a large amount of data at a time, choose Data Plans > Data Import in the top navigation bar and submit a ticket of data import on the Data Import tab. In this mode, you are not allowed to make data changes of other types.
Stable Change
- Register an instance and set the control mode to Stable Change as a DMS administrator or DBA. For more information, see Instance management.
- Log on to the instance.
- If you assume the role of DMS administrator or DBA, use a database account and password to log on to the instance.
- If you assume the role of common user, you must first obtain the permission to access the database instance and then use a database account and password to log on to the instance.
- Manage data and schemas.
- You can submit a ticket on the Normal Data Modify tab in the Data Plans module to change schemas without table locking. You can also submit a ticket to schedule a one-time or recurring task to change data without table locking or clean historical data.
In a ticket, you can configure your task as required. For example, you can schedule the task to run at a specific time. You can check the metadata lock before data changes to prevent session blocks caused by lock contention. You can also check the number of running threads before data changes. This prevents database overloads and business interruptions caused by excessive active sessions. In addition, you can suspend the database session after data changes. This prevents latency in master-slave replication and binary log consumption.
- You can edit data and schemas by using SQL statements or visualized operations on the SQLConsole tab. You can also find and right-click the target instance, database, or table in the left-side pane and select a shortcut as required to manage them.
Secure Collaboration
- Register an instance and set the control mode to Secure Collaboration as a DMS administrator or DBA. For more information, see Instance management.
- Set security rules for the instance as a DMS administrator or DBA, including the R&D specifications, R&D process, and approval process. We recommend that you set the security rules in a flexible manner to meet the requirements of different scenarios. In this step, you do not need to log on to the instance.
- Log on to the instance.
- If you assume the role of DMS administrator or DBA, use a database account and password to log on to the instance.
- If you assume the role of common user, you must first obtain the permission to access the database instance and then use a database account and password to log on to the instance. For more information, see Manage permissions.
- Manage data and schemas.
- You can use features of the Data Plans module to manage the instance only when you have the required permissions. In this step, you do not need to log on to the instance.
- If you want to change schemas that follow a specific R&D process or R&D specifications, go to the Schema Design tab of the Schemas module and submit a ticket to the test environment to test the schema change. After the schema change passes the test, submit the schema change to other environments.
- You can edit data and schemas by using SQL statements or visualized operations on the SQLConsole tab. You can also find and right-click the target instance, database, or table in the left-side pane and select a shortcut as required to manage them.
Features supported by each control mode
The following tables describe features supported by each control mode.
System management
Feature \ Mode | Flexible Management | Stable Change | Secure Collaboration | |||
---|---|---|---|---|---|---|
Instance management | Yes | You can select this control mode when you register an instance. | Yes | You can select this control mode when you register an instance. Note that the available inventory of instances in this mode is limited. | Yes | You can select this control mode when you register an instance. Note that the available inventory of instances in this mode is limited. |
User management | Yes | Yes | Yes | |||
Task management | Yes | Yes | Yes | |||
Security rules | Yes | Yes | Yes | |||
Approval process | Yes | Yes | Yes | |||
Configuration management | Yes | Yes | Yes | |||
Operation audit | Yes | Yes | Yes | |||
IP address whitelist | Yes | Yes | Yes | |||
Data protection | Yes | You can access the Data Protection page, but cannot manage or deploy tasks. | Yes | You can access the Data Protection page, but cannot manage or deploy tasks. | Yes | |
Sensitive data management | No | You cannot acquire metadata in this mode. Therefore, you cannot manage sensitive data. | No | You cannot acquire metadata in this mode. Therefore, you cannot manage sensitive data. | Yes |
Search
Feature \ Mode | Flexible Management | Stable Change | Secure Collaboration | |||
---|---|---|---|---|---|---|
Searching for databases and tables | Yes | You can only search for databases. | Yes | You can only search for databases. | Yes |
Permission
Feature \ Mode | Flexible Management | Stable Change | Secure Collaboration | |||
---|---|---|---|---|---|---|
Permissions on databases, tables, and columns | No | You cannot acquire metadata in this mode. Therefore, you are not authorized to manage databases, tables, and columns. | No | You cannot acquire metadata in this mode. Therefore, you are not authorized to manage databases, tables, and columns. | Yes | |
Permissions to access instances | Yes | Instance owners, DMS administrators, and DBAs can manage the permissions to access instances. | Yes | Instance owners, DMS administrators, and DBAs can manage the permissions to access instances. | No | |
Owner permissions | Yes | Yes | Yes | |||
Owned permissions | Yes | Yes | Yes |
Data plan
Feature \ Mode | Flexible Management | Stable Change | Secure Collaboration | |||
---|---|---|---|---|---|---|
Data changes | No | No permission verification or approval process is required. | Yes | No permission verification or approval process is required. You can change data without table locking and clean historical data. | Yes | You must follow the specified security rules. |
Data import | Yes | No permission verification or approval process is required. You can import a limited number of rows of data per day. | Yes | No permission verification or approval process is required. You can import a limited number of rows of data per day. | Yes | You must follow the specified security rules. |
Data export | Yes | No permission verification or approval process is required. You can export a maximum of 1 million rows of data per day. | Yes | No permission verification or approval process is required. You can export a maximum of 20 million rows of data per day. | Yes | You must follow the specified security rules. The number of rows of data that you can export per day is not limited. |
Data tracking | Yes | No permission verification or approval process is required. You can track data for a maximum of 1 hour per day. | Yes | No permission verification or approval process is required. The period during which you can track data per day is not limited. | Yes | You must follow the specified security rules. The period during which you can track data per day is not limited. |
Test data generation | Yes | No permission verification or approval process is required. You can generate a maximum of 1 million rows of test data per day. | Yes | No permission verification or approval process is required. You can generate a maximum of 20 million rows of test data per day. | Yes | You must follow the specified security rules. The number of rows of test data that you can generate per day is not limited. |
Schemas
Feature \ Mode | Flexible Management | Stable Change | Secure Collaboration | |||
---|---|---|---|---|---|---|
Schema design | Yes | No permission verification or approval process is required. | Yes | No permission verification or approval process is required. | Yes | You must follow the specified security rules, including the rules on versions and designs. |
Table synchronization | Yes | No permission verification or approval process is required. | Yes | No permission verification or approval process is required. | Yes | You must follow the specified security rules. |
Database clone | Yes | No permission verification or approval process is required. | Yes | No permission verification or approval process is required. | Yes | You must follow the specified security rules. |
Optimization
Feature \ Mode | Flexible Management | Stable Change | Secure Collaboration | |||
---|---|---|---|---|---|---|
SQL review | No | Yes | You must follow the approval rules. No approval process is required. | Yes | You must follow the approval rules and can specify an approval process. |
Workbench
Feature \ Mode | Flexible Management | Stable Change | Secure Collaboration | |||
---|---|---|---|---|---|---|
Owned tickets | Yes | Yes | Yes | |||
Favorite databases and tables | Yes | You can only view the metadata information of databases and tables. | Yes | You can only view the metadata information of databases and tables. | Yes | |
Owned databases and tables | Yes | You can only view the metadata information of databases and tables. | Yes | You can only view the metadata information of databases and tables. | Yes | |
Accessible databases and tables | Yes | You can only view the metadata information of databases and tables. | Yes | You can only view the metadata information of databases and tables. | Yes | |
Recently used databases | Yes | Yes | Yes | |||
Updates and notifications | Yes | Yes | Yes | |||
Quick accesses | Yes | Yes | Yes |
SQL console
Feature \ Mode | Flexible Management | Stable Change | Secure Collaboration | |||
---|---|---|---|---|---|---|
Permission application | No | Not available. | No | Not available. | Yes | |
Table details | Yes | Available only after logon to the corresponding instance. | Yes | Available only after logon to the corresponding instance. | Yes | |
Performance | Yes | Available only after logon to the corresponding instance. | Yes | Available only after logon to the corresponding instance. | Yes | |
Topology | No | Not available. | No | Not available. | Yes | |
Metadata and dictionary synchronization | No | Not available. | No | Not available. | Yes | |
Export | Yes | Available only after logon to the corresponding instance. | Yes | Available only after logon to the corresponding instance. | Yes | |
Search | Yes | Available only after logon to the corresponding instance. | Yes | Available only after logon to the corresponding instance. | Yes |
Instances
Feature \ Mode | Flexible Management | Stable Change | Secure Collaboration | |||
---|---|---|---|---|---|---|
Details | Yes | Yes | Yes | |||
Logon free | Yes | Requires permissions to access instances. | Yes | Available only to instance owners, DBAs, and DMS administrators. | Yes | Available only to instance owners, DBAs, and DMS administrators. |
Dictionary synchronization | No | No | Yes | |||
Connectivity test | No | No | Yes | |||
Instance DBA | Yes | The default instance DBA is the user who registered the instance. The instance DBA also assumes the role of instance owner by default. | Yes | The default instance DBA is the user who registered the instance. The instance DBA also assumes the role of instance owner by default. | Yes | |
Security rules | No | No | Yes | |||
Cross-instance query | No | No | Yes | |||
Schema change without table locking | No | Yes | Yes | |||
Instance editing | Yes | Yes | Yes | |||
Instance deleting | Yes | Yes | Yes |
Databases
Feature \ Mode | Flexible Management | Stable Change | Secure Collaboration | |||
---|---|---|---|---|---|---|
Owner management | Yes | Yes | Yes | |||
Permission management | Yes | Yes | Yes | |||
Single-database query | Yes | Yes | Yes | |||
Table details | Yes | Available only after logon to the corresponding instance. | Yes | Available only after logon to the corresponding instance. | Yes | |
Export | Yes | Available only after logon to the corresponding instance. | Yes | Available only after logon to the corresponding instance. | Yes | |
Dictionary synchronization | No | No | Yes | |||
Logical database | No | No | Yes | |||
Test data generation | Yes | Available only after logon to the corresponding instance. | Yes | Available only after logon to the corresponding instance. | Yes | |
Database clone | Yes | Available only after logon to the corresponding instance. | Yes | Available only after logon to the corresponding instance. | Yes |
Tables
Feature \ Mode | Flexible Management | Stable Change | Secure Collaboration | |||
---|---|---|---|---|---|---|
Exporting table creation statements | Yes | Available only after logon to the corresponding instance. | Yes | Available only after logon to the corresponding instance. | Yes | |
Exporting schemas | Yes | Available only after logon to the corresponding instance. | Yes | Available only after logon to the corresponding instance. | Yes | |
Code generator | Yes | Available only after logon to the corresponding instance. | Yes | Available only after logon to the corresponding instance. | Yes | |
Security level adjustment | No | No | Yes | |||
Object information | Yes | Available only after logon to the corresponding instance. | Yes | Available only after logon to the corresponding instance. | Yes | |
Test data generation | Yes | Available only after logon to the corresponding instance. | Yes | Available only after logon to the corresponding instance. | Yes | |
Database clone | Yes | Available only after logon to the corresponding instance. | Yes | Available only after logon to the corresponding instance. | Yes |