---
title: Ocient Application Configuration
slug: l628lzIbpkPhCRMRVeUn_
description: Configure the Ocient application for optimized performance, with settings tailored to your specific data and operational needs.
docTags: 
createdAt: Thu Jul 21 2022 17:05:13 GMT+0000 (Coordinated Universal Time)
updatedAt: Mon Mar 30 2026 18:52:26 GMT+0000 (Coordinated Universal Time)
---

These steps assume that you have already completed the process for bootstrapping your Ocient® System nodes. If you have not done this yet, perform the [Ocient System Bootstrapping](<./Ocient System Bootstrapping.md>) steps before beginning this configuration process.&#x20;

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](<./././Connect to Ocient.md>). &#x20;

The Ocient application configuration process consists of these steps:&#x20;

1. [Creating a Storage Space]()
2. [Creating Storage Clusters]()
3. [Assigning Service Roles]()
4. [Restart the Nodes]()

:::::WorkflowBlock
::::WorkflowBlockItem
## 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;
```

:::hint{type="info"}
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.&#x20;

```sql
SELECT * FROM sys.storage_spaces;
```

For details about creating a storage space to suit your system needs, see [Configure Storage Spaces](<././Configure Storage Spaces.md>).&#x20;
::::

::::WorkflowBlockItem
## 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');
```

:::hint{type="info"}
Loader Nodes and SQL Nodes do not need to be placed into a cluster.
:::

:::hint{type="info"}
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](<./././Ocient Architecture/Core Elements of an Ocient System.md>).
:::

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;
```

:::hint{type="warning"}
You must restart all nodes with the SQL role after adding a storage cluster.
:::
::::

::::WorkflowBlockItem
## 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;
```

:::hint{type="info"}
The `Admin` role can operate standalone or on the same node as the `SQL` role.
:::
::::

::::WorkflowBlockItem
## 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
```

:::hint{type="info"}
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](<././Multiple Storage Clusters for Loading Data.md>).

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](<./Installation Reference/Checking System After Configuration.md>).

## Next Step

Follow the process in [Ingest Data with Legacy LAT Reference](<./././LAT Reference/Ingest Data with Legacy LAT Reference.md>) to create a database and a table, then load data from a set of files located on a cloud object storage.&#x20;

## Related Links

[Installation Reference](<./Installation Reference.md>)

[Install an Ocient System](<././Install an Ocient System.md>)

