We'll pick up from the previous recipe and configure the target host to also capture and deliver changes to the same set of tables on the source host.
Repeat steps 1 to 14 followed by steps 1 to 7 from the recipe Creating One-Way Replication (Simple). The rest of the steps prepare the target host to capture changes and deliver them to the applier on the source host.
The steps for bidirectional replication are as follows:
In our previous recipe, we didn't have to enable supplemental logging on the target because it was not subject to propagating changes. However, in a two-way replication, ...