Many customers have asked me how do I run TimesTen in the Cloud. This series of blogs shows you how to quickly and cheaply run TimesTen in the Oracle Bare Metal Cloud.
The formula is simple:
- A single script installs and configures TimesTen on any of the available Bare Metal compute shapes. A white paper explains all of the steps in great detail.
- TimesTen will run on metered compute instances which are charged by the hour.
- TimesTen will use a "bring your own license model".
- The compute instances will use the Bare Metal Oracle Linux 7.3 image as the TimesTen Cloud install script uses systemd
- As the compute instances run in the customer's tenancy, customers can SSH to the compute instances and run their own applications. This enables Direct Linked connections to the TimesTen RDBMS for latency critical applications.
- Optionally download JDK8 if you want to test your JDBC applications with TimesTen
- TimesTen can be installed and up and running on a set of machines (using the provided script) in under 5 minutes (if you have a broadband internet connection with fast upload speeds).
TimesTen In-Memory Database can run really fast in your data center. TimesTen can also run really fast in the Oracle Bare Metal Cloud, but just how fast depends on the hardware that it runs on and how it is configured:
- There are nine NVMe storage devices which can be striped for extreme IO performance.
- There are four NVMe storage devices which can be striped for extreme IO performance.
- These NMVe storage devices are local to the compute instance.
- The hardware is based on Sun X5-2. This is a dedicated server with no VMs.
- The hardware is based on Sun X5-2. This is a shared server with VMs.
- Only iSCSI (Block Volume Service) is available for storage.
- The 32 GB local disk is not big enough for the TimesTen checkpoint files and transaction logs.
- The block volumes can be 256 GB or 2 TB in size. The block2 volumes are available with 1 GB increments (starting at 50 GB).
- While the Block Volume Service does not give as impressive IO performance as the NMVe SSDs, it is cheap and the block volumes exist independent of the compute shape.
- The TimesTen DB cannot use all of the DRAM on the compute node as memory is needed for the OS, any non TimesTen applications and other data structures in the TimesTen (ie Log Buffer, Temp/Sort Area and PLSQL).
- At least two 256 GB block Volumes are needed for the TimesTen Checkpoint files
A white paper which covers all of the details is available here.
Once you have provisioned one or more of the above Bare Metal compute shapes, run the following script from your on premise machine [bash shell in Linux, MacOS or Cygwin] to install TimesTen on your compute shapes.
- If you use Cygwin, you need to explicitly install the OpenSSH and Unzip packages
$ ott-bmc-byol/scripts/ott_bmc_install <ipaddr> [<ipaddr> …]
The script does the following on each of the IP address that were passed to the script:
- Installs TimesTen in /opt/TimesTen as user oracle
- Installs the TimesTen Quickstart to enable various demo databases and programs to be created
- Uses yum to install NTP, libaio, lvm2, yum-plugin-security, nc and dstat and updates any needed packages
- Creates the /u10 file system for the TimesTen checkpoint and transaction log files
- The NVMe devices will be striped using LVM for the BM.DenseIO1.36 and BM.HighIO1.36 shapes
- The iSCSI Bare Metal Block Volumes will be striped using LVM
- Configures NTP to control clock skew
- Configures the Bare Metal network and adds firewall ports
- Configures systemd to run the TimesTen main daemon as a service
- Starts the TimesTen main daemon, but no TimesTen databases are created
An up-coming series of blogs will show you how to use TimesTen in the Oracle Bare Metal Cloud:
Disclaimer: these are my personal thoughts and do not represent Oracle's official viewpoint in any way, shape, or form.