Warm standby applications

In a warm standby application, Replication Server maintains a pair of databases from the same vendor, one of which acts as the backup of the other.

Typically, client applications update the active database while Replication Server maintains the other database as a standby copy of the active database. If the active database fails, or if you need to perform maintenance on the active data server or database, you can switch to the standby database (and back) with little interruption of client applications.

In a warm standby application, you create three connections:

The logical database in a warm standby application may, with respect to other databases in the replication system, function as one of the following:

The procedure in this section demonstrates how to set up a warm standby system for a database that acts as a primary database in a replication system.

Figure 3-8 illustrates a warm standby application operating on the BOSTON_DS data server for a pubs2 database on the NY_DS data server. The database is replicated to TOKYO_DS.

Figure 3-8: Warm standby system

Figure 3-8 illustrates a warm standby application operating on the Boston underscore D S data server for the primary active pubs 2 database on the New York underscore D S data server. The database is replicated to the Tokyo underscore D S data server.

In this scenario the pubs2 database acts as a primary database in a replication environment. The primary pubs2 database for which a standby is created is called the active database.