Skip Navigation Links | |
Exit Print View | |
Oracle Solaris Cluster Data Service for Oracle TimesTen Guide Oracle Solaris Cluster |
1. Installing and Configuring HA for TimesTen
A. HA for TimesTen Extension Properties
B. Deployment Example: Installing HA for TimesTen in a Failover Configuration
C. Deployment Example: Installing HA for TimesTen in an Active-Active Configuration
D. Deployment Example: Installing HA for TimesTen in a Scalable Subscriber Configuration
Installing and Configuring HA for TimesTen on Local Storage in a Scalable Subscriber Configuration
Example: Preparing the Cluster for HA for TimesTen
Example: Installing TimesTen Software on Local Storage
This procedure defines the TimesTen replication.
On the master node and on both cluster nodes that host the subscriber service, add the following lines to the /timesten/TimesTen/info/sys.odbc.ini file.
[replicated] DataStore=/timesten/data/replicated PermSize=64 DatabaseCharacterSet=WE8MSWIN1252
zone1$ ttIsql replicated Command> create table t1 (col1 integer not null, col2 varchar(30), primary key (col1)); Command> CREATE REPLICATION repscheme > ELEMENT complete DATASTORE > MASTER replicated on "master-host" > subscriber replicated on "zone1" > subscriber replicated on "zone2"; Command> CALL ttRepStart; Command> create user repl identified by 'repl'; Command> grant admin to repl;
zone1$ ttRepAdmin -duplicate -from replicated \ > -host master-host -uid repl -pwd repl "dsn=replicated" zone1$ ttIsql -e "call ttrepstart;exit;" active zone2$ ttRepAdmin -duplicate -from replicated \ > -host master-host -uid repl -pwd repl "dsn=replicated" zone2$ ttIsql -e "call ttrepstart;exit;" active
zone1$ ttAdmin -repPolicy always active zone2$ ttAdmin -repPolicy always active