Continued from page 1 of Configuring In-Memory Database Cache

Adding / Removing TimesTen Cache Grid Members

A TimesTen cache grid consists of one or more grid members. Each grid member is backed by a TimesTen in-memory database. This section describes how to expand your cache grid by adding additional cache databases to increase processing capacity. Though not required, a grid member's cache database typically runs in a different machine from other grid members. Grid members can be added and removed online while the application is active.

Adding grid members to a TimesTen cache grid

Here are the steps required to add a grid member to a cache grid:

1. Create and configure a cache database for the new grid member Follow the steps documented in the Setting up the cache database section to configure an additional cache database.
  • Use a new DSN for each additional cache database
  • The same cache manager user must be defined in all grid members
2. Add the required cache groups into the cache database Follow the steps documented in the section Adding cache groups to a cache database to define the Oracle tables to be cached.
  • Identical global cache groups must be defined in all grid members
  • Local cache groups can be different between grid members


Removing grid members from a TimesTen cache grid

Here are the steps required to remove a grid member from a cache grid:

1. Detach the grid member from the cache grid Use the ttGridDetach built-in procedure to detach the grid member database from the cache grid. This step is required only if the database is still attached to the cache grid.
2. Stop the replication agent Use the built-in procedure ttRepStop to stop the replication agent process, if not already stopped.
3. Remove the cache groups Use the DROP CACHE GROUP statement to remove all the cache groups and the cache tables from the cache database.
4. Stop the cache agent Use the built-in procedure ttCacheStop to stop the cache agent process.

Follow the example below to remove a grid member from a cache grid using the steps described above:

Removing Grid Members from a Cache Grid example


For more information about In-Memory Database Cache, refer to Oracle In-Memory Database Cache Introduction and
Oracle In-Memory Database Cache User's Guide.

High availability for the data in the cache grid is provided via TimesTen replication, using the active standby pair scheme. For more
information about active standby pair, refer to the Active Standby Pair with In-Memory Database Cache section.


< Previous 1 2