Similar to data import, data backflow also needs to configure a data synchronization task. But the source of the backflow task is a MaxCompute table, and the target library is a business library, which is the house_web_master database of RDS-MySQL in the example.
Create a corresponding table in RDS > MySQL. If you want to keep the daily data, you can add a field to save the date information.
Enter the DataWorks > Data Integration page to configure the data source. For more information, see Configure RDS data sources.
Assuming that the task is named house_unit_price_top5_2_mysql. Synchronize the data in the MaxCompute table to RDS > MySQL. Two configurations are as follows:
Field configuration: If you want to directly synchronize the partition field of the source table to the MySQL date information field, configure it as shown in the following figure:
For the dependency property, set the data processing task house_unit_price_top5 as the parent task to make sure that the latest data is applied for each backflow. See the following figure.
Click Save and Submit the task. You can see the workflow status in Maintenance Management:
Perform the backflow task. For more information, see Perform data import tasks.
After the task succeeds, you can go to RDS > MySQL to check whether the table data is imported normally.