Parameters Related to cm_server
log_dir
Parameter description: Specifies the directory where cm_server logs are stored. It can be specified as an absolute path, or a path relative to $GAUSSLOG. When you set an absolute path using cm_ctl, the path must be included in quotation marks (""), for example, cm_ctl set --param --server -k log_dir="'/log/dir'".
Value range: a string of up to 1024 characters. You need to restart cm_server for the modification to take effect. For details, see Options of set cm.
Default value: log, indicating that the cm_server log is generated in the CM directory under the CM data directory.
log_file_size
Parameter description: Specifies the size of a log file. If the size of the cm_server-xx-current.log file exceeds the specified size, a new log file is created to record log information.
Value range: an integer ranging from 0 to 2047. The actual value range that takes effect is from 1 to 2047 (MB). You need to restart cm_server for the modification to take effect. For details, see Options of set cm.
Default value: 16MB
log_min_messages
Parameter description: Specifies which message levels are written to the cm_server log. A higher level covers the messages of all the lower levels. The lower the level is, the fewer messages will be written into the log.
Value range: enumerated type. Valid values are debug5, debug1, warning, error, log, and fatal, which are case-insensitive. You need to restart cm_server for the modification to take effect. For details, see Options of set cm.
Default value: warning
thread_count
Parameter description: Specifies the number of threads in the cm_server thread pool.
Value range: an integer, in the range [2,1000]. You need to restart cm_server for the modification to take effect. For details, see Options of set cm.
Default value: 1000
instance_heartbeat_timeout
Parameter description: Specifies the time to wait before the instance heartbeat times out.
Value range: an integer, in the range [1,2147483647] (unit: second). You need to restart cm_server for the modification to take effect. For details, see Options of set cm.
Default value: 6
instance_failover_delay_timeout
Parameter description: Specifies the delay in cm_server failover after the primary cm_server breakdown is detected.
Value range: an integer, in the range [0,2147483647] (unit: second). You need to restart cm_server for the modification to take effect. For details, see Options of set cm.
Default value: 0
cmserver_ha_connect_timeout
Parameter description: Specifies the time to wait before the connection between the primary and standby cm_servers times out.
Value range: an integer, in the range [0,2147483647] (unit: second). You need to restart cm_server for the modification to take effect. For details, see Options of set cm.
Default value: 2
cmserver_ha_heartbeat_timeout
Parameter description: Specifies the time to wait before the heartbeat between the primary and standby cm_server times out.
Value range: an integer, in the range [1,2147483647] (unit: second). You need to restart cm_server for the modification to take effect. For details, see Options of set cm.
Default value: 6
cmserver_ha_status_interval
Parameter description: Specifies the interval between synchronizations of primary and standby CM Server status.
Value range: an integer, in the range [1,2147483647] (unit: second). You need to restart cm_server for the modification to take effect. For details, see Options of set cm.
Default value: 1
cmserver_self_vote_timeout
Parameter description: Specifies the timeout interval for cm_server to vote for each other. This parameter is a legacy parameter and does not take effect.
Value range: an integer, in the range [0,2147483647] (unit: second). The modification of this parameter takes effect after reloading. For details, see Options of set cm.
Default value: 6
phony_dead_effective_time
Parameter description: Specifies the maximum number of times a database node is detected as a zombie. If the number of times the node is detected as a zombie is greater than the specified value, a process on the node is considered to be a zombie and will be restarted.
Value range: an integer, in the range [1,2147483647]. You need to restart cm_server for the modification to take effect. For details, see Options of set cm.
Default value: 5
cm_server_arbitrate_delay_base_time_out
Parameter description: Specifies the basic duration of cm_server arbitration delay. If the primary cm_server is disconnected, the arbitration starts to be timed. If the disconnection duration exceeds the arbitration delay duration, a new primary cm_server will be selected. The arbitration delay duration is determined by the basic delay duration, the node index (server ID), and the incremental delay duration. The formula is as follows: Arbitration delay duration = Basic delay duration + Node index x Incremental delay duration
Value range: an integer, in the range [0,2147483647] (unit: second). You need to restart cm_server for the modification to take effect. For details, see Options of set cm.
Default value: 10
cm_server_arbitrate_delay_incrememtal_time_out
Parameter description: Specifies the incremental delay duration for cm_server arbitration. If the primary cm_server is disconnected, the arbitration starts to be timed. If the disconnection duration exceeds the arbitration delay duration, a new primary cm_server will be selected. The arbitration delay duration is determined by the basic delay duration, the node index (server ID), and the incremental delay duration. The formula is as follows: Arbitration delay duration = Basic delay duration + Node index x Incremental delay duration
Value range: an integer, in the range [0,2147483647] (unit: second). You need to restart cm_server for the modification to take effect. For details, see Options of set cm.
Default value: 3
alarm_component
Parameter description: Specifies the position of the alarm component that handles alarms if the first mode is used. For details, see Options of set cm. When you set an absolute path using cm_ctl, the path must be included in quotation marks (""), for example, cm_ctl set --param --server -k alarm_component="'/alarm/dir'".
Value range: a string of up to 1024 characters. You need to restart cm_server for the modification to take effect.
Default value: /opt/huawei/snas/bin/snas_cm_cmd
alarm_report_interval
Parameter description: specifies the interval at which an alarm is reported.
Value range: a non-negative integer, in the range [0,2147483647] (unit: second). The modification of this parameter takes effect after reloading. For details, see Options of set cm.
Default value: 3
alarm_report_max_count
Parameter description: Specifies the maximum number of times an alarm is reported.
Value range: a non-negative integer, in the range [1,2592000]. The modification of this parameter takes effect after reloading. For details, see Options of set cm.
Default value: 1
instance_keep_heartbeat_timeout
Parameter description: cm_agent periodically checks the instance status and reports the status to cm_server. If the instance status cannot be detected for a long time and the accumulated number of times exceeds the value of this parameter, cm_server delivers a command to cm_agent to restart the instance.
Value range: an integer, in the range [0,2147483647] (unit: second). The modification of this parameter takes effect after reloading. For details, see Options of set cm.
Default value: 40
az_switchover_threshold
Parameter description: If the failure rate of a node shard in an AZ (Number of faulty node shards/Total number of node shards x 100%) exceeds the specified value, automatic AZ switchover is triggered.
Value range: an integer ranging from 1 to 100. The modification of this parameter takes effect after reloading. For details, see Options of set cm.
Default value: 100
az_check_and_arbitrate_interval
Parameter description: Specifies the interval for checking the AZ status. If the status of an AZ is abnormal, automatic AZ switchover is triggered.
Value range: an integer, in the range [1,2147483647] (unit: second). The modification of this parameter takes effect after reloading. For details, see Options of set cm.
Default value: 2
az_connect_check_interval
Parameter description: Specifies the interval at which the network connection between AZs is checked.
Value range: an integer, in the range [1,2147483647] (unit: second). The modification of this parameter takes effect after reloading. For details, see Options of set cm.
Default value: 60
az_connect_check_delay_time
Parameter description: Specifies the delay between two retries to check the network connection between AZs.
Value range: an integer, in the range [1,2147483647] (unit: second). The modification of this parameter takes effect after reloading. For details, see Options of set cm.
Default value: 150
cmserver_demote_delay_on_etcd_fault
Parameter description: Specifies the interval at which cm_server switches from the primary state to the standby state due to unhealthy etcd.
Value range: an integer, in the range [1,2147483647] (unit: second). The modification of this parameter takes effect after reloading. For details, see Options of set cm.
Default value: 8
instance_phony_dead_restart_interval
Parameter description: Specifies the interval at which cm_agent restarts and kills a zombie database instance. The interval between two consecutive kill operations cannot be less than the value of this parameter. Otherwise, cm_agent does not deliver commands.
Value range: an integer, in the range [1800,2147483647] (unit: second). The modification of this parameter takes effect after reloading. For details, see Options of set cm.
Default value: 21600
enable_transaction_read_only
Parameter description: Specifies whether the database is in read-only mode.
Value range: Boolean values on, off, true, false, yes, no, 1, and 0 The modification of this parameter takes effect after reloading. For details, see Options of set cm.
Default value: on
datastorage_threshold_check_interval
Parameter description: Specifies the interval for checking the disk usage. This interval is specified by the user.
Value range: an integer, in the range [1,2592000] (unit: second). The modification of this parameter takes effect after reloading. For details, see Options of set cm.
Default value: 10
datastorage_threshold_value_check
Parameter description: Specifies the usage threshold of a read-only disk in a database. When the disk usage of the data directory exceeds the specified value, the database is automatically set to read-only.
Value range: an integer, in the range [1,99]. The modification of this parameter takes effect after reloading. For details, see Options of set cm.
Default value: 85
max_datastorage_threshold_check
Parameter description: Specifies the maximum interval for checking the disk usage. After you modify the enable_transaction_read_only parameter, the system automatically checks whether the disk usage reaches the threshold at the specified interval.
Value range: an integer, in the range [1,2592000] (unit: second). The modification of this parameter takes effect after reloading. For details, see Options of set cm.
Default value: 43200
enable_az_auto_switchover
Parameter description: Specifies whether to enable automatic AZ switchover. If it is set to 1, cm_server automatically switches over services among AZs. Otherwise, when a node is faulty, services will not be automatically switched to another AZ even if the current AZ is unavailable. You can run the switchover command to manually switch services to another AZ.
Value range: a non-negative integer. The value 0 indicates that automatic AZ switchover is disabled, and the value 1 indicates that automatic AZ switchover is enabled. The modification of this parameter takes effect after reloading. For details, see Options of set cm.
Default value: 1
cm_krb_server_keyfile
Parameter description: Specifies the location of the key file on the Kerberos server. The value must be an absolute path. The file is usually stored in the ${GAUSSHOME}/kerberos directory and the file name extension is keytab. The file name is the same as the name of the user who runs the cluster. This parameter is used together with cm_auth_method. If the value of the cm_auth_method parameter is changed to gss, cm_krb_server_keyfile must also be set to the corresponding path correctly. Otherwise, the cluster status will be affected. When you set an absolute path using cm_ctl, the path must be included in quotation marks (""), for example, cm_ctl set --param --server -k cm_krb_server_keyfile="'/krb/dir'".
Value range: a string. Any modification of this parameter takes effect only after cm_server is restarted. For details, see Options of set cm.
Default value: ${GAUSSHOME}/kerberos/{Username}.keytab. The default value does not take effect and is used only for reference.
switch_rto
Parameter description: Specifies the delay for the forcible startup of cm_server. When force_promote is set to 1 and a shard in the cluster does not have primary CM Server, the system starts timing. After the delay, the forcible startup logic starts to be executed.
Value range: an integer, in the range [60,2147483647] (unit: second). You need to restart cm_server for the modification to take effect. For details, see Options of set cm.
Default value: 600
force_promote
Parameter description: Specifies whether cm_server enables the forcible startup logic (that is, when the cluster status is unknown, ensure that the basic functions of the cluster are available at the cost of data loss). The value 0indicates that the function is disabled, and the value 1 indicates that the function is enabled.
Value range: an integer, 0 or 1. You need to restart cm_server for the modification to take effect. For details, see Options of set cm.
Default value: 0
backup_open
Parameter description: Specifies whether to enable the DR cluster. After the DR cluster is enabled, the CM runs in DR cluster mode.
Value range: an integer, 0 or 1. You need to restart cm_server for the modification to take effect. This parameter cannot be enabled for non-DR clusters. For details, see Options of set cm.
- 0: The DR cluster is disabled.
- 1: The DR cluster is enabled.
Default value: 0
enable_dcf
Parameter description: Specifies the status of the DCF mode.
Value range: Boolean You need to restart cm_server for the modification to take effect. For details, see Options of set cm.
- on, yes, true, or 1: The DCF function is enabled.
- off, no, false, or 0: The DCF function is disabled.
Default value: off
ddb_type
Parameter description: Specifies whether to switch between ETCD and DCC modes.
Value range: an integer. 0: specifies the ETCD mode; 1: specifies the DCC mode. You need to restart cm_server for the modification to take effect. For details, see Options of set cm.
Default value: 1
NOTE:
The openGauss supports only the DCC mode.
enable_ssl
Parameter description: Specifies whether to enable SSL.
Value range: Boolean After this function is enabled, the SSL certificate is used to encrypt communication. You need to restart cm_server for the modification to take effect. For details, see Options of set cm.
Default value:
on, yes, true, or 1: SSL is enabled.
off, no, false, or 0: SSL is disabled.
Default value: on
NOTICE:
To ensure security, you are advised not to disable it. After this function is disabled, the CM does not use encrypted communication and all information is transmitted in plaintext, which may bring security risks such as eavesdropping, tampering, and spoofing.
ssl_cert_expire_alert_threshold
Parameter description: Specifies the SSL certificate expiration alarm time.
Value range: an integer, in the range [7,180] (unit: day). If the certificate expiration time is less than the value of this parameter, an alarm indicating that the certificate is about to expire is reported. The modification of this parameter takes effect after reloading. For details, see Options of set cm.
Default value: 90
ssl_cert_expire_check_interval
Parameter description: Specifies the period for checking whether the SSL certificate expires.
Value range: an integer, in the range [0,2147483647] (unit: second). The modification of this parameter takes effect after reloading. For details, see Options of set cm.
Default value: 86400
ddb_log_level
Parameter description: Sets the DDB log level.
To disable the log function, set this parameter to NONE, which cannot be used together with the following log levels:
To enable the log function, set this parameter to one or a combination of the following log levels: RUN_ERR|RUN_WAR|RUN_INF|DEBUG_ERR|DEBUG_WAR|DEBUG_INF|TRACE|PROFILE|OPER. If two or more log levels are used together, separate them with vertical bars (|). The log level cannot be set to an empty string.
Value range: a string containing one or a combination of the following log levels: RUN_ERR|RUN_WAR|RUN_INF|DEBUG_ERR|DEBUG_WAR|DEBUG_INF|TRACE|PROFILE|OPER. The modification of this parameter takes effect after reloading. For details, see Options of set cm.
Default value: RUN_ERR|RUN_WAR|DEBUG_ERR|OPER|RUN_INF|PROFILE
ddb_log_backup_file_count
Parameter description: Specifies the maximum number of log files that can be saved.
Value range: an integer ranging from 1 to 100. The modification of this parameter takes effect after reloading. For details, see Options of set cm.
Default value: 10
ddb_max_log_file_size
Parameter description: Specifies the maximum number of bytes in a log.
Value range: a string with up to 1024 characters, in the range [1M,1000M]. The modification of this parameter takes effect after reloading. For details, see Options of set cm.
Default value: 10M
ddb_log_suppress_enable
Parameter description: Specifies whether to enable the log suppression function.
Value range: an integer. 0: disabled; 1: enabled. The modification of this parameter takes effect after reloading. For details, see Options of set cm.
Default value: 1
ddb_election_timeout
Parameter description: Specifies the DCC election timeout period.
Value range: an integer, in the range [1,600], in seconds. The modification of this parameter takes effect after reloading. For details, see Options of set cm.
Default value: 3
coordinator_heartbeat_timeout
Parameter description: Specifies the heartbeat timeout that triggers the automatical removal of faulty nodes. The setting of this parameter takes effect immediately, and you do not need to restart CM Server. If this parameter is set to 0, faulty nodes are not automatically removed.
Value range: an integer. The unit is second.You need to restart cm_server for the modification to take effect. For details, see Options of set cm.
Default value: 25
cluster_starting_aribt_delay
Parameter description: Specifies the time that CM Server waits for a static primary-to-primary switchover during cluster startup.
Value range: an integer, in the range [1,2592000] (unit: second).You need to restart cm_server for the modification to take effect. For details, see Options of set cm.
Default value: 180
enable_e2e_rto
Parameter description: Specifies whether to enable the E2E RTO function. After this function is enabled, the hang-up detection period and network detection timeout time are shortened. The CM can reach the E2E RTO indicator (RTO for a single instance ≤ 10s; RTO for combined faults ≤ 30s).
Value range: an integer, 0 or 1. The value **1 **indicates enabled, while the value 0 indicates disabled.You need to restart cm_server for the modification to take effect. For details, see Options of set cm.
Default value: 0
disk_timeout
Parameter description: Specifies the time to wait before the disk heartbeat times out.
Value range: an integer, in the range [0,2147483647] (unit: second).You need to restart cm_server for the modification to take effect. For details, see Options of set cm.
Default value: 200
agent_network_timeout
Parameter description: Specifies the network timeout interval between nodes.
Value range: an integer, in the range [0,2147483647] (unit: second).You need to restart cm_server for the modification to take effect. For details, see Options of set cm.
Default value: 6
voting_disk_path
Parameter description: Specifies the voting disk path.
Value range: a string of up to 1024 characters. You need to restart cm_server for the modification to take effect.
No default value. Set this parameter during installation.
share_disk_path
Parameter description: Specifies the shared disk path.
Value range: a string of up to 1024 characters. You need to restart cm_server for the modification to take effect.
No default value. Set this parameter during installation.
dn_arbitrate_mode
Parameter description: Specifies the DN arbitration mode.
Value range: a string. The modification of this parameter takes effect after reloading. For details about how to modify parameters, see Parameters for set cm. In share_disk mode, you are not advised to change the arbitration mode.
- quorum
- paxos
- share_disk
Default value: quorum
delay_arbitrate_max_cluster_timeout
Parameter description: Specifies the time to wait for selecting the largest cluster during startup.
Value range: an integer, in the range [0,1000] (unit: second). 0: No arbitration is performed. The modification of this parameter takes effect after reloading. For details, see Options of set cm.
Default value: 300
delay_arbitrate_timeout
Parameter description: Specifies the time for waiting for the redo log replay of a node in the same AZ as the primary DN. The node in the same AZ as the primary DN is preferentially promoted to primary.
Value range: an integer, in the range [0,2147483647] (unit: second). For details, see Options of set cm.
Default value: 0
cm_auth_method
Parameter description: Specifies the port authentication mode of the CM. trust indicates that port authentication is not configured. gss indicates that Kerberos port authentication is used. Note that you can change the value to gss only after the Kerberos server and client are successfully installed. Otherwise, the CM cannot communicate properly, affecting the database status.
Value range: gss or trust. You need to restart cm_server for the modification to take effect. For details, see Options of set cm.
Default value: trust