Help Center/ Data Admin Service/ Service Overview/ DAS and Other Services
Updated on 2024-08-26 GMT+08:00
View PDF
Share

DAS and Other Services

With DAS, you can access cloud databases with a few clicks instead of through clients.

  • You can securely access data anytime and anywhere.
  • You can directly manage and modify the data directory structure on the web-based console.

Relational Database Service (RDS)

DAS supports the management of RDS instances.

  • You have the username and password for logging in to the target database.
  • RDS instances and DAS are in the same region.
Table 1 DAS functions available to RDS instances

Module

MySQL

Microsoft SQL Server

PostgreSQL

Database Management

√

√

√

SQL Window

√

√

√

SQL History

√

√

√

Import

√

√

√

Export

√

√

√

Table Structure Comparison and Synchronization

√

×

×

Data Tracking and Rollback

√

×

×

Data Generator

√

×

×

Task Scheduling

√

×

×

Real-Time Performance

√

×

×

Real-Time Sessions

√

√

×

SQL Diagnosis

√

×

×

Diagnosis Report

√

×

×

InnoDB Lock Query

√

×

×

User Management

√

√

×

Elastic Cloud Service (ECS)

DAS supports the management of ECS databases. To manage this type of databases, the following requirements must be met:

  • You have the username, password, and port for logging in to the target database.
  • ECSs and DAS are in the same region.
  • The engine version of the managed MySQL instances can be 5.5, 5.6, 5.7, or 8.0. The instances are not deployed in HA clusters.
Table 2 DAS functions available for different ECS databases

Module

MySQL

Microsoft SQL Server

PostgreSQL

Database Management

√

√

√

SQL Window

√

√

√

SQL History

√

√

√

Import

√

√

√

Export

√

√

√

Task Scheduling

√

×

×

Real-Time Performance

√

×

×

Real-Time Sessions

√

√

×

SQL Diagnosis

√

×

×

Diagnosis Report

√

×

×

InnoDB Lock Query

√

-

×

User Management

√

√

×

Document Database Service (DDS)

DAS supports the management of DDS DB instances. To manage DDS DB instances, the following requirements must be met:

  • You have the username and password for logging in to the target database.
  • DDS DB instances and DAS are in the same region.
Table 3 DAS functions available to DDS instances

Module

Function

DDS

Command Operation

To query commands.

√

To display command execution records.

√

Database Management

To manage databases.

√

Collections

To manage database collections.

√

Views

To manage database views.

√

User Management

To create and manage users.

√

Role Management

To create and manage roles.

√

GaussDB(for MySQL)

DAS supports the management of GaussDB(for MySQL) DB instances. To manage GaussDB(for MySQL) DB instances, the following requirements must be met:

  • You have the username and password for logging in to the target database.
  • GaussDB(for MySQL) instances and DAS are in the same region.
  • The DB engine is MySQL 8.0.
Table 4 DAS functions available to GaussDB(for MySQL) DB instances

Module

DAS functions available to GaussDB(for MySQL) DB instances

Database Management

√

SQL Window

√

SQL History

√

Import

√

Export

√

Task Scheduling

√

Real-Time Performance

√

Real-Time Sessions

√

SQL Diagnosis

√

Diagnosis Report

√

InnoDB Lock Query

√

User Management

√

Distributed Database Middleware (DDM)

DAS supports the management of DDM instances. To manage DDM instances, the following requirements must be met:

  • You have the username and password for logging in to the target database.
  • DDM instances and DAS are in the same region.
Table 5 DAS functions available to DDM instances

Module

DDM

Database Management

√

NOTE:

Only the structure of global and single tables can be edited. Database creation and modification are not supported.

SQL Window

√

SQL History

√

Real-Time Sessions

√

GeminiDB Cassandra API

DAS supports the management of GeminiDB Cassandra instances. To manage GeminiDB Cassandra instances, the following requirements must be met:

  • You have the username and password for logging in to the target database.
  • GeminiDB Cassandra instances and DAS are in the same region.
Table 6 DAS functions available to GeminiDB Cassandra instances

Module

GeminiDB Cassandra

Keyspace Management

√

NOTE:

Creation of tables and views is not supported.

SQL Window

√

SQL History

√

Role Management

√

Data Warehouse Service (DWS)

DAS allows you to manage GaussDB(DWS) instances.

  • You have the username and password for logging in to the target GaussDB(DWS) database.
  • GaussDB(DWS) instances must be of version 8.0.1 or later.
Table 7 DAS functions available to GaussDB(DWS) instances

Module

DAS functions available to GaussDB(DWS) instances

Database Management

√

SQL Window

√

SQL History

√