Data Management Service (DMS) is a comprehensive data service that integrates data management, schema management, development workflows, user and permission management, and access security. It supports relational databases, such as MySQL and SQL Server, and NoSQL databases, such as MongoDB and Redis. You can use DMS to connect to a MongoDB instance for more secure and convenient management.
Background information
DMS provides the following roles:
-
administrator: Can access all features except for data protection in the System management menu.
NoteOnly administrators can access User Management and Access IP Whitelist.
If you are an administrator, you need to log on to the instance to manage your MongoDB database.
-
security administrator: Can access Operation Audit and data protection in the System management menu.
NoteOnly security administrators can access data protection.
-
database administrator (DBA): Can access System management, Manage Instances, Task Management, Security Rules, and Schema Design Configuration in the System Management menu.
-
common user: Cannot access the System management menu.
If you are a common user, you must apply for MongoDB database permissions to manage the databases that you are authorized to access.
Prerequisites
Add the IP addresses of DMS to the whitelist of the MongoDB instance. For more information, see Configure a whitelist.
Skip this step if you have already added the DMS server IP addresses to your MongoDB instance's whitelist.
|
Network type |
DMS server IP addresses |
|
Virtual Private Cloud (VPC) |
100.104.0.0/16 |
|
classic network |
120.55.177.0/24 121.43.18.0/24 101.37.74.0/24 10.153.176.0/24 10.137.42.0/24 11.193.54.0/24 |
Log on to an instance
Go to the Replica Set Instances or Sharded Cluster Instances page. In the top navigation bar, select the resource group and region to which the desired instance belongs. Then, find the instance and click the instance ID.
In the left-side navigation pane, click Replica Set Instances or Sharded Cluster Instances.
In the upper-left corner of the page, select the resource group and region to which the desired instance belongs.
Click the ID of the instance that you want to manage or click Manage in the Actions column.
-
In the upper-right corner of the Basic Information page, click Log on to Database.
-
For a standalone instance, clicking Log on to Database redirects you to the DMS console.
-
For a replica set instance, click Log on to Database and select a node to log on to. You are then taken to the DMS console.
-
For a sharded cluster instance, click Log on to Database and select a mongos node to log on to. You are then taken to the DMS console.
-
In the Log on to Database Instance dialog box, configure the parameters described in the following table.
Parameter
Description
Database Type
The engine of the database. By default, the engine of the database to be connected is selected.
Instance Region
The region in which the instance is deployed. By default, the region of the current instance is selected.
Connection String Address
The endpoint of the instance. By default, the endpoint of the current instance is displayed.
Database Name
The name of the authentication database in which the database account is created.
NoteIf the Database Account parameter is set to root, the database name is admin.
We recommend that you do not log on to a database as the root user in the production environment. You can create users and grant permissions to them based on your requirements. For more information, see Manage the permissions of MongoDB database users.
Security hosting
The instance for which you enable security hosting enters the logon-free state.
Database Account
The account that is used to access the database. The initial account is
root.Database Password
The password of the database account.
NoteIf you have forgotten the password of the root account, reset a password.
(Optional) Click Test Connection to check whether the connection is successful.
If the Success message appears, the connection is successful. Click OK.
In the dialog box that appears, read the message carefully, click OK, and modify the configuration based on the message until the connection is successful.
Click Login.
NoteIf you want the browser to remember the password of the account, select Remember password and click Log On.
Apply for permissions
For more information, see Manage access control permissions.
FAQ
Does DMS support exporting MongoDB query result sets?
Not supported. DMS does not support exporting query result sets from MongoDB databases.