You can configure multisite availability (MSA) to set up a two-way replication of data definition language (DDL) transactions between two Adaptive Server databases.
In version 15.0, bidirectional DDL replication support in MSA environments is supported only for non-warm standby databases.
Replication Server 15.0 supports this bidirectional replication using a new configuration parameter dsi_replication_ddl. When dsi_replication_ddl is set to on, DSI sends set replication off to the replicate database, which instructs it to mark the succedent DDL transactions available in the system log not to be replicated. Therefore, these DDL transactions are not replicated back to the original database, which enables the DDL transactions replication in bidirectional MSA replication environment.
Setting up bidirectional replication
Create a bidirectional MSA replication environment. For steps, see Chapter 12, “Managing Replicated Objects Using MultiSite Availability,” in the Replication Server Administration Guide Volume 1.
Grant “set session authorization” privilege to a maintenance user on the destination database, as shown in the following example:
grant set session authorization to maint_user
In the destination database, set dsi_replication_ddl to on to enable bidirectional DDL replication, as shown in the following example:
alter connection to dataserver.database set dsi_replication_ddl on
Replicate DDL transactions.
