Configuration for In Memory Database Cache

Configuration for In-Memory Database Cache

Continued from page 1

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 with the growth of the 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 on-line while the application is active.

How to add 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 tn the section "How to set up a cache database" 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 "How to add cache groups to a 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

How to remove 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.

This example shows how to remove a grid member from a cache grid using the steps described above.

For more information about In-Memory Database Cache, refer to the 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 section How to set up and manage an Active Standby Pair on a cache database for more information.

< Previous 1 2