Replication from a Single Source to Multiple Targets
You can replicate data from a single source database to multiple target databases on different systems.
This topology is not supported for Amazon Redshift
or Apache Kafka targets.
Typically, you install Data Replication on the source system and on each target system. On the source machine, run an Extractor task and a Server Manager instance. On each target machine, run an Applier task and a Server Manager instance. Each target requires a separate Applier task and Server Manager instance.
If the resources on a target machine are constrained, you can run the Applier task and Server Manager instance for that target on another machine that can access the target database by using the native target database connectivity client or and ODBC driver.
One of the target databases is considered to be the
primary target database
. The other
secondary target databases
must be the same target type as the primary target. Also, all of the mapped target tables must have identical schema definitions. However, the target schemas can have different names.
The primary target database is defined on the
Target Database
tab in the Data Replication Console. The secondary target databases are defined on the
Routing
tab in the same replication configuration.
The following image shows a typical topology that includes three targets, each with an Applier task and Server Manager instance, and the Data Replication Console on a standalone machine: