Skip to content
16.2.2 Cluster Configuration Property Dictionary

16.2.2 Cluster Configuration Property Dictionary

Cluster Edition is configured through each node’s configuration files in $MACHBASE_COORDINATOR_HOME/conf/, $MACHBASE_BROKER_HOME/conf/, and $MACHBASE_WAREHOUSE_HOME/conf/.

This page lists the main cluster properties used during operation.

Coordinator Settings

The Coordinator manages cluster-wide metadata and node status.

PropertyDefaultDescription
CLUSTER_LINK_HOST-IP address to which the Coordinator binds
CLUSTER_LINK_PORT_NO3868Internal cluster communication port
CLUSTER_LINK_THREAD_COUNT16Number of cluster link processing threads
CLUSTER_LINK_MAX_LISTEN512Maximum cluster link listen connections
CLUSTER_LINK_MAX_POLL4096Maximum cluster link poll events
CLUSTER_LINK_BUFFER_SIZE33554432Cluster link buffer size in bytes. Default: 32MB
HTTP_ADMIN_PORT5779Coordinator/Deployer administration REST port
HTTP_THREAD_COUNT2Number of administration REST request threads

HTTP_ADMIN_PORT can also be set with the MACHBASE_HTTP_ADMIN_PORT environment variable. This port is used exclusively for cluster administration requests, rather than SQL queries or data ingestion.

Cluster Link Timeouts

All values are in microseconds (μs).

PropertyDefault (μs)Description
CLUSTER_LINK_ACCEPT_TIMEOUT5000000Accept timeout (5 seconds)
CLUSTER_LINK_CHECK_INTERVAL1000000Connection status check interval (1 second)
CLUSTER_LINK_CONNECT_RETRY_TIMEOUT60000000Maximum connection retry duration (60 seconds)
CLUSTER_LINK_CONNECT_TIMEOUT5000000Connection timeout (5 seconds)
CLUSTER_LINK_HANDSHAKE_TIMEOUT5000000Handshake timeout (5 seconds)
CLUSTER_LINK_RECEIVE_TIMEOUT30000000Receive timeout (30 seconds)
CLUSTER_LINK_SEND_TIMEOUT30000000Send timeout (30 seconds)
CLUSTER_LINK_REQUEST_TIMEOUT60000000Request timeout (60 seconds)
CLUSTER_LINK_SESSION_TIMEOUT3600000000Session timeout (1 hour)
CLUSTER_LINK_LONG_WAIT_INTERVAL1000000Long wait interval (1 second)
CLUSTER_LINK_LONG_TERM_CALLBACK_INTERVAL1000000Long-term callback interval (1 second)

Broker Settings

A Broker accepts client queries and distributes processing across Warehouses. Its machbase.conf contains common server and cluster settings. Supported properties and defaults vary by edition and node role; do not apply a Standard Edition configuration file unchanged.

PropertyDefaultDescription
PORT_NO5656Client connection port
QUERY_PARALLEL_FACTOR4Number of parallel query processing threads (Cluster default)
CLUSTER_LINK_HOST-IP address to which the Broker binds for cluster communication
CLUSTER_LINK_PORT_NO-Broker cluster communication port

Warehouse Settings

A Warehouse stores and processes the actual data. It uses the following cluster settings in addition to storage settings. Properties exclusive to Standard Edition, such as DDL_LOCK_TIMEOUT, are not supported in Cluster Edition.

PropertyDefaultDescription
PORT_NO5656Warehouse service port
CLUSTER_LINK_HOST-IP address to which the Warehouse binds for cluster communication
CLUSTER_LINK_PORT_NO-Warehouse cluster communication port
DBS_PATH?/dbsWarehouse data file directory

Checking Cluster Configuration

Use machcoordinatoradmin --configure to display cluster settings.

machcoordinatoradmin --configure

To check an individual setting, use --configuration=name.

machcoordinatoradmin --configuration=decision

Example Cluster Port Allocation

The following example assigns ports for a cluster on a single host.

NodeService PortHTTP PortCluster Link Port
Coordinator-51025101
Deployer--5201
Broker575753025301
Warehouse-A1540054025401
Warehouse-A2550055025501
Last updated on