After you prepare data sources, network environments, and resources, you can create a real-time sync node to synchronize data to Hologres. This topic describes how to create a real-time sync node and view the status of the node.
Prerequisites
Limits
-
DataWorks allows you to use only exclusive resource groups for Data Integration to run real-time data sync nodes.
- You can run real-time sync nodes to synchronize data only from PolarDB, Oracle, MySQL, or SQL Server data sources to Hologres.
-
A real-time data sync node cannot be used to synchronize data in a table that has no primary key.
Create a real-time sync node
Commit and deploy the real-time data sync node
- Click the
icon in the top toolbar to save the node.
- Click the
icon in the top toolbar to commit the node.
- In the Commit Node dialog box, enter your comments in the Change description field.
- Click OK.
Start the real-time sync node
Manage the real-time data sync node
- Stop a real-time data sync node that is running.
Find the real-time data sync node that you want to stop and click Stop in the Operation column. In the message that appears, click Stop.
- Undeploy a real-time data sync node that is not running.
Find the real-time data sync node that you want to undeploy and click Undeploy in the Operation column. In the message that appears, click Undeploy.
- View the alert information of a real-time data sync node.
Find the real-time data sync node that you want to view and click Alert settings in the Actions column. In the Alert settings dialog box, view the alert events and alert rules.
- Configure alert rules for a real-time data sync node.
- Find the real-time data sync node for which you want to configure alert rules and click Configure Alert Rule in the lower part of the Real Time DI page.
- In the New rule dialog box, set the parameters that are described in the following table.
Parameter Description Name The name of the alert rule. Description The description of the alert rule. Indicators The metric for which an alert is reported. Valid values: - Status
- Business delay
- Failover
- Dirty Data
- Not Supported by DDL Statement
Threshold The threshold for reporting an alert. Specify the WARNING In and CRITICAL In parameters. The default values of the parameters are 5 minutes. Alarm interval The interval at which an alert is reported. The default value is 5 minutes. WARNING The method that is used to send alert notifications. You can specify one or more methods. Valid values: Mail, SMS, and DingTalk. Note Only Singapore, Malaysia(Kuala Limpur), and Germany(Frankfurt) support the SMS reminding method. To use the SMS reminding method in other regions, submit a ticket to contact DataWorks technical support.CRITICAL Receiver (Non-DingTalk) The recipient of alert notifications. - Click Confirm.
- Modifies alert rules for real-time data sync nodes at a time.
- Select one or more real-time data sync nodes for which you want to modify alert rules and click Operation alarm in the lower part of the Real Time DI page.
- In the Operation alarm dialog box, modify the values of the Type and Indicators parameters.
- Click Confirm.