Site icon Database Tutorials

Download EDB Failover Manager

In this article, I will tell you about the Download EDB Failover Manager.

The EFM cluster consists of:

1. An active primary server where transactions take place.

2. One or more standby databases.

3. Witness server assists efm cluster in decision making during primary or standby failover scenario.
However, if there is more than one standby node, the witness server is not required.

If you have not done the EDB installation and standby installation before, you can perform the installations by following the links below.

EDB PostgreSQL Installation:

EDB Standby Setup:

ENVIRONMENT DETAILS:

PRIMARY DB SERVER : 192.168.1.130
STANDBY DB SERVER : 192.168.1.14
WITNESS SERVER : 192.168.1.20

For the cluster structure, three servers must communicate with each other.

To Do On Primary Server

1. We add the following lines to the pg_hba.conf file and then restart the service.

2. We load EFM.

3. The database user’s password is encrypted. Since I will be using the enterprisedb user, I will write his password.

4. We copy files and grant necessary authorizations.

5. The efm.properties file is updated.

6. We start the EFM service.

7. We add Allow node to standby and witness strings.

8. We enter the standby and witness server ips in the efm.nodes file.

To Do On Standby Server

1. We add the following lines to the pg_hba.conf file and then restart the service.

2. We load EFM.

3. We copy files and grant necessary authorizations.

4. We update the efm.properties file.

5. We enter the primary and witness server ips in the efm.nodes file.

6. We start the EFM service.

What To Do On The Witness Server

1. Add the following lines to the pg_hba.conf file and then restart the service.

2. We load EFM.

3. We copy files and grant necessary authorizations.

4. We update the efm.properties file.

5. We enter the primary and standby server IPs in the efm.nodes file.

6. We start the EFM service.

After the necessary steps are taken on all three servers, we check the EFM service status with the following command.

I hope it has been a useful document for you.

Exit mobile version