Skip to main content
These steps assume that you have already completed the process for bootstrapping your System nodes. If you have not done this yet, perform the Ocient System Bootstrapping steps before beginning this configuration process. Now that the nodes have all completed bootstrapping, you must properly configure the nodes to perform their roles. You should run these commands using a SQL connection to one of the SQL Nodes in your system. For details, see Connect to Ocient. The Ocient application configuration process consists of these steps:
  1. Creating a Storage Space
  2. Creating Storage Clusters
  3. Assigning Service Roles
  4. Restart the Nodes
1

Creating a Storage Space

To create a storage space with 12 segments, use WIDTH=12 and PARITY_WIDTH=2. Two of these segments are the parity portion, and 10 of these segments are the data portion.
SQL
CREATE STORAGESPACE teststoragespace WIDTH = 12, PARITY_WIDTH = 2;
The storage space name must begin with a letter followed by letters, numbers, and underscores.
You can view all storage spaces in the system by querying the sys.storage_spaces system catalog table.
SQL
SELECT * FROM sys.storage_spaces;
For details about creating a storage space to suit your system needs, see Configure Storage Spaces.
2

Creating Storage Clusters

You must have at least one storage cluster to configure an Ocient System. A storage cluster is a set of Foundation Nodes with an associated storage space that coordinate to reliably store data and serve queries.Create a Foundation cluster.
SQL
CREATE CLUSTER lts_cluster
TYPE LTS storagespace "teststoragespace"
PARTICIPANTS=('lts0','lts1','lts2','lts3','lts4','lts5','lts6','lts7','lts8','lts9','lts10','lts11');
Loader Nodes and SQL Nodes do not need to be placed into a cluster.
At a minimum, the number of participants must be the width specified in the storage space. This number can be greater if you overprovision the system. For details about storage spaces and related settings, overprovisioning, and parity, see Core Elements of an Ocient System.
View all clusters in the system.
SQL
SELECT * FROM sys.clusters;
View all clusters and their associated nodes.
SQL
SELECT c.name AS cluster_name, c.cluster_type, n.name AS node_name
FROM sys.node_clusters nc
JOIN sys.clusters c ON nc.cluster_id = c.id
JOIN sys.nodes n ON nc.node_id = n.id;
You must restart all nodes with the SQL role after adding a storage cluster.
3

Assigning Service Roles

Assign service roles to each accepted node. This process defines how each node participates in queries and the management of the system.View all nodes and their configured roles.
SQL
SELECT n.name AS node_name, sr.service_role_type
FROM sys.nodes n
LEFT JOIN sys.service_roles sr ON sr.node_id = n.id;
The addition of nodes to the storage cluster in the prior step automatically assigns lts to the Foundation Nodes that you included.Add the remaining sql, admin, and streamloader roles to the appropriate nodes.
SQL
ALTER NODE "sql1" ADD ROLE sql;
ALTER NODE "sql1" ADD ROLE admin;
ALTER NODE "loader1" ADD ROLE streamloader;
The Admin role can operate standalone or on the same node as the SQL role.
4

Restart the Nodes

With roles assigned to the nodes, you can restart the rolehostd process on all nodes. At a shell terminal on each node, run this command.
Shell
sudo systemctl restart rolehostd
If any custom configuration settings are applied to running nodes during other configurations, be sure to restart the rolehostd process before proceeding.
You can check the status of nodes using the Status endpoint on each node from a terminal. Assuming IP Addresses 10.10.0.2 and 10.10.0.3 for sql1 and lts0, respectively, you can check the status with these curl commands.
CURL
curl http://10.10.0.2:9090/v1/status
curl http://10.10.0.3:9090/v1/status
After all of the nodes are Active, Ocient is ready to use for queries.

​
Creating an Ocient System with Multiple Storage Clusters

If you need an Ocient System that requires 10 or more Foundation Nodes in the storage cluster, then you can create multiple storage clusters. For considerations to take into account when you work with multiple storage clusters, see Multiple Storage Clusters for Loading Data. Create a multiple storage cluster with 12 nodes. Create a storage space store with width 5 and parity width 1 using the CREATE STORAGESPACE SQL statement.
SQL
CREATE STORAGESPACE store WIDTH = 5, PARITY_WIDTH = 1;
Create multiple clusters using the CREATE CLUSTER SQL statements using the storage space store. Split the Foundation Nodes among the clusters. cluster_0 storage cluster has Foundation Nodes lts0 through lts5, while cluster_1 has lts6 through lts11.
SQL
CREATE CLUSTER cluster_0 TYPE=lts PARTICIPANTS=("lts0", "lts1", "lts2", "lts3", "lts4", "lts5") STORAGESPACE=store;

CREATE CLUSTER cluster_1 TYPE=lts PARTICIPANTS=("lts6", "lts7", "lts8", "lts9", "lts10", "lts11") STORAGESPACE=store;

​
Validating the System After Configuration

After configuration, you can run a system check to validate the Ocient installation and bootstrapping. For details, see Checking System After Configuration.

​
Next Step

Follow the process in Ingest Data with Legacy LAT Reference to create a database and a table, then load data from a set of files located on a cloud object storage. Installation Reference Install an Ocient System
Last modified on May 27, 2026