Before you start the DMS getting started tutorial, register two ApsaraDB RDS for MySQL instances to simulate development and production environments, and prepare a DMS administrator account and a regular user account.
Before you begin
-
Create two ApsaraDB RDS for MySQL instances. For more information, see Create an ApsaraDB RDS for MySQL instance.
NoteThis tutorial uses two instances:
POC_devfor development andPOC_prodfor production. -
Create a database named
poc_devin thePOC_devinstance and a database namedpoc_prodin thePOC_prodinstance. Create databases and accounts. -
Have a DMS administrator account ready.
NoteAdministrators handle system management, permission control, development rules, and process approval. If you sign in to and activate DMS for the first time, DMS sets your Alibaba Cloud account as the administrator.
-
Optional: Have a regular user account for DMS ready. For more information, see Add a user.
NoteRegular users can apply for database permissions and query or change data and schemas. This role covers developers, testers, product managers, operations engineers, and data analysts.
Procedure
-
Log in to the DMS console with an administrator account.
-
Create two MySQL security rules (default configuration auto-assigned) named
POC_development_database_ruleandPOC_production_database_rule. Add a security rule .NoteSecurity rules use a DSL to provide fine-grained control over development standards, access control, and data changes for database instances.
-
Add the
POC_devandPOC_prodinstances. Add an ApsaraDB instance.NoteSet the control mode of the
POC_devinstance to Security Collaboration, the security rule toPOC development database rules, and the environment type to Development. Set the control mode of thePOC_prodinstance to Security Collaboration, the security rule toPOC production database rules, and the environment type to Production. To modify settings for existing instances, Apply security rules.-
The Security Collaboration mode is the highest DMS service tier, providing all features including custom development standards, fine-grained permission control, and reliable data changes.
-
This operation incurs a fee (pay-as-you-go or subscription). Product pricing.
-
-
Grant regular users the Query and Change permissions on the
poc_devandpoc_proddatabases. Manage access control permissions or .