All Products
Search
Document Center

DBA manual

Last Updated: Jun 02, 2020

Operations

  1. Register a database as an instance in the Data Management Service (DMS) console. For more information, see Instance management.
  2. Set security rules for instances, including the R&D specifications, R&D processes, and approval processes. Currently, you can only set security rules for instances whose control mode is set to Secure Collaboration. For more information, see Configurations of security rules and Approval processes.
  3. Grant a user the permissions on a database or table. For more information, see Permission management.

Supported features for DBAs

Category Feature Description
System management Instance management
You can register databases as instances and then view and manage them on the Instance page.
Task management You can create, start, and stop tasks on the Task page.
Configuration management You can view and manage system configuration items, and view the modification records on the Configuration page.
Intelligent operation You can view the statistics on tickets, queries, users, and metadata on the Intelligent Operation page.
Security management Security rules You can set custom security rules on the Security Rules page. Before DMS runs SQL statements, it validates the statements based on the security rules.
Approval processes Approval processes are associated with security rules specified for data operations. You can apply different approval processes on different data operations.
Operations logs DMS records data changes in operations logs so that you can trace data operations, execution time, and operation accounts at any time. You can view operations logs on the Operation Logs page.
Sensitive data management You can configure a masking algorithm and adjust the security levels for sensitive fields in a table on the Sensitive Data page.
Permissions Permission management You can submit a ticket to apply for the relevant permissions on an instance, a database, a table, or a sensitive field. You can also view the permissions that you have on the Permissions page.
SQLConsole Single-database queries You can write SQL statements to initiate single-database queries on the Single Database query page. Single-database queries can be used to verify business code, analyze product effect, and locate issues in an online environment.
Cross-database queries DMS offers online relational queries across heterogeneous databases deployed in different environments. You can write SQL statements to initiate cross-database queries on the Cross-database Query page.
Schemas Schema design When you develop or optimize a project or process a new business requirement, you often need to change schemas. For example, when you create a table or modify an existing table, you can use the schema design feature on the Schema Design page.
Table synchronization You can use this feature to configure and manage the schemas of databases to guarantee the consistency of schemas in different environments, such as the online and offline environments.
Optimization SQL review You can use this feature on the SQL Review page to avoid publishing SQL statements that do not use indexes and may deteriorate the database performance and SQL statements that do not conform to database development standards. This feature helps protect against SQL injection attacks.
Data plans Data changes You can submit data change tickets to initialize data for a newly published project, clean up historical data, fix bugs, or conduct a test.
Data import You can use this feature to import a large amount of data to your databases at a time.
Data export You can use this feature to analyze a large amount of data at a time or extract the required data.
Data tracking If any data fails to meet your requirement due to reasons such as misoperations, you can use this feature to quickly trace historical data changes. Then, you can execute rollback statements to quickly restore data to the normal state.
Database clone You can use this feature to clone databases from one to another. Currently, only MySQL databases are supported.