Skip to main content

Multi System Sync

Synchronize data across multiple systems with conflict resolution, eventual consistency, change detection, and sync monitoring.

Complexity: Complex | Duration: 30m+ | Category: Devops

Tags: automation sync integration data-engineering

Workflow Diagram​

Steps​

Step 1: Sync strategy​

Agent: data

engineer - Define master source, sync direction, frequency

Step 2: Change detection​

Agent: data

engineer - Track changes via timestamps, version fields, CDC

Step 3: Delta extraction​

Agent: data

engineer - Extract only changed records

Step 4: Conflict detection​

Agent: data

engineer - Detect conflicting updates in same record

Step 5: Conflict resolution​

Agent: backend

architect - Apply resolution rules (latest wins, manual review)

Step 6: Sync execution​

Agent: automation

specialist - Apply changes to target systems

Step 7: Validation​

Agent: data

engineer - Verify record counts, checksums, sampling

Step 8: Monitoring​

Agent: automation

specialist - Track sync lag, failures, conflicts

Usage​

To execute this workflow:

/workflow devops/multi-system-sync.workflow

See other workflows in this category for related automation patterns.