Define the information related to Mirroring Controller monitoring and control in the serverIdentifier.conf file. The maximum length of the server identifier is 64 bytes. Use ASCII characters excluding spaces to specify this parameter.
If the primary server and standby server environments are different, define content that is different, according to the environment.
Table B.4 serverIdentifier.conf fileParameter | Value set | Explanation |
|---|
db_instance | 'dataStorageDestinationDir' [Example] db_instance = '/database1/inst1' | Specify using single quotation marks (') to enclose the data storage destination directory used to identify the monitoring target instance. Use ASCII characters excluding spaces to specify this parameter. |
db_instance_password | 'Password of the instance administrator user' | Specify the password used when Mirroring Controller connects to a database instance. Use ASCII characters excluding spaces to specify this parameter. If password authentication is performed, you must specify this parameter in the settings used when Mirroring Controller connects to a database instance. If you specify this parameter when password authentication is not performed, the parameter will be ignored. Enclose the name within single quotation marks ('). |
remote_call_timeout | Admin communication timeout | Specify the timeout value (milliseconds) of the Mirroring Controller agent process for communication between servers. Specify a value between 0 and 2147483647. The value 0 indicates that there is no timeout limit. The default is 70000 milliseconds (70 seconds). |
core_file_path | Core file output directory | Specify the directory to which the core file is to be output. Use ASCII characters excluding spaces to specify this parameter. If this parameter is omitted, it will be assumed that the Mirroring Controller 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 (*1) | 'programName' | Specify using single quotation marks (') to enclose the program name used to identify the Mirroring Controller message in the system log. Use ASCII characters excluding spaces to specify this parameter. The default is 'MirroringControllerOpen'. |
heartbeat_interval | Interval time for operating system/server and process heartbeat monitoring, and disk abnormality monitoring (milliseconds) | Servers will contact each other and perform abnormality monitoring at the specified interval. Specify a value between 1 and 2147483647. The default is 800 milliseconds. |
heartbeat_timeout | Timeout for operating system/server and process heartbeat monitoring, and disk abnormality monitoring (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 to be switched, or the standby server to be disconnected. Specify a value between 1 and 2147483647. The default is 1 second. |
heartbeat_retry | Number of retries for operating system/server and process heartbeat monitoring, and disk abnormality monitoring (number of times) | Specify the number of retries when an error has been detected that requires the primary server to be switched, or the standby server to be disconnected. If an error is detected in succession for at least the number of times specified, the switch or the disconnection will be performed. Specify a value between 0 and 2147483647. The default is 2 times. |
*1: By specifying the syslog_ident parameter of the postgresql.conf file, the Mirroring Controller output content can be referenced transparently, so log reference is easy.
