Help Center/ Data Replication Service/ FAQs/ General Operations/ How Do I Set the Number of Source Shards and Source Database Information When DDM Is the Source Database?
Updated on 2024-11-30 GMT+08:00

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.

Figure 1 Synchronization instance details

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.

Figure 2 Source database information
Table 1 Source database settings

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.