CODEWITHSUNDEEP
symmetricds
Yosua Lijanto Binar
Yosua Lijanto Binar

Reputation: 670

SymemtricDS Multi-Tier Data Monitoring

I have 3 tier nodes (corp, store, device) and have item table each node.

Let say, I want to add monitoring data of item table to monitoring table. The monitoring table shows time and current_node of the data currently.

How to do centralized monitoring from the corp that tell the data is arrived to device? Especially it doesn't edit the SymmetricDS' generated structure.

My past idea is requiring to edit the trigger. Any ideas?

The scenario is:

  1. corp input the data
  2. corp also input data monitor that tells time and current_node (corp)
  3. The data is syncing to store
  4. store edit the data monitor (time and current_node to store)
  5. The data is syncing to device
  6. device edit the data monitor (time and current_node to device)

Upvotes: 0

Views: 220

Answers (1)

Boris Pavlović
Boris Pavlović

Reputation: 64632

Use custom_on_update and custom_on_insert of the sym_trigger table defining an item table trigger. Initialize it with an SQL script that will update/insert a row in the monitoring table with the changes of the item table. Of course declare a trigger on monitoring table to have it synced from a device to store and from store to corp.

Upvotes: 0

Related Questions