Data Management (DMS) allows you to register database instances. You can register and manage your ApsaraDB instances in the DMS console.
Prerequisites
- An ApsaraDB instance is created, such as an ApsaraDB RDS for MySQL instance.
- DMS is activated.
- You are a DMS administrator or a database administrator (DBA) in DMS.
- The AliyunRDSFullAccess permission is obtained to register an ApsaraDB RDS for MySQL instance with DMS as a RAM user. For more information, see Grant permissions to a RAM user.
Background information
- A database instance can be managed by using multiple Alibaba Cloud accounts. Before you register the database instance in the DMS console, go to the User tab and add the Alibaba Cloud accounts that are allowed to manage the database instance as DMS users. For more information, see Register a database instance that is accessible to multiple Alibaba Cloud accounts.
- To allow DMS users to manage database instances in the DMS console, you must grant
permissions to the DMS users based on your actual needs. For more information about
the syntax that you can use to grant permissions, see the official documentation of
each type of database. The DMS users are required to have the following permissions:
- To manage all the databases of an instance, a DMS user must have permissions on all the databases.
- To manage one or more databases of an instance, a DMS user must have permissions on the specific databases.
- To add, delete, modify, and query data in an instance and change schemas, a DMS user must have sufficient data manipulation language (DML) permissions.
- To perform operations on objects such as views, stored procedures, triggers, and functions in an instance, a DMS user must have sufficient permissions on these objects.
- We recommend that you create a separate database account when you register a database instance.
- To avoid interference, do not add spaces or special characters before or after the information that you enter when you register a database instance.
- DMS allows you to register the following types of ApsaraDB instances:
- ApsaraDB RDS for MySQL
- ApsaraDB RDS for SQL Server
- ApsaraDB RDS for PostgreSQL
- ApsaraDB for MongoDB
- ApsaraDB for Redis
- PolarDB-X
- ApsaraDB OceanBase for MySQL
- ApsaraDB OceanBase for Oracle
- PolarDB for MySQL
- PolarDB-O
- PolarDB for PostgreSQL
- AnalyticDB for MySQL V2.0
- AnalyticDB for MySQL V3.0
- AnalyticDB for PostgreSQL
- Data Lake Analytics (DLA)
- ClickHouse
- ApsaraDB RDS for MariaDB
- ApsaraDB RDS for PPAS
- MaxCompute
- ApsaraDB for HBase V2.0 Standard Edition
- ApsaraDB for Lindorm
- ApsaraDB for Cassandra