/var/opt/ocient/bootstrap.conf file controls the initial configuration of each node. The system uses this file only when the node initially starts.
Validate the System Before Bootstrapping
The following steps assume a basic configuration, where every node has a single network interface.To verify your system before the bootstrapping process:
- Check with your systems administrator to ensure that you meet the Operating System Configuration requirements. Before bootstrapping, your system must meet the requirements described in the Apply Required Kernel Settings and Prepare NVMe Drives sections.
- You can run a system check to validate the compliance of hardware, nodes, and the configuration for the Ocient System. For details, see Checking System Configuration Before Bootstrapping.
Initial Configuration
The system automatically initializes the first node bootstrapped in the system with the SQL and Administrator roles. Choose a node to serve as a SQL Node. This node is the initial node in the system. The hardware for each node type differs, so ensure that the node you select is intended for a SQL Node. For new clusters, if you do not define the configuration for the SQL Nodes in a connectivity pool, the Ocient System assigns each SQL Node to their own unique connectivity pool named<sql_node_name>_default, where <sql_node_name> is the name of the SQL Node. However, the most common configuration of an Ocient System has all SQL Nodes in one connectivity pool.
For an example of adding SQL Nodes to a connectivity pool, see CREATE CONNECTIVITY POOL. Change or troubleshoot the default configuration using the instructions in Manage the Network Configuration of an Ocient System.
Ocient System Bootstrapping Process
If you meet the system prerequisites, you can begin bootstrapping your Ocient System. The bootstrapping process consists of these steps:Bootstrap the First Node
Bootstrap the Node
Connect to the initial SQL Node with the username and password of your server and the IP address of your node. This example connects as the administratoradmin to the IP Address 10.10.10.10.Shell
sudo to create the /var/opt/ocient/bootstrap.conf file as root with these contents./var/opt/ocient/bootstrap.conf exampleYAML
Shell
Shell
rolehostd service is running, you can also check the Ocient logs on your node. Search and ensure there are no [ERROR] log messages.Shell
Verify Connection to the SQL Node
At this point, you have a running database with a single node. You should be able to connect to the database using Connect Using JDBC or Connect Using pyocient and execute commands.Every new system starts with asystem database. To connect to a new system, use the username and password configured in the bootstrap.conf file or the username admin@system and password admin if none was provided.For example, assume your node named sql0 has an IP address of 10.10.0.1. Use the JDBC driver CLI to connect with this connection string.Shell
See the JDBC Manual for details on using the JDBC driver.
SQL
sql, admin, health, and operatorvm roles. If all of these roles are present and the node is Active, you can proceed to the next step to bootstrap the remaining nodes.Bootstrap the Remaining Nodes
Performing the bootstrapping process on the remaining nodes is identical on all nodes. The remaining nodes can be bootstrapped in any order.On each node, log in using SSH and use your text editor with On each node, start the database.At this point, all the remaining nodes are not configured with any roles. After all nodes have been started, you should see them when you execute this query with only the
sudo to create the file /var/opt/ocient/bootstrap.conf that contains this text by replacing <FIRST_NODE_IP_ADDRESS> with the IP address of the initial node you created in Step 1./var/opt/ocient/bootstrap.conf exampleYAML
<FIRST_NODE_IP_ADDRESS> is the DNS name or IP address of the initial node.You can obtain the IP Address of the initial node by executing
ifconfig on that node.If the password for the system administrator has changed, set the correct username
adminUserName and password adminPassword in the bootstrap configuration file bootstrap.conf.Shell
health role listed. This query uses the sys.node_status, sys.nodes, and sys.service_roles system catalog tables to retrieve node information for the node name, operation status, version, and all service role types. The query uses the ARRAY_AGG function to retrieve the service role type for all rows.SQL

