Symfoware Server V12.1.0 Cluster Operation Guide

6.4.2 Creating, Setting, and Registering the Standby Server Instance

This section explains how to create, set, and register the standby server instance.

See

• Refer to "Appendix B Parameters" for details on each parameter.

• Refer to "mc_ctl" in Reference for information on the command.

Perform the following procedure:

1. Set the kernel parameters.

   Refer to "Configuring Kernel Parameters" in the Installation and Setup Guide for Server for details.

2. Configure the encryption settings for the storage data.

   Deploy a copy of the keystore file of the primary server on the standby server.

   Refer to "Database Multiplexing Mode" in the Operation Guide for details.

3. Execute the mc_ctl command in setup mode to create a copy of the primary server instance on the standby server.

   Example)

   $ mc_ctl setup -M /mcdir/inst1 -r standby -U userName -h primaryServerHostName -p primaryServerPortNumber --standby-name=standbyServerName

4. Set the parameters shown in the table below in the postgresql.conf file.

   Table 6.3 Parameters

   Parameter	Content specified	Remarks
   synchronous_standby_names	'primaryServerName'	Required after switching the primary server and then changing the original primary server to the new standby server. Enclose the name within single quotation marks ('). Do not change this parameter while Mirroring Controller is running.

5. Start the Mirroring Controller process.

   After ensuring that the Mirroring Controller process of the primary server has started, start the Mirroring Controller process.

   When the Mirroring Controller option is used

   As the instance administrator user, execute the mc_ctl command in start mode with the -f option specified. This action enables automatic switch or disconnection.

   If you start Mirroring Controller and the instance without specifying the -f option, automatic switch and disconnection will not be enabled. To enable both, start Mirroring Controller and then execute the mc_ctl command in enable-failover mode or restart Mirroring Controller with the -f option specified.

   Example)

   $ mc_ctl start -M /mcdir/inst1 -f

   When the Mirroring Controller option is not used

   As the instance administrator user, execute the mc_ctl command in start mode.

   Example)

   $ mc_ctl start -M /mcdir/inst1

6. Check the status of the Mirroring Controller process.

   As the instance administrator user, execute the mc_ctl command in status mode. Ensure that "mirroring status" is switchable.

   Example)

   $ mc_ctl status -M /mcdir/inst1