Configuring Replication Between TimesTen Databases

Availability is an essential requirement for most real-time applications. Industries that operate 24x7 such as telecommunications, and global systems that are Web-accessible such as travel and reservations sites, cannot tolerate service downtime. TimesTen replication enables real-time data replication between in-memory databases for high availability and load sharing. Replication can also be used to facilitate online database upgrades and maintenance.

TimesTen replication is supported over LAN and WAN connections. Both asynchronous and synchronous data replications are available. Asynchronous replication provides maximum performance, but the application is completely decoupled from the receipt process of the replicated elements on the subscriber. For "pessimistic" applications that need higher levels of confidence that the replicated data is consistent between the master and subscriber databases, options such as synchronous replication with the return receipt or return twosafe services are both supported.

Replication is transaction-log based, this enables high efficiency and low overhead. The replication agent on the master database reads the records from its transaction log and forwards any relevant changes to the replication agent on the subscriber machine, which then applies the updates to its local database. A range of replication configuration options are supported, including an active standby pair configuration with optional read-only subscribers. An active standby pair can be configured for both TimesTen In-Memory Database and TimesTen Application-Tier Database Cache (TimesTen Cache).

Oracle Clusterware is a cluster manager that monitors and controls applications to provide high availability. Clusterware can be used to manage availability for an active standby database. Clusterware enables the protection of TimesTen databases and applications within a cluster.


TimesTen Database to TimesTen Database Replication

This section describes how you can set up and administer an active standby pair consisting of TimesTen in-memory databases both with and without Oracle Clusterware.

1. Active Standby Pair with TimesTen In-Memory Database
This section lists the steps and goes through a detailed example of how to set up and manage an Active Standby Pair on a TimesTen database without Oracle Clusterware.

2. Active Standby Pair with TimesTen In-Memory Database and Clusterware
This section lists the steps and goes through a detailed example of how to set up and manage an Active Standby Pair on a TimesTen database with Oracle Clusterware.

TimesTen Cache to TimesTen Cache Replication

This section describes how you can set up and administer an active standby pair consisting of TimesTen Cache databases both with and without Oracle Clusterware.

1. Active Standby Pair with TimesTen Cache
This section lists the steps and goes through a detailed example of how to set up and manage an Active Standby Pair on an TimesTen Cache database without Oracle Clusterware.

2. Active Standby Pair with TimesTen Cache and Clusterware
This section lists the steps and goes through a detailed example of how to set up and manage an Active Standby Pair on an TimesTen Cache database with Oracle Clusterware.