Top
Enterprise Postgres 17 Cluster Operation Guide(Database Multiplexing)

A.4.2 Arbitration Configuration File

In arbitration.conf, define the information related to arbitration and control of the Mirroring Controller arbitration process.

Linux

Table A.6 arbitration.conf file (Linux)

Parameter

Value set

Description

port

Port number of the Mirroring Controller arbitration process

The specified value must not exceed the range 0 to 65535. Ensure that the port number does not conflict with other software. Do not specify an ephemeral port that may temporarily be assigned by another program.

For the port number of the arbitration server to be specified in network.conf on the database server, specify the same value as the port number specified in this parameter.

my_address

'ipAddrOrHostNameThatAcceptsConnectionFromMirroringControllerProcessOnDbServer'

[Setting example]

my_address = '192.0.3.120'

For the IP address or host name of the arbitration server to be specified in network.conf on the database server, specify the same value as the IP address or host name specified in this parameter.

IPv4 and IPv6 addresses can be specified.

Specify the IP address or host name, enclosed in single quotation marks (').

core_file_path

'coreFileOutputDir'

Specify the directory to which the core file is to be output, enclosed in single quotation marks ('). Use ASCII characters to specify this parameter.

If this parameter is omitted, it will be assumed that the Mirroring Controller arbitration process management directory was specified.

syslog_facility

Specify LOCAL0, LOCAL1, LOCAL2, LOCAL3, LOCAL4, LOCAL5, LOCAL6, or LOCAL7.

When the import of logs to the syslog is enabled, the value of this parameter will be used for "facility" of the syslog.

The default is "LOCAL0".

syslog_ident

'programName'

Specify using single quotation marks (') to enclose the program name used to identify the Mirroring Controller arbitration process message in the system log. Use ASCII characters excluding spaces to specify this parameter.

The default is 'MirroringControllerArbiter'.

fencing_command

'fencingCmdFilePath'

[Setting example]

fencing_command = '/arbiter/fencing_dir/execute_fencing.sh'

Specify the full path of the fencing command that fences a database server where an error is determined to have occurred.

Enclose the path in single quotation marks (').

Specify the path using less than 1024 bytes.

fencing_command_timeout

Fencing command timeout (seconds)

If the command does not respond within the specified number of seconds, fencing is determined to have failed and a signal (SIGTERM) is sent to the fencing command execution process.

Specify a value between 1 and 2147483647.

The default is 20 seconds.

heartbeat_interval(*1)

Interval time for heartbeat monitoring of the operating system or server (milliseconds)

The heartbeat monitoring of the database server is checked at the specified interval and arbitration is performed.

Specify a value between 1 and 2147483647.

The default is the value specified in serverIdentifier.conf of the database server.

Specify this parameter to perform optimization taking into account differences in the line load to the admin network and the reduction in the time it takes to degrade.

heartbeat_timeout

Timeout for heartbeat monitoring of the operating system or server (seconds)

If there is no response for at least the number of seconds specified, it will be assumed that an error has occurred that requires the primary server or standby server to be fenced.

Specify a value between 1 and 2147483647.

The default is the value specified in serverIdentifier.conf of the database server.

Specify this parameter to perform optimization taking into account differences in the line load to the admin network and the reduction in the time it takes to degrade.

heartbeat_retry

Number of retries for heartbeat monitoring of the operating system or server (number of times)

Specify the number of retries to be performed when an error has been detected that requires the primary server or standby server to be fenced.

If an error is detected in succession more than the specified number of times, fencing will be performed.

Specify a value between 0 and 2147483647.

The default is the value specified in serverIdentifier.conf of the database server.

Specify this parameter to perform optimization taking into account differences in the line load to the admin network and the reduction in the time it takes to degrade.

*1:Refer to "2.11.4 Tuning for Optimization of Degradation Using Abnormality Monitoring" for information on the tuning parameters for operating system or server abnormality monitoring when using an arbitration server.

Windows

Table A.7 arbitration.conf file (Windows)

Parameter

Value set

Description

port

Port number of the Mirroring Controller arbitration process

The specified value must not exceed the range 0 to 65535. Ensure that the port number does not conflict with other software. Do not specify an ephemeral port that may temporarily be assigned by another program.

For the port number of the arbitration server to be specified in network.conf on the database server, specify the same value as the port number specified in this parameter.

my_address

'ipAddrOrHostNameThatAcceptsConnectionFromMirroringControllerProcessOnDbServer'

[Setting example]

my_address = '192.0.3.120'

For the IP address or host name of the arbitration server to be specified in network.conf on the database server, specify the same value as the IP address or host name specified in this parameter.

IPv4 and IPv6 addresses can be specified.

Specify the IP address or host name, enclosed in single quotation marks (').

core_file_path

'coreFileOutputDir'

Specify the directory to which the core file is to be output, enclosed in single quotation marks ('). Use ASCII characters.

Specify \\ as file separator.

If this parameter is omitted, it will be assumed that the Mirroring Controller arbitration process management directory was specified.

service_name

'registeredServiceNameOfMirroringControllerArbitrationProcess'

Specify the Mirroring Controller arbitration process service name to be registered as a Windows service, enclosed in single quotation marks ('). Use ASCII characters excluding forward slash (/) and backslash (\) to specify this parameter.

The service name is up to 124 bytes.

The default is 'MirroringControllerArbiter'.

event_source

'eventSourceName'

Specify the event source name to be used to identify the Mirroring Controller arbitration process message in the event log, enclosed in single quotation marks ('). Use ASCII characters to specify this parameter.

The maximum length of the event source name is 255 bytes.

The default is 'MirroringControllerArbiter'.

fencing_command

'fencingCmdFilePath'

[Setting example]

fencing_command = 'c:\\arbiter\\fencing_dir\\execute_fencing.bat'

Specify the full path of the fencing command that fences a database server where an error is determined to have occurred.

Specify \\ as file separator.

Enclose the path in single quotation marks (').

Specify the path using less than 260 bytes.

Any multibyte characters must use the same encoding as the operating system.

fencing_command_timeout

Fencing command timeout (seconds)

If the command does not respond within the specified number of seconds, fencing is determined to have failed and a signal (SIGTERM) is sent to the fencing command execution process.

Specify a value between 1 and 2147483647.

The default is 20 seconds.

heartbeat_interval(*1)

Interval time for heartbeat monitoring of the operating system or server (milliseconds)

The heartbeat monitoring of the database server is checked at the specified interval and arbitration is performed.

Specify a value between 1 and 2147483647.

The default is the value specified in serverIdentifier.conf of the database server.

Specify this parameter to perform optimization taking into account differences in the line load to the admin network and the reduction in the time it takes to degrade.

heartbeat_timeout

Timeout for heartbeat monitoring of the operating system or server (seconds)

If there is no response for at least the number of seconds specified, it will be assumed that an error has occurred that requires the primary server or standby server to be fenced.

Specify a value between 1 and 2147483647.

The default is the value specified in serverIdentifier.conf of the database server.

Specify this parameter to perform optimization taking into account differences in the line load to the admin network and the reduction in the time it takes to degrade.

heartbeat_retry

Number of retries for heartbeat monitoring of the operating system or server (number of times)

Specify the number of retries to be performed when an error has been detected that requires the primary server or standby server to be fenced.

If an error is detected in succession more than the specified number of times, fencing will be performed.

Specify a value between 0 and 2147483647.

The default is the value specified in serverIdentifier.conf of the database server.

Specify this parameter to perform optimization taking into account differences in the line load to the admin network and the reduction in the time it takes to degrade.

*1:Refer to "2.11.4 Tuning for Optimization of Degradation Using Abnormality Monitoring" for information on the tuning parameters for operating system or server abnormality monitoring when using an arbitration server.