View Revisions: Issue #6331
| Summary | 0006331: Allow specification of initial load select for initial load of filesync channel | ||
|---|---|---|---|
| Revision | 2024-04-08 12:27 by pmarzullo | ||
| Description | When executing an initial load of files, all files are sent to every node instead of allowing an initial load select to be run against the sym_file_snapshot table. Allow the specification of an initial load select that will be applied to the sym_file_snapshot table. 1. Create an actual trigger definition for the sym_file_snapshot instead of relying on a virtual trigger definition. Trigger ID: sym_file_snapshot Table name: sym_file_snapshot Channel ID: dynamic (user interface does not allow it, you will have to modify after creating it) Reload Channel ID: filesync_reload (user interface does not allow it, you will have to modify after creating it) Channel Expression: $(curTriggerValue).$(curColumnPrefix)channel_id 2. Define a filesync router Router ID: sym_file_snapshot_<sourcegroup>_2_<targetgroup> Router Type: filesync (user interface does not allow it, you will have to modify after creating it) 3. Define a sym_trigger_router for the filesync trigger and router Trigger ID: sym_file_snapshot Router ID: sym_file_snapshot_<sourcegroup>_2_<targetgroup> Initial Load Select: some where clause using the relative_dir for filtering |
||
| Revision | 2024-04-05 17:31 by pmarzullo | ||
| Description | When executing an initial load of files, all files are sent to every node instead of allowing an initial load select to be run against the sym_file_snapshot table. Allow the specification of an initial load select that will be applied to the sym_file_snapshot table. 1. Create an actual trigger definition for the sym_file_snapshot instead of relying on a virtual trigger definition. Trigger ID: sym_file_snapshot Table name: sym_file_snapshot Channel ID: dynamic (user interface does not allow it, you will have to modify after creating it) Reload Channel ID: filesync_reload (user interface does not allow it, you will have to modify after creating it) Channel Expression: $(curTriggerValue).$(curColumnPrefix)channel_id 2. Define a filesync router Router ID: sym_file_snapshot_<sourcegroup>_2_<targetgroup> Router Type: filesync 3. Define a sym_trigger_router for the filesync trigger and router Trigger ID: sym_file_snapshot Router ID: sym_file_snapshot_<sourcegroup>_2_<targetgroup> Initial Load Select: some where clause using the relative_dir for filtering |
||