X

TimesTen In-Memory Database
for Extreme Performance

TimesTen Scaleout Terminology

Doug Hood
TimesTen Cloud Product Manager

Introduction

Oracle TimesTen Scaleout is a distributed database that has its own terminology. This blog discusses those terms and common variations.

 

Host

A TimesTen Scaleout host is a physical machine, a virtual machine or a container. As TimesTen Scaleout has a shared nothing architecture, each host logically has its own CPU, memory, persistent storage and networking. For optimal performance and availability, physical [bare metal] machines should be used as hosts. Virtual machines can have significant network and disk IO overhead compared to bare metal machines. Also virtual machines and containers need to share their resources (CPU, memory, persistent storage and networking).

host

 

Database

A database is a set of users, tables and other schema objects that applications can connect to. Every database is distributed across all the data instances.

Hosts

 

 

 

Instance

A TimesTen Scaleout instance is a running copy of the TimesTen software. The instance includes the processes and files that exist on a host. A host may contain one or more instances. Each instance contains a single element of the database.

instances

For optimal high availability, you should configure one instance per host.

For development and test environments, it can be convenient and cheaper to configure multiple instances per host. If you configure multiple instances per host, you need to make sure that there is sufficient memory and disk space for each instance. Having multiple instances per hosts means that each instance needs to share the hosts CPU, network, disks and memory.

 

Element

Each instance contains a single element. Elements correspond to the traditional TimesTen In-Memory Database components (shared memory, daemon and sub-daemon processes, checkpoint files and transaction log files). Each element can persistently store its own data and be recovered independently.

An element is the unit of recovery

 

Replica Sets and Data Space Groups

A TimesTen Scaleout database will usually consist of many hosts.To enable high availability and avoid single points of failure, there can be multiple copies of an element. The copies of an element are called relica sets

TimesTen Scaleout uses the two phase commit protocol which means that the copies of an element are relicas of each other. The number of copies of an instance corresponds to the number of data space groups. A TimesTen Scaleout database with a single data space means that there is no data redundancy and that each instance is a single point of failure. A TimesTen Scaleout database with two data spaces means that there is data redundancy and that each element is not single point of failure.

Data spaces and replia sets

The picture on the left shows that the intersection of a replica set and the data space group is an instance. In the picture on the right, if a host contains a single instance then the intersection of replica set and a data space group is a host. Having a single instance per host provides the best availability.

SQL Developer data space groups and replica sets

The above picture shows how SQL Developer displays data space groups and replica sets.

 

K-Safety

TimesTen Scaleout uses the term K-Safety to define the number of copies of an element. K copies of an element corresponds to the number of data space groups. A database with K=2 will have two data spaces. A database with K=1 will have one data space.

 

NxK Database

To simply describe a configuration, the NxK term to describes the number of replica sets (N) and the K Factor (K) for a database.

1x8

The above is an 8x1 grid as there are 8 replica sets and only a single data space (K=1).

8x2

The above is an 8x2 grid as there are 8 replica sets and two data spaces (K=2).

3x2

The above shows two different representations of a 3x2 grid as there are 3 replica sets and two data spaces (K=2). 

 

Installation

TimesTen Scaleout defines an installation as the read only copy of the files in the TimesTen software distribution.

 

 

Disclaimer: These are my personal thoughts and do not represent Oracle's official viewpoint in any way, shape, or form.

Be the first to comment

Comments ( 0 )
Please enter your name.Please provide a valid email address.Please enter a comment.CAPTCHA challenge response provided was incorrect. Please try again.Captcha