When you manage databases across multiple regions or environments, applying a data change to each database individually is time-consuming and error-prone. Database grouping lets you group databases that share the same engine type and environment, then propagate a data change or schema design to all group members in a single operation — without selecting each database manually.
Use cases
Multi-region deployments: Group databases deployed across multiple regions. When you create a change ticket and select one database in the group, Data Management (DMS) automatically applies the change to all databases in the group.
Large-scale database fleets: Eliminate the risk of accidentally omitting a database from a change ticket when managing dozens of databases with the same structure.
Consistent schema promotion: Maintain consistent schema change workflows across databases of the same engine type in the same environment.
How it works
Data change tickets: When you create a data change ticket and select a database that belongs to a group, DMS prompts you to confirm whether to apply the change to all databases in the group. Click OK to include all group members, or Cancel to proceed with the selected database only.
Schema design tickets: After you click Perform Changes to Base Database, DMS reminds you that the base database belongs to a group and that the changes will apply to all databases in the group.
The database grouping feature supports the following data change ticket types:
Normal Data Modify
Lockless change
History Data Clean
Large Data Import
Programmable Object
Prerequisites
Before you begin, ensure that the databases you want to group meet all of the following requirements:
All instances that the databases belong to are managed in Security Collaboration mode.
All databases are physical databases or all are logical databases.
All databases are deployed in the same environment (for example, the development environment).
All databases use the same engine type (for example, all MySQL databases).
Create a database group
Log on to the DMS console V5.0.
In the top navigation bar, click O&M > Database Grouping.
If you are using DMS in simple mode, move the pointer over the
icon in the upper-left corner and choose All functions > O&M > Database Grouping.On the Database Grouping page, click New Group.
In the NewGrouping dialog box, configure the following settings.
Setting Description Group name Enter a name for the database group. Add database Click Add database. In the Search database dialog box, search for a database by name, then click Add in the Operation column for each database you want to include. Click Save.
What to do next
After you create a database group, use it to apply changes to all member databases:
Schema design: Design schemas
Regular data change: Perform regular data change
Lock-free DML: Perform lock-free DML operations
Historical data cleanup: Clear historical data
Data import: Import data
Programmable objects: Change programmable objects by using stored routines