How to synchronize data from a table by using ricds?

Source: Internet
Author: User

How to synchronize data from a table by using ricds?
1. Create a channel

insert into sym_channel(channel_id, processing_order, max_batch_size, enabled, description)values('test', 1, 100000, 1, 'channel test for table test')

A channel is a set of one or more tables to be synchronized in a transaction.

2. Create a Trigger for the table to be synchronized

insert into sym_trigger(trigger_id,source_table_name,channel_id,last_update_time,create_time)values('test','test','test',current_timestamp,current_timestamp);

Create a synchronization Trigger (and a Dead Trigger) for each table and put the table in a channel.

3. Create a Router

insert into sym_router(router_id,source_node_group_id,target_node_group_id,router_type,create_time,last_update_time)values('test_2_test', 'corp', 'store', 'default',current_timestamp, current_timestamp);

Create a Router with the concept of direction. Data can also be filtered.

4. Create a Trigger-Router Link

insert into sym_trigger_router(trigger_id,router_id,initial_load_order,last_update_time,create_time)values('test','test_2_test', 100, current_timestamp, current_timestamp);

You need to associate the Trigger with the Router, that is, pass the data obtained by the Trigger to the Router, and then the Router sends the data to other nodes. Trigger and Router are many-to-many relationships. Therefore, a Join table is required. This is the Join table.

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.