Control modes

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

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:

• View the control mode
• Set the control mode

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

Search

Permission

Data plan

Schemas

Optimization

Workbench

SQL console

Instances

Databases

Tables