Search code examples
symmetricds

SymmetricDS Split Channel


After read tutorial. I used MySQL and let say I have 'item_selling_price' table and 'item_selling_price' channel. The row in that table need to mapped to each store. But there is a case when a channel is busy because the traffic to one store.

How to split the channel based on store, so if one channel is busy cannot disturb others to map the row? FYI, MySQL can only has one trigger each table.


Solution

  • no need to split the channel. transfer gets blocked on a channel only to one store. not to both. also, no need to declare channel per table. it's enough to have a channel 'master data' from central to stores and 'sales' channel from stores to the central node