Distributed Configuration

OmniSci Distributed Cluster Components

A OmniSci distributed database consists of three components:

• An aggregator, which is a specialized OmniSciDB instance for managing the cluster
• One or more leaf nodes, each being a complete OmniSciDB instance for storing and querying data
• A String Dictionary Server, which is a centralized repository for all dictionary-encoded items

Conceptually, a OmniSci distributed database is horizontally sharded across n leaf nodes. Each leaf node holds one nth of the total dataset. Sharding currently is round-robin only. Queries and responses are orchestrated by a OmniSci Aggregator server.

The OmniSci Aggregator

Clients interact with the aggregator. The aggregator orchestrates execution of a query across the appropriate leaf nodes. The aggregator composes the steps of the query execution plan to send to each leaf node, and manages their results. The full query execution might require multiple iterations between the aggregator and leaf nodes before returning a result to the client.

A core feature of the OmniSciDB is back-end, GPU-based rendering for data-rich charts such as point maps. When running as a distributed cluster, the backend rendering is distributed across all leaf nodes, and the aggregator composes the final image.

String Dictionary Server

The String Dictionary Server manages and allocates IDs for dictionary-encoded fields, ensuring that these IDs are consistent across the entire cluster.

The server creates a new ID for each new encoded value. For queries returning results from encoded fields, the IDs are automatically converted to the original values by the aggregator. Leaf nodes use the string dictionary for processing joins on encoded columns.

For moderately sized configurations, the String Dictionary Server can share a host with a leaf node. For larger clusters, this service can be configured to run on a small, separate CPU-only server.

Replicated Tables

A table is split by default to 1/nth of the complete dataset. When you create a table used to provide dimension information, you can improve performance by replicating its contents onto every leaf node using the partitions property. For example:

CREATE TABLE flights … WITH (PARTITIONS=’REPLICATED’)

This reduces the distribution overhead during query execution in cases where sharding is not possible or appropriate. This is most useful for relatively small, heavily used dimension tables.

Data Loading

You can load data to a OmniSci distributed cluster using a COPY FROM statement to load data to the aggregator, exactly as with OmniSci single-node processing. The aggregator distributes data evenly across the leaf nodes.

Data Compression

Records transferred between systems in an OmniSci cluster are compressed to improve performance. OmniSci uses the LZ4_HC compressor by default. It is the fastest compressor, but has the lowest compression rate of the available algorithms. The time required to compress each buffer is directly proportional to the final compressed size of the data. A better compression rate will likely require more time to process.

You can specify another compressor on server startup using the runtime flag compressor. Compressor choices include:

• blosclz
• lz4
• lz4hc
• snappy
• zlib
• zstd

For more information on the compressors used with OmniSci, see also:

• http://blosc.org/pages/synthetic-benchmarks/
• https://quixdb.github.io/squash-benchmark/
• https://lz4.github.io/lz4/

OmniSci does not compress the payload until it reaches a certain size. The default size limit is 512MB. You can change the size using the runtime flag compression-limit-bytes.

[
  {
    "host": "node1",
    "port": 16274,
    "role": "dbleaf"
  },
  {
    "host": "node2",
    "port": 16274,
    "role": "dbleaf"
  },
 {
    "host": "node3",
    "port": 16274,
    "role": "dbleaf"
  },
  {
    "host": "node4",
    "port": 16274,
    "role": "dbleaf"
  },

  {
    "host": "node2",
    "port": 10301,
    "role": "string"
  }
]

In the cluster.conf file, the location of each leaf node is identified as well as the location of the String Dictionary server.

Here, dbleaf is a leaf node, and string is the String Dictionary Server. The port each node is listening on is also identified. These ports must match the ports configured on the individual server.

Each leaf node requires a omnisci.conf configuration file.

port = 16274
http-port = 16278
calcite-port = 16279
data = "<location>/omnisci-storage/nodeLocal/data"
read-only = false
string-servers = "<location>/omnisci-storage/cluster.conf"