All Products
Search
Document Center

Control modes

Last Updated: May 28, 2020

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.
  • Database instances do not require strict control.
  • Database instances are managed by only one user.
Access database instances with an account and a password.
Stable Change
  • Provides multiple data plans to ensure the stable running of databases, such as schema changes without table locking and data changes without table locking.
  • Supports exporting and tracking data during a much longer period.
  • Supports all features of the Flexible Management mode.
  • Database instances must run stably and the running cannot be interrupted.
  • Members of a small team work in a collaborative manner.
Access database instances with an account and a password.
Secure Collaboration
  • Provides solutions to ensure data security, such as management of permissions on databases, tables, or fields and management of sensitive data.
  • Provides flexible and definable specifications and approval processes for enterprises to customize their own DevOps solutions.
  • Supports all features of the Flexible Management and Stable Change modes.
  • The data of database instances must be secure.
  • The data development and change of data instances require strict control.
  • Enterprises require compliant data management.
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
    1. Register an instance and set the control mode to Flexible Management as a DMS administrator or DBA. For more information, see Instance management.
    2. 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.
    3. 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

    1. Register an instance and set the control mode to Stable Change as a DMS administrator or DBA. For more information, see Instance management.
    2. 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.
    3. 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

    1. Register an instance and set the control mode to Secure Collaboration as a DMS administrator or DBA. For more information, see Instance management.
    2. 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.
    3. 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.
    4. 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  
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