Data Management (DMS) (DMS) provides three control modes for you to manage instances. You can configure the control mode for each database instance.
Overview
Control mode | Description | Scenario | Access method |
Flexible Management |
|
| DMS administrators, database administrators (DBAs), and regular users must be granted the logon permission on the database instance. Then, they can log on to the database instance by using an account and a password. For more information about how to obtain the permission to log on to a database instance, see Apply for permissions by submitting a ticket. Note The account and password are managed by relevant persons in your enterprise. |
Stable Change |
|
| |
Security Collaboration |
|
| The database instance can be accessed without a logon if you have the required permissions.
|
Billing methods
Control mode | Billing method |
Flexible Management | Free of charge |
Stable Change and Security Collaboration | Specific fees are charged. Both subscription and pay-as-you-go billing methods are supported. For more information about pricing of DMS and how to purchase the DMS service, see Billable items and prices and Purchase the DMS service. |
Configure the control mode of an instance
Change the control mode of an instance.
NoteIf you change the control mode of an instance from Flexible Management to Stable Change or Security Collaboration, you are charged for the instance. For more information, see Pricing.
The features supported by different control modes vary. Before you change the control mode of an instance, make sure that your business is not affected by the change of control mode. For more information about the features supported by each control mode, see the Features supported by each control mode section in this topic.
Features supported by each control mode
Category | Feature | Flexible Management | Stable Change | Security Collaboration |
Instance management | The account and password that are used to connect to the database | The account and password that are used to connect to the database | Alibaba Cloud account authentication (without using database accounts or passwords) | |
Y | Y | Y | ||
N | N | Y | ||
N | Y: Source IP addresses must be controlled one by one. | Y: This feature can be globally enabled only over office networks. | ||
N | N | Y | ||
Resource authorization granularity | Permissions on the database instance and database accounts | Permissions on the database instance and database accounts | Permissions on databases, tables, columns, and rows | |
Operation authorization granularity | - | Permissions on features | Permissions on the query, export, and change operations | |
Authorization period | - | - | The authorization period can be customized. Permissions are automatically revoked after they expire. | |
Row-level data permission management | N | N | Y | |
Data export | Y | Y | Y | |
Y | Y | Y | ||
Permission verification and process approval | - | - | Y | |
Maximum number of rows exported for free per day | 1 million | 20 million | Unlimited | |
Maximum number of tables per export | Unlimited | Unlimited | Unlimited | |
Maximum capacity of tables per export | 10 GB | Unlimited | Unlimited | |
Security and specifications | Y: Only part of the feature is supported and SQL statements executed within seven days are audited. | Y: Only part of the feature is supported and SQL statements executed within seven days are audited. | Y: All operations in this module are audited. | |
Y | Y | Y | ||
Y: You are charged for using this feature. Fine-grained permission management is not supported. | Y: You are charged for using this feature. Fine-grained permission management is not supported. | Y: You are charged for using this feature. You can enable this feature in the Sensitive Data module. | ||
N | N | Y | ||
Y | Y | N | ||
Data classification | Y: You are charged for using this feature. You can enable this feature in the Sensitive Data module. | Y: You are charged for using this feature. You can enable this feature in the Sensitive Data module. | Y: You are charged for using this feature. You can enable this feature in the Sensitive Data module. | |
Schema changes | N | N | Y | |
Y | Y | Y | ||
Y | Y | Y | ||
N | Y | Y | ||
Data changes | N | Y | Y | |
N | Y | Y | ||
N | Y | Y | ||
Y | Y | Y | ||
Y | Y | Y | ||
Risk identification before changes | N | Y | Y | |
Risk management after changes | N | Y | Y | |
Database stability assurance | Binary log files in the past hour | Unlimited. Batch download is supported. | Unlimited. Batch download is supported. | |
N | Y: Review rule configurations are supported, whereas process approvals are not supported. | Y: Review rule configurations and process approvals are supported. | ||
O&M management | N | N | Y | |
N | N | Y | ||
R&D efficiency improvement | Collaborative R&D | N | N | Y |
Cross-instance query | N | N | Y | |
Automatic generation of test data | Y: A maximum of 1 million rows of data can be generated at a time. | Y: A maximum of 100 million rows of data can be generated at a time. | Y: A maximum of 100 million rows of data can be generated at a time. | |
R&D process approval | N | N | Y: Customization is supported. | |
Logical database configuration | N | N | Y | |
Operations on multiple tables | Y | Y | Y | |
Scheduling of recurring data development task | N | N | Y | |
SQL console | Y | - | Y | |
N | N | Y | ||
Y | Y | Y | ||
Y | Y | Y | ||
N | N | Y | ||
N | N | Y: This feature is supported after the cross-database query feature is enabled. | ||
Y | Y | Y | ||
SQL statements | Y | Y | Y | |
Execution plans | Y | Y | Y | |
Change of the character set | Y | Y | Y | |
SQL query timeout and interruption | N | N | Y | |
Limits on the number of rows queried per day | N | N | Y | |
Limits on the number of queries per day | N | N | Y | |
SQL statements that can be saved | Y | N | Y | |
Table size threshold for full-table scan | N | N | Y | |
Maximum number of rows returned per query | 3,000 rows. Pagination is supported. | 3,000 rows. Pagination is supported. | 3,000 rows. You can specify whether to enable pagination. | |
Visualization of data query results | Y | Y | Y | |
SQL formatting | Y | Y | Y | |
Smart SQL completion | Y | Y | Y | |
Schema management | Schema comparison | Y | Y | Y |
Schema editing | Y | Y | Y | |
Table schema synchronization | Y | Y | Y | |
Maximum number of data dictionaries exported | 5 | Unlimited | Unlimited | |
Design specifications of table schemas | N | N | Y | |
R&D process of table schemas | N | N | Tables created by other accounts, in other databases, and in self-managed databases support this feature. | |
Three database versions can be retained. | Twenty database versions can be retained. | Fifty database versions can be retained. | ||
Code generator | N | N | Y | |
Data dictionary synchronization | N | N | Y | |
Topologies | - | - | Y |
N: not supported
Y: supported
-: N/A