In addition to the basic data query and development functions, DMS also has built-in SQL audit, performance diagnostic optimization, automatic generation of test data, multi-environment data comparison and synchronization, database log tracing rollback, lockless table changes, access control, sensitive data desensitization, security audit and other high-end functions.

1. Rich data sources

🔸 Rich database type support (currently over 25 and expanding)

  • MySQL, SQL Server, PostgreSQL, POLARDB and other relational databases
  • DRDS and other OLTP databases
  • AnalyticDB for MySQL, DLA and other OLAP databases
  • MongoDB, Redis and other NoSQL database management
  • It also supports Linux server management

🔸 Rich environmental source support

  • Ali Cloud Database
  • Ali Cloud ECS self-built database
  • The local IDC self-built database
  • Third-party cloud service database
  • Third-party cloud servers have self-created databases
On the basis of the Web side, this release client software version, support to download to the local out-of-the-box; Relative to the Web side, this time also provides a large number of updates more close to the use of the local client, reduce the threshold of use.

1) The list of database resources that have been recorded and used by DMS is displayed on the left (it can be synchronized with the database list of the Web console). 2) The cloud database and self-built database of the cloud server can be accessed through the public network. 3) Switching between different databases can be logged in at the same time

2, DMS client killer

🔻 Low-cost database log tracking and recovery



🔻 Convenient test data construction, quick preparation of a large amount of test data to reduce data preparation time



🔻 Visual database performance diagnosis and optimization, master the running status, effectively optimize the diagnosis of SQL to ensure the stable running of services:



One-click diagnosis enables you to learn about the running status of the database in real time and quickly discover and repair anomalies



Analyze the performance trend, understand the running trend, locate exceptions, and plan capacity



More database performance diagnostic optimization services



3. Teach you how to use THE DMS client

The procedure is as follows: Select the OS version to download



The following uses the MacOS as an example



Double-click to open the software, enter the Ali Cloud account login page, you can choose a variety of login methods



Log in to the cloud account and enter the following page:



Add a database to be managed





Or directly retrieve the database that has been logged in for quick login and use, you can log in to multiple databases at the same time for convenient visualization management of data and structure









Fast consistency comparison and synchronization of multi-environment table structures





More rich features are available for product experience:

  • Accurate database performance analysis, diagnosis and optimization
  • Fine-grained permission control and intelligent data desensitization
  • Intelligent SQL risk audit
  • Configurable syntax specification and r&d process, approval process
  • Stable data changes and structural changes (unlocked table)
  • Efficient data development task cycle scheduling management
  • Easy to use data analysis, cross-library query services




The original link

This article is the content of Ali Cloud, shall not be reproduced without permission.