This section provides the procedure to change to database multiplexing mode using the Mirroring Controller only on the database server when the arbitration server is used for automatic degradation.
Some tasks must be performed on the database server, and others must be performed on the arbitration server.
Tasks on the arbitration server
Set up the arbitration server.
Refer to "2.3 Setting Up the Arbitration Server" for information on how to set up the arbitration server.
Tasks on the database server
On the server where Mirroring Controller is running, execute the mc_ctl command in stop mode to stop Mirroring Controller on the primary server and standby server.
Example)
$ mc_ctl stop -M /mcdir/inst1 -a --mc-only
Edit the network.conf file of the primary server and standby server to add the information of the arbitration server.
Refer to "A.3 Network Configuration File" for details.
The definition example of the network.conf file of the primary server is shown below:
Example)
The IDs of the primary server and standby server are set to "server1" and "server2", and their port numbers are set to "27540" and "27541". The ID of the server of the Mirroring Controller arbitration process is set to "arbiter", and its port number is set to "27541".
server1 192.0.2.100,192.0.3.100 27540,27541 server server2 192.0.2.110,192.0.3.110 27540,27541 server arbiter 192.0.3.120 27541 arbiter
Note
Ensure that the port numbers set for the primary server, standby server, and arbitration server do not conflict with other software. Also do not configure the same segment for the admin network and arbitration network.
If the server type is "server", two IP addresses or host names, and two port numbers need to be specified in the following order:
IP address or host name of the database server used as the admin network
IP address or host name of the database server used as the arbitration network
Port number of the database server used as the admin network
Port number of the database server used as the arbitration network
If the server type is "arbiter", specify the IP address or host name set for the my_address parameter and the port number set for the port parameter in arbitration.conf.
Edit the serverIdentifier.conf file of the primary server and standby server to add parameters required for the operation where the arbitration server is used for automatic degradation.
Refer to "A.4.1 Server Configuration File for the Database Servers" for information on the parameters required when the arbitration server is used for automatic degradation.
On the primary server and standby server, execute the mc_ctl command in start mode to start the Mirroring Controller process.
Example)
$ mc_ctl start -M /mcdir/inst1 --mc-only
Check the connection status from the database server or arbitration server.
Refer to "2.8 Checking the Connection Status" for details.