Universal Cache installation and configuration overview
The installation and configuration procedure depends on the type of topology you want to use, the software and hardware platforms you want to install on, and the backend data server you want to cache data from.
About this task
Installation
In most cases, the complete installation includes the following components:
▪Cache
▪solidDB® server
▪IBM InfoSphere CDC for solidDB® replication engine
▪Database
▪Backend data server - prerequisite
▪IBM InfoSphere CDC for backend replication engine
Typically you would already have a working installation of the backend data server that contains the data you want to cache into an in-memory solidDB® database. Setting up caching then includes defining the connection between the cache database and the backend database, defining which tables to cache, populating the cache database, and finally activating the cache.
Preparing applications for use with Universal Cache
From the application perspective, the backend database connection needs to be replaced or supplemented with a connection to the Universal Cache environment. The SQL passthrough functionality enables applications to access data both in the frontend and backend data servers with a single connection. To use SQL passthrough, you need to install and configure a backend compatible ODBC driver on the solidDB® cache node.
Procedure
The installation and configuration of a Universal Cache system includes the following high-level steps:
1 Select an installation topology and select the servers on which to install the different components.
2 Download and extract the installation files to the appropriate computers.
3 Install the Universal Cache components and complete the initial configuration steps.
▪ The Universal Cache components are installed using the installation programs of each component.
▪The solidDB® drivers are installed as part of the solidDB® server installation. If your application is located on a different computer than the solidDB® server, you need to install the drivers on the computer where the application is located.
▪You need to perform the following configuration steps:
▪Create a solidDB® database.
▪Configure an IBM InfoSphere CDC for solidDB® instance.
▪Configure an IBM InfoSphere CDC for backend instance.
4 Optional: Install and configure backend ODBC driver for SQL passthrough.
5 Set up caching of data between your backend data server and solidDB® using IBM InfoSphere CDC Management Console. During the setup, you can populate the cache tables with data from the backend tables, or vice versa.
6 Prepare your application for use with Universal Cache.
7 Activate Universal Cache by starting replication between the cache and the backend database.