Permitted Configurations and Combinations v6.2

Depending upon the database products you are using with xDB Replication Server (Oracle, SQL Server, PostgreSQL, or Advanced Server) along with the compatibility configuration mode if you are using Advanced Server, certain combinations of a source database server and a target database server are not permitted for a publication and its associated subscription in a single-master replication system.

Similarly, only certain combinations of database products and Advanced Server compatibility configuration modes can be used together in a multi-master replication system.

For a single-master replication system, the source refers to the database server of the publication database. The target refers to the database server of the subscription database.

For a multi-master replication system, all of the participating database servers act as both a source and a target for all other participating database servers, so the restrictions pertain to the combinations of database servers and compatibility configuration modes that can be used together in the same multi-master replication system.

Note

A Publication or Subscription database cannot be shared across SMR and MMR clusters. For example, if inventory is registered as a Subscription database in a SMR cluster, it cannot be registered as a Publication database in the MMR cluster. While xDB might not throw an error, such a type of deployment architecture is not supported.

This section presents the specific combinations of database server configurations that can be used for a publication and its associated subscription in a single-master replication system, and the combinations of database server configurations that can be used in a multi-master replication system.

Advanced Server Compatibility Configuration Modes

Advanced Server supports two compatibility configuration modes of operation, which are the following:

  • Oracle compatible configuration mode. Operations are performed using Oracle syntax and semantics for data types, functions, database object creation, and so forth. This mode is useful when your applications are migrated from Oracle, or you want your applications built in an Oracle compatible fashion.
  • PostgreSQL compatible configuration mode. Operations are performed using native PostgreSQL syntax and semantics. This mode is useful when your applications are migrated from PostgreSQL, or you want your applications built in a PostgreSQL compatible fashion.

For more information on features supported in Oracle compatible configuration mode, see the Database Compatibility for Oracle Developer’s Guide located at:

https://www.enterprisedb.com/resources/product-documentation

The compatibility configuration mode is selected at the time you install Advanced Server.

Permitted SMR Source and Target Configurations

The following table shows the combinations of source and target database server products and Advanced Server compatibility configuration modes permitted by xDB Replication Server for single-master replication systems:

Table 10-1: Permitted Source and Target Configurations

Source \ TargetOracleMicrosoft SQL ServerPostgreSQLAdvanced Server (Oracle compatible)Advanced Server (PostgreSQL compatible)
OracleNoNoYesYesYes
Microsoft SQL ServerNoNoYesYesYes
PostgreSQLYesYesYesYesYes
Advanced Server (Oracle compatible)YesYesNoYesNo
Advanced Server (PostgreSQL compatible)YesYesYesYesYes

In the preceding table, the left hand column lists the possible source database server products including the possible Advanced Server compatibility configuration modes. The top row lists the same set of possible target database server products and Advanced Server compatibility configuration modes.

Yes at the intersection of a source and target indicates that xDB Replication Server permits replication using that combination of database server configurations for a publication and its associated subscription. No indicates replication is not permitted for that combination.

Permitted MMR Database Server Configurations

For multi-master replication systems, each primary node acts as both a source for all primary nodes and a target for all primary nodes. Thus, the permitted database servers comprising a particular multi-master replication system or cluster is determined by the overall composition of the cluster, which is initially established when selecting the database type of the primary definition node (see Step 3 in Section Adding the Primary definition node). There are two basic cluster types that can be characterized as follows:

  • PostgreSQL compatible cluster. All primary nodes must consist of PostgreSQL database servers or Advanced Servers installed in PostgreSQL compatible configuration mode.
  • Advanced Server Oracle compatible cluster. All primary nodes must consist of Advanced Servers installed in Oracle compatible configuration mode.

The following table summarizes the permitted database server configurations allowed in the two cluster types.

Table 10-2: Permitted Database Server Configurations by Cluster Type

Database Server \ Cluster TypePostgreSQL Compatible ClusterAdvanced Server Oracle Compatible Cluster
PostgreSQLYesNo
Advanced Server (PostgreSQL compatible)YesNo
Advanced Server (Oracle compatible)NoYes

In the preceding table, the left hand column lists the possible database server products including the possible Advanced Server compatibility configuration modes. The top row lists the supported cluster types.

Yes at the intersection of a database server and cluster type indicates that xDB Replication Server permits the database server and the specified configuration mode in the cluster type. No indicates the database server and the specified configuration mode cannot be used in the cluster type.