Help Center/ Data Replication Service/ Best Practices/ Real-Time Synchronization/ From RDS for MySQL to Kafka/ Confirming the Results
Updated on 2024-07-15 GMT+08:00
View PDF
Share

Confirming the Results

In this practice, DRS continuously synchronizes the incremental data generated in the source database to the destination database until you stop the task. The following describes how to verify the synchronization results by inserting data to the source RDS for MySQL database and viewing the data received by Kafka.

Procedure

  1. Log in to the management console.
  2. Click in the upper left corner of the management console and select AP-Singapore.
  3. Under the service list, choose Databases > Relational Database Service.
  4. Locate the required RDS instance and choose More > Log In.
  5. In the displayed dialog box, enter the password and click Test Connection.
  6. After the connection is successful, click Log In.
  7. Run the following statement to insert data to the db_test.table3_ table. 

    INSERT INTO `db_test`.`table3_` (`Column1`,`Column2`,`Column3`) VALUES(4,'00:00:44','ddd');

  8. In the Service List, choose Application > Distributed Message Service for Kafka to open the Kafka console.
  9. Click a Kafka instance.
  10. Click the Message Query tab, select the Kafka topic, view the received data in JSON format.

  11. Stop the synchronization task.

    If all data has been synchronized to the destination database, you can stop the current task.
    1. Locate the task and click Stop in the Operation column.

    2. In the display box, click Yes.