This section explains how to set up database multiplexing mode on the arbitration server.

In database multiplexing mode, the files that are required for operations are managed in the Mirroring Controller arbitration process management directory.

There is one Mirroring Controller arbitration process management directory for each arbitration process.

Perform the following procedure:

Linux

1. On the arbitration server, log in as any operating system user who starts and stops the arbitration process.

2. Configure the environment variables.

   Set the following environment variables:

   • PATH

     Add the installation directory "/bin".

   • MANPATH

     Add the installation directory "/share/man".

   Example

   The following example configures environment variables when the installation directory is "/opt/fsepv<x>assistant".

   Note that "<x>" indicates the product version.

   sh, bash

   $ PATH=/opt/fsepv<x>assistant/bin:$PATH ; export PATH
   $ MANPATH=/opt/fsepv<x>assistant/share/man:$MANPATH ; export MANPATH

   csh, tcsh

   $ setenv PATH /opt/fsepv<x>assistant/bin:$PATH
   $ setenv MANPATH /opt/fsepv<x>assistant/share/man:$MANPATH

3. Create the Mirroring Controller arbitration process management directory that will store the files required by the arbitration server.

   Use ASCII characters in the Mirroring Controller arbitration process management directory.

4. In the network configuration file (network.conf), define the Mirroring Controller network configuration that will be managed by the Mirroring Controller arbitration process.

   Create network.conf in the Mirroring Controller arbitration process management directory, based on the sample file. For network.conf, set read and write permissions only for the operating system user who starts and stops the arbitration process in step 1.

   If users other than this are granted access permissions, the mc_arb command will not work. Accordingly, users other than the operating system user who starts and stops the arbitration process in step 1 are prevented from operating the Mirroring Controller arbitration process.

   Sample file

   /installDir/share/mcarb_network.conf.sample

   In network.conf, specify the IP address or host name and port number of the primary server and standby server, and define the Mirroring Controller network configuration that will be managed by the Mirroring Controller arbitration process.

   Refer to "A.3 Network Configuration File" for details.

   A definition example is shown below.

   Example)
   The IDs of the servers are set to "server1" and "server2", and their port numbers are set to "27541".

   server1 192.0.3.100 27541
   server2 192.0.3.110 27541

5. In the arbitration configuration file (arbitration.conf), define the information related to control of the Mirroring Controller arbitration process.

   Create arbitration.conf in the Mirroring Controller arbitration process management directory, based on the sample file. For arbitration.conf, set read and write permissions only for the operating system user who starts and stops the arbitration process in step 1. If users other than this are granted access permissions, the mc_arb command will not work.

   Sample file

   /installDir/share/mcarb_arbitration.conf.sample

   Set the parameters shown in the table below in arbitration.conf.

   Table 2.1 Parameters

   Parameter	Content specified	Remarks
   port	Port number of the Mirroring Controller arbitration process	The port number must be 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.
   my_address	'ipAddrOrHostNameThatAcceptsConnectionFromMirroringControllerProcessOnDbServer' [Setting example] my_address = '192.0.3.120'	IPv4 and IPv6 addresses can be specified. Specify the IP address, enclosed in single quotation marks (').
   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 it is determined that an error has occurred. Enclose the path in single quotation marks ('). Specify the path using less than 1024 bytes.
   fencing_command_timeout	Timeout for fencing command (seconds)	If the command does not respond within the specified number of seconds, it is determined that fencing has 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.

   Information

   Refer to "A.4.2 Arbitration Configuration File" for information on the parameters and for other parameters.

   
   

Windows

1. On the arbitration server, log in as any operating system user who starts and stops the arbitration process.

2. Configure the environment variables.

   Set the following environment variable:

   • PATH

     Add the installation folders "\bin" and "\lib".

   Example

   The following example configures environment variables when the installation folder is "c:\Program Files\Fujitsu\fsepv<x>assistant64".

   Note that "<x>" indicates the product version.

   > SET PATH=c:\Program Files\Fujitsu\fsepv<x>assistant64\bin;c:\Program Files\Fujitsu\fsepv<x>assistant64\lib;%PATH%

3. Create the Mirroring Controller arbitration process management directory that will store the files required by the arbitration server.

   Use ASCII characters in the Mirroring Controller arbitration process management directory.

4. In the network configuration file (network.conf), define the Mirroring Controller network configuration that will be managed by the Mirroring Controller arbitration process.

   Create network.conf in the Mirroring Controller arbitration process management directory, based on the sample file.

   Sample file

   installDir\share\mcarb_network.conf.sample

   In network.conf, specify the IP address or host name and port number of the primary server and standby server, and define the Mirroring Controller network configuration that will be managed by the Mirroring Controller arbitration process.

   Refer to "A.3 Network Configuration File" for details.

   A definition example is shown below.

   Example)
   The IDs of the servers are set to "server1" and "server2", and their port numbers are set to "27541".

   server1 192.0.3.100 27541
   server2 192.0.3.110 27541

5. Change the access permissions for network.conf.

   For network.conf, set read and write permissions only for the operating system user who starts and stops the arbitration process in step 1. If users other than this are granted access permissions, the mc_arb command will not work. Accordingly, users other than the operating system user who starts and stops the arbitration process in step 1 are prevented from operating the Mirroring Controller arbitration process.

   Example)
   The following is an execution example, in which the operating system user who starts and stops the arbitration process in step 1 is granted full access permissions as the owner when the user is "fsepuser". The following procedure applies when the user is logged in to the Windows server as "fsepuser".

   > takeown /f network.conf
   > icacls network.conf /reset
   > icacls network.conf /inheritance:r
   > icacls network.conf /grant fsepuser:F

6. In the arbitration configuration file (arbitration.conf), define the information related to control of the Mirroring Controller arbitration process.

   Create arbitration.conf in the Mirroring Controller arbitration process management directory, based on the sample file.

   Sample file

   installDir\share\mcarb_arbitration.conf.sample

   Set the parameters shown in the table below in arbitration.conf.

   Table 2.2 Parameters

   Parameter	Content specified	Remarks
   port	Port number of the Mirroring Controller arbitration process	The port number must be 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.
   my_address	'ipAddrOrHostNameThatAcceptsConnectionFromMirroringControllerProcessOnDbServer' [Setting example] my_address = '192.0.3.120'	IPv4 and IPv6 addresses can be specified. Enclose the parameter value in single quotation marks (').
   service_name	'registeredServiceNameOfArbitrationProcessInWindowsServices'	Use ASCII characters excluding forward slash (/) and backslash (\) to specify this parameter. Enclose the parameter value in single quotation marks ('). The maximum length of the service name is 124 bytes.
   event_source	'eventSourceNameUsedToIdentifyArbitrationProcessMsgInEventLog'	Use ASCII characters excluding spaces to specify this parameter. Enclose the parameter value in single quotation marks ('). The maximum length of the event source name is 255 bytes.
   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 it is determined that an error has occurred. Specify "\\" as the delimiter. 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	Timeout for fencing command (seconds)	If the command does not respond within the specified number of seconds, it is determined that fencing has 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.

   
   

   Information

   Refer to "A.4.2 Arbitration Configuration File" for information on the parameters and for other parameters.

7. Change the access permissions for arbitration.conf.

   For arbitration.conf, set read and write permissions only for the operating system user who starts and stops the arbitration process in step 1. If users other than this are granted access permissions, the mc_arb command will not work.

   Example)
   The following is an execution example, in which the operating system user who starts and stops the arbitration process in step 1 is granted full access permissions as the owner when the user is "fsepuser". The following procedure applies when the user is logged in to the Windows server as "fsepuser".

   > takeown /f arbitration.conf
   > icacls arbitration.conf /reset
   > icacls arbitration.conf /inheritance:r
   > icacls arbitration.conf /grant fsepuser:F

8. Configure Windows Firewall.

   If Windows Firewall is used, enable the port number of Mirroring Controller specified in the network configuration file in step 3. Refer to "E.2 Windows Firewall Settings" for details.

9. Register the Mirroring Controller arbitration process as a Windows service.

   Execute the mc_arb command in register mode.

   For the -P option of the mc_arb command, specify the password of the operating system user who executes the command.

   Example)

   > mc_arb register -M D:\mcarb_dir\arbiter1 -P ********

   Note

   When specifying the password in the -P option of the mc_arb command, for security reasons, you should be careful not to allow other users to access it.

   Information

   Use the mc_arb command with the -S option to specify automatic start and stop of the Mirroring Controller arbitration process. Refer to "2.13 Setting Automatic Start and Stop of the Mirroring Controller Arbitration Process" for details.

   The Mirroring Controller arbitration process is registered as a Windows service using the service name specified in the service_name parameter of arbitration.conf in step 6.

   You can execute the sc qc command to check the registration status.