My blog about How do I create a simple TimesTen HA config in the Oracle Bare Metal Cloud, resulted in a TimesTen Active Standby Pair being created on two HighIO instances in the cloud.
This blog uses that TimesTen Active Standby Pair to do some simple SQL operations.
My active standby pair used the following IP addresses:
To use this TimesTen Active Standby Pair I needed to use a bash shell (from Linux, MacOS or Cygwin):
In a separate terminal window, I also logged on to the TimesTen standby database:
The ttStatus command shows that the ttimdb database is loaded into memory on machine doughigh2 and that there are various replication connections:
On the active database [doughigh1] I also run the ttStatus utility to verify that the database was loaded into memory and that replication was running:
In the ttimdb database that I created, the schema owner was called appuser. To connect to the database as user appuser, I needed to do the following:
I could then start using SQL to select the current customers and add a new customer to the active DB on machine doughigh1:
I could also update and deletes rows in the active database:
On the standby database [doughigh2], I checked the rows in the customers database before and after rows are changed on the active database. I could not write to the standby database as it is read only.
To be able to create and alter tables on the active database, I needed to login as the TimesTen instance administrator as the DB user appuser did not have the admin privilege. The create table and alter table commands were replicated to the standby database:
The create and alter table statements are replicated to the Standby Database. On host doughigh2:
Disclaimer: these are my personal thoughts and do not represent Oracle's official viewpoint in any way, shape, or form.