How Do I Set the Number of Source Shards and Source Database Information When DDM Is the Source Database?
DRS supports migration and synchronization with DDM serving as the source. When creating a task, you need to select the number of shards based on the number of instances bound to the source DDM. The following uses real-time synchronization as an example, as shown in Figure 1. For example, if the source DDM has two DNs, each mounting on RDS for MySQL instance 1 and RDS for MySQL instance 2, set Source DB Instance Quantity to 2.
After the task is created, enter the source database information on the Test Connection page, as shown in Figure 2. Assume that the IP address of the source DDM instance is 192.168.5.11, the IP address of the mounted RDS for MySQL instance 1 is 192.168.1.10, and the IP address of the mounted RDS for MySQL instance 2 is 192.168.6.150, set the parameters as shown in Table 1.
Parameter |
Description |
|---|---|
Middleware IP Address or Domain Name |
The IP address or domain name of the source DDM middleware. In this example, the IP address is 192.168.5.11. |
Port |
The port of the source DDM middleware. The value is an integer ranging from 1 to 65535. The default DDM port number is 5066. Set this parameter based on the site requirements. |
Middleware Username |
The username of the source DDM middleware. |
Database Password |
The password for the source DDM instance username. |
SSL Connection |
SSL encrypts the connections between the source and destination databases. If SSL is enabled, upload the SSL CA root certificate. |
DB Instance |
The DN sharded database details. In this example, set the IP addresses of the two sharded databases to 192.168.1.10 and 192.168.6.150, respectively. |
General Operations FAQs
- What Can I Do When Information Overlaps on the DRS Console?
- Is the Destination Instance Set to Read-only or Read/Write?
- How Do I Set Global binlog_format=ROW to Take Effect Immediately?
- How Do I Set binlog_row_image=FULL to Take Effect Immediately?
- How Do I Change the Destination Database Password to Meet the Password Policy?
- How Do I Configure the Shard Key for a MongoDB Sharded Cluster?
- Does Bandwidth Expansion Affect the Running DRS Tasks?
- Why Data in MariaDB and SysDB Cannot Be Migrated or Synchronized?
- Constraints and Operation Suggestions on Many-to-One Scenario
- Constraints and Operation Suggestions on One-to-Many Scenario
- Where Can I View DRS Operation Logs?
- Why Is the Language of the Message Sent by DRS Inconsistent with That on the Page?
- Why Is a DRS Task Automatically Stopped?
- How Can I Export a DRS Task List?
- Can a Completed Task Be Restarted?
- What Are the Differences Between Resetting a Task and Recreating a Task?
- Does DRS Support Backward Migration/Synchronization?
- Why Cannot I Select an Existing SMN Topic?
- Can I Change an SMN Topic After a Task Is Created?
- How Do I Set the Number of Source Shards and Source Database Information When DDM Is the Source Database?
- Will Data of DRS Tasks Be Lost After a Primary/Standby Switchover Occurs on the Source MySQL Database?
- What Are the Differences Between All, Tables, and Databases During DRS Object Selection?
- What Do I Do After Changing the Password of the Source or Destination Database?
- How Do I Configure an SMN Topic Policy to Allow DRS to Publish Messages?
- What Can I Do If a DRS Task Times Out Due to Too Many Tables?
- Can I Change the Source or Destination Database After a DRS Task Is Created?
Feedback
Was this page helpful?
Provide feedbackThank you very much for your feedback. We will continue working to improve the documentation.See the reply and handling status in My Cloud VOC.
For any further questions, feel free to contact us through the chatbot.
Chatbotmore
