This topic describes how to configure a task to synchronize data from MySQL to Hologres in real time. You can configure a task to synchronize data from multiple tables at a time. However, performance of the task is based on the amount of available computing resources. If you attempt to simultaneously synchronize data from a large number of tables, you may run out of computing resources. As a result, the task takes a longer time to complete or fails completely.
If you run data definition language (DDL) statements to add columns to the source tables of a real-time synchronization task, the new columns are automatically added to the destination table.
Step 1: Add a MySQL data source
In your workspace, click the icon.
Click the Add data source button in the upper-right corner.
In the Add MySQL data source dialog box, configure the required parameters.
After you complete the parameter configurations, select an exclusive resource group for data integration to test the connectivity. If no exclusive resource groups for data integration are available, create one before you perform the connectivity test.
Step 2: Configure a real-time synchronization task
On the Project Management page of the MaxCompute console, find your project and click Data Development in the Actions column.
If no business workflows are available, right-click Business Flow and select Create Workflow from the shortcut menu.
Right-click Data Integration and choose Create Node > Real-time synchronization from the shortcut menu.
Set Sync Method to Migration to Hologres.