Managed Routing Load and Workloads with Data Synchronization | Teradata Business Continuity Manager - Managed Routing Load and Workloads Requiring Data Synchronization - Teradata Business Continuity Manager

Teradata® Business Continuity Manager User Guide - 1.01.01

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
VMware
Product
Teradata Business Continuity Manager
Release Number
1.01.01
Published
March 2023
Language
English (United States)
Last Update
2023-03-13
dita:mapPath
qra1653979755546.ditamap
dita:ditavalPath
ft:empty
dita:id
B035-2550
lifecycle
previous
Product Category
Analytical Ecosystem

Managed routing is recommended for data synchronization. Use a managed routing rule for load, ETL, or ELT processes that write permanent data to the Teradata systems to synchronize it across a set of Teradata systems.

Managed routing sessions are logged to the Business Continuity Manager Recovery Log, so if any system is unavailable or encounters an unexpected error, Business Continuity Manager can automatically replay the request when the system becomes available.

Managed routing also performs continuous consistency checking on the responses to any write performed to the database systems, to make sure all systems produce the same results.

Changes made in managed routing sessions can be synchronized in two ways. You can use SQL Multicast or CDM, if it is enabled on the Teradata systems. Managed routing parses the incoming request to identify the affected tables and rows, and whether the query is deterministic. If the query is non-deterministic, it can run the request on the active system first, and then replicate the change on the standby system using CDM.
Changes performed on DBC users are never replicated using CDM.