Property (Cluster)


Separate from Property, Property (Cluster) organizes the Property only available in Cluster Edition.

Timeout until receiving Handshake message after Accept when connecting to a specific Node.

Failure to receive within the timeout will cause the connection to fail. 

The default value is 5 seconds.

(usec)Value
Minimum0
Maximum2^64 - 1
Default5000000


If this size is insufficient, it will try again until the buffer is empty during transmission.

The size of the request/receive buffer.

Default은 32M.

(byte)Value
Minimum1024768
Maximum2^32 - 1
Default33554432 (32M)

Check interval of the Timeout Thread that checks the Sockets connected to a specific Node.

There is a Timeout Thread that checks RECEIVE_TIMEOUT and SESSION_TIMEOUT. 

The shorter the cycle is, the more frequently it is checked but the Timeout determination is made according to the following values.

The default value is 1 second.

(usec)Value
Minimum0
Maximum2^64 - 1
Default1000000


Timeout to repeat reconnect attempt after connection failure with a specific Node.

If it is not connected within the timeout, it is determined to be completely disconnected.

The default value is 1 minute.

(usec)Value
Minimum0
Maximum2^64 - 1
Default60000000


Time to wait when trying to connect to a specific Node.

If it does not connect within the Timeout, it will try to reconnect until CLUSTER_LINK_CONNECT_RETRY_TIMEOUT has passed.

The default value is 5 seconds.

(usec)Value
Minimum0
Maximum2^64 - 1
Default5000000


You can choose whether to add an errored host name to error messages that occur during communication between the Cluster.

If you want to display a detailed error message, set the property to 1. 

The default value is 0, which means the host name is not displayed.

(boolean)Value
Minimum0
Maximum1
Default0


Timeout until receiving a Handshake message while connected to a specific Node and Cluster Socket.

Two Nodes that have just finished connecting exchange small size Handshake messages to check the connection status. 

The Accept Node sends the Handshake message first, and the time to wait for the response is set here.

The default value is 5 seconds.

(usec)Value
Minimum0
Maximum2^64 - 1
Default5000000

Index


The size of the send / receive buffer.

If this size is insufficient, the transmission will retry until the buffer is empty.

The default value is 32M.

(byte)Value
Minimum1024768
Maximum2^32 - 1
Default33554432 (32M)


Number of times to retry sending until the send buffer is empty.

Every retry will take 1ms off. If you retry beyond this number, you will be disconnected.

The default value is 5000 (msec).

(count)Value
Minimum0
Maximum2^32 - 1
Default5000


Host name of the current Node to connect to a specific Node and Cluster Socket

(string)Value
Defaultlocalhost


If the execution time of Receive Callback to process a message received on Cluster Socket exceeds the set value, it is recognized as Long-Term Callback.

Since the number of receive Threads is limited, Receive Callback should not process messages for a long time. 

If Receive Callback processes the message after this time, it recognizes it as Long-Term Callback and records it in Trace Log.

The default value is 1 second.

(usec)Value
Minimum0
Maximum2^64 - 1
Default1000000


If the time until the arrival of a message received on Cluster Socket exceeds the set value, it is recognized as Long-Wait Message.

If the time from receiving start to receiving end is long, it can be regarded as a problem of the network environment. 

If the received message does not arrive after this time, it is recognized as a Long-Wait Message and recorded in the Trace Log.

The default value is 1 second.

(usec)Value
Minimum0
Maximum2^64 - 1
Default1000000


The maximum number of Socket's Accept Queue when connecting to a specific Node.

(count)Value
Minimum1
Maximum2^32 - 1
Default512


The maximum number of Events that can be retrieved at a time by Poll when communicating with a specific node.

(count)Value
Minimum1
Maximum2^32 - 1
Default4096


The port number of the current Node for connecting the specific Node to the Cluster Socket

(port)Value
Minimum1024
Maximum65535
Default3868


Timeout until the Timeout Thread determines that the connection has been disconnected since the last reception.

Connections that exist in the 'Linked List' should be continuously receiving because the connection between Cluster Nodes is terminated when the reception is complete.

If the last received time is not updated after the set time has elapsed, the Timeout Thread records its contents in the Trace Log and closes the Socket.

(usec)Value
Minimum0
Maximum2^64 - 1
Default30000000


Timeout from when a request message is sent from the Cluster Socket to when a response to the request is received.

For specific messages, specify the time to wait for a response after the request.

If the response message does not arrive at this time, write log to the Trace Log and close the Socket.

The default value is 60 seconds, Timeout is long enough because it is not known what kind of message and receive processing will happen.

(usec)Value
Minimum0
Maximum2^64 - 1
Default60000000


Number of times to retry transmission until the transmit buffer is empty.

Each retry will result in 1 ms of rest.

If you try again beyond this number, disconnect.

The default value is 5000.

(count)Value
Minimum0
Maximum2^32 - 1
Default5000


Timeout to set when sending messages through Cluster Socket.

Set the corresponding timeout when transmitting.

If transmission is not completed until Timeout, it is recorded in the Trace Log.

(usec)Value
Minimum0
Maximum2^64 - 1
Default30000000


Timeout until the Timeout thread determines that the connection has been disconnected since the last receive in a specific session.

Cluster connection manages the session of all messages internally, which is a necessary property in case the session can suddenly not be fixed. 

If the last receive time for the session is not updated after this time, the Timeout Thread writes to the Trace Log and closes the session.

The default value is 1 hour.

(usec)Value
Minimum0
Maximum2^64 - 1
Default3600000000


The number of Threads to process the received messages when communicating with a specific Node.

If the size of the Cluster grows or the number of operations to be processed increases, you can increase the number of receive threads.

(count)Value
Minimum1
Maximum4096
Default8


CLUSTER_QUERY_STAT_LOG_ENABLE

Outputs statistical information about the executed query to the trace log.

(boolean)Value
Minimum0
Maximum1
Default0


CLUSTER_REPLICATION_BLOCK_SIZE

The size of the data to be sent at once when the Replication for adding Node is performed in the Cluster Edition.

The Property must be applied directly to the warehouse (=Transmitting Warehouse) that becomes the Replication Active.

The default value is 640 KB.

(size)Value
Minimum64 * 1024
Maximum100 * 1024 * 1024
Default640 * 1024 (655360)


CLUSTER_WAREHOUSE_DIRECT_DML_ENABLE

It is made possible to connect directly to the Warehouse to perform DML in Cluster Edition.

  • 1: Executable
  • 2: Not executable. An error is returned.

When directly performing the DML in Warehouse, there are performance advantages over Brokers but there is an issue where the DML is not propagated to the same Group. 

Therefore, it is used only for emergency recovery due to data discrepancies, or if the data discrepancies of the Group can be taken into account.

You must apply Properties directly to the specific Warehouse you want.

The default value is 0.

The Coordinator does not check for data discrepancies, even if there is a data difference between the Warehouses in the Group with the corresponding Property turned on.


(boolean)Value
Minimum0
Maximum1
Default0


COORDINATOR_DBS_PATH

Specifies the directory where the Coordinator data file will be created.

The default value is set to ?/dbs, and ? is replaced with the $ MACHBASE_COORDINATOR_HOME environment variable. 

This is an environment variable $MACHBASE_COORDINATOR_HOME/dbs directory.

It must be applied to the Coordinator, and it has no effect on other Nodes.

(path)Value
Default?/dbs


COORDINATOR_DDL_REQUEST_TIMEOUT

Timeout until the Coordinator waits after requesting the Node to execute DDL.

This value refers to the time the Coordinator waits after requesting each Node to perform DDL.

(usec)Value
Minimum0
Maximum2^64 - 1
Default300000000


COORDINATOR_DDL_TIMEOUT

Timeout until the Broker waits after requesting Coordinator to perform DDL.

This value refers to the time that the Broker waits after requesting the Coordinator to perform DDL for the entire Cluster.

(usec)Value
Minimum0
Maximum2^64 - 1
Default3600000000


COORDINATOR_DECISION_DELAY

Timeout until the Coordinator requests the status change and effectively reflects it.

If the status does not actually change over this time, disable the cluster status. 

If the status of the Warehouse Active is not changed but the connected Standby exists, the Fail-Over operation starts.

(usec)Value
Minimum0
Maximum2^64 - 1
Default1000000


COORDINATOR_DECISION_INTERVAL

Time to determine how often the Coordinator changes status.

(usec)Value
Minimum0
Maximum2^64 - 1
Default1000000


COORDINATOR_HOST_RESOURCE_ENABLE

Whether the Coordinator collects Host Resources for Cluster Nodes.

(boolean)Value
Minimum0(false)
Maximum1(true)
Default0(false)

COORDINATOR_HOST_RESOURCE_COLLECT_INTERVAL

Interval at which Cluster Nodes collect Host Resources.

(usec)Value
Minimum0
Maximum2^64 - 1
Default1000000


COORDINATOR_HOST_RESOURCE_INTERVAL

Interval at which the Coordinator exchanges Host Resources with Nodes.

(usec)Value
Minimum0
Maximum2^64 - 1
Default1000000


COORDINATOR_HOST_RESOURCE_REQUEST_TIMEOUT

Time that the Coordinator waits after requesting the Host Resource information from the Nodes.

(usec)Value
Minimum0
Maximum2^64 - 1
Default10000000


COORDINATOR_NODE_REQUEST_TIMEOUT

Timeout until the Coordinator waits after requesting the Node to execute the command.

Because the Add/Remove-node and Add/Remove-Package includes the Node command execution, if it is caught in a short time, the command processing may not be completed.

(usec)Value
Minimum0
Maximum2^64 - 1
Default600000000


COORDINATOR_NODE_TIMEOUT

Time the Coordinator waits before determining that the Node has failed.

(usec)Value
Minimum0
Maximum2^64 - 1
Default30000000


COORDINATOR_STARTUP_DELAY

Grace time until activating the Decision Thread immediately after Coordinator startup.

If it takes a long time to run the entire Cluster, you can start the Node control of Coordinator later by setting a larger value. 

If the Decision Thread runs before the entire drive, there is a high likelihood that the Coordinator will be misplaced.

(usec)Value
Minimum0
Maximum2^64 - 1
Default3000000


COORDINATOR_STATUS_NODE_INTERVAL

Interval in which the Coordinator exchanges status inquiry messages with the Nodes.

(usec)Value
Minimum0
Maximum2^64 - 1
Default1000000


COORDINATOR_STATUS_NODE_REQUEST_TIMEOUT

Time the Coordinator waits after requesting status inquiries from Nodes.

If there is no status inquiry response during that time, the Coordinator proceeds without updating the status of the corresponding Node. 

If the network situation is not good and you need to update the state, you could consider increasing the value. 

Instead, if there is no status query response, the Coordinator will wait for as much as the value was increased.

(usec)Value
Minimum0
Maximum2^64 - 1
Default5000000


COORDINATOR_DISK_FULL_UPPER_BOUND_RATIO

If the disk usage of some servers configured in the cluster exceeds the property value, the group to which the warehouse belongs will enter the DISKFULL state.

Input is restricted for the group in the DISKFULL state, and only inquiry and deletion are possible.

If the property value is 0, the function is disabled.

(percent)Value
Minimum0
Maximum99
Default0


COORDINATOR_DISK_FULL_LOWER_BOUND_RATIO

If the disk usage of the server operating in the DISKFULL state falls below the property value, the group state transitions to the normal.

If the property value is 0, the function is disabled.

(percent)Value
Minimum0
Maximum99
Default0


DEPLOYER_DBS_PATH

Specifies the directory where the Deployer's data files will be created.

The default value is set to?/dbs, and ? is replaced with the $ MACHBASE_DEPLOYER_HOME environment variable. 

This is an environment variable $MACHBASE_DEPLOYER_HOME /dbs directory.

It must be applied to Deployer, and it has no effect on other Nodes.

(path)Value
Default?/dbs


EXECUTION_STAGE_MEMORY_MAX

The maximum amount of Memory used by the Stage Thread performing the SELECT query in Cluster Edition.

Because it is the maximum size of each Stage, the complexity of the SELECT query with an increase in the number of Stages can lead to a larger memory requirement. 

If there is a Stage that exceeds the maximum size, the Stage is canceled and the Query is canceled with an error.

You must apply Properties directly to the specific Warehouse you want.

The default value is 1GB.

(size)Value
Minimum1024
Maximum2^64 - 1
Default1024 *1024 * 1024


HTTP_ADMIN_PORT

Port number to receive requests from MWA or machcoordinatoradmin.

(port)Value
Minimum1024
Maximum65535
Default5779


HTTP_CONNECT_TIMEOUT

Timeout used when connecting to machcoordinatoradmin.

(usec)Value
Minimum0
Maximum2^64 - 1
Default30000000


HTTP_RECEIVE_TIMEOUT

Timeout used when communicating with machcoordinatoradmin.

(usec)Value
Minimum0
Maximum2^64 - 1
Default3600000000


HTTP_SEND_TIMEOUT

Timeout used when communicating with machcoordinatoradmin.

(usec)Value
Minimum0
Maximum2^64 - 1
Default60000000


INSERT_BULK_DATA_MAX_SIZE

Maximum size of input data block when executing Append or INSERT-SELECT.

(size)Value
Minimum1024
Maximum10 * 1024 * 1024
Default1024 * 1024


INSERT_RECORD_COUNT_PER_NODE

Number of data inputs that lead to the warehouse group conversion when performing the input.

(count)Value
Minimum1
Maximum2^64 - 1
Default10000


LOOKUPNODE_COMMAND_RETRY_MAX_COUNT

Number of retry when command and connection to Lookup node fails

(count)Value
Minimum1
Maximum3600
Default30


STAGE_RESULT_BLOCK_SIZE

Maximum block size created in one stage.

(size)Value
Minimum1024
Maximum2^64 - 1
Default1024 * 1024