Timesten - Replication (High Availability, Workload distribution)

Timesten Component

About

TimesTen replication enables to achieve:

  • (near-continuous|High) availability
  • or workload distribution

by replicating transactions between IMDB TimesTen databases.

Type of replication

  • Asynchronous
  • Synchronous Serial
  • Synchronous Parallel

Architecture

A master host is configured to send updates and a subscriber host is configured to receive them.

A host can be both a master and a subscriber in a bidirectional replication scheme.

When replication is configured, a replication agent is started for each database. In the case of multiple database on the same host, each database has a separate replication agent.

Each replication agent can send updates to one or more subscribers and to receive updates from one or more masters. Each of these connections is implemented as a separate thread of execution inside the replication agent process. Replication agents communicate through TCP/IP stream sockets.

For maximum performance, the replication agent detects updates to a database by monitoring the existing transaction log. It sends updates to the subscribers in batches, if possible. Only committed transactions are replicated.

How

It detects conflict

Time-based conflict detection and resolution are used to establish precedence in case the same data is updated in multiple locations at the same time.

Configuration

TimesTen recommends the active standby pair configuration for highest availability.

Active standby pair

Active standby pair is the only replication configuration that you can use for replicating IMDB Cache.

An active standby pair includes:

  • an active database,
  • a standby database,
  • optional read-only subscriber databases,
  • and the tables and cache groups that comprise the databases.

Documentation / Reference





Discover More
Timesten Component
(TimesTen|TT) (In-Memory Database|IMDB)

Oracle TimesTen In-Memory Database (TimesTen) is amemory-optimized relational database. IMDB = In-Memory Database For existing application with data residing on the Oracle Database, TimesTen is deployed...
Card Puncher Data Processing
Exalytics - Timesten Configuration

Timesten on Exalytics To set the resource limits for TimesTen: Make the following changes and additions to the /etc/security/limits.conf file: Make the following shared memory kernel settings in...
Timesten Cache Group Attribute
TimesTen - Cache Group

A cache group is a collection of one or more cached Oracle tables: related to each other by foreign key constraints. arranged in a logical hierarchy by using primary key and foreign key relationships....
Timesten Component
Timesten - (Data Manager) Daemon (timestend)

The TimesTen main daemon (timestend) is a background process, which: Spawns child server process to manage shared database connections Spawns child subdaemon to manage the database Starts: the...
Timesten Component
Timesten - Commit

TimesTen supports two kinds of commit: Type Default Connection att DurableCommits Avantage Disavantage Delayed durability Yes 0 High performance Small possibility of data loss Immediate durability...
Timesten Component
Timesten - Database

A TimesTen database is a collection of elements such as: tables, views, and sequences that can be accessed and manipulated through SQL. Each TimesTen database is created when the first connection...
Timesten Component
Timesten - ttStatus Utility

With the ttStatus Utility, you can get information: on the database process such as the daemon on the connection on the replication policy on the cache agent policy where we can see that:...



Share this page:
Follow us:
Task Runner