Top
Enterprise Postgres 16 Cluster Operation Guide(Database Multiplexing)

3.9.4 Changing to Database Multiplexing Mode when the Arbitration Server is Used for Automatic Degradation

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

  1. 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

  1. 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
  2. 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.

  3. 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.

  4. 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
Common tasks
  1. Check the connection status from the database server or arbitration server.

    Refer to "2.8 Checking the Connection Status" for details.