Fwd: Database Master - Slave replication

[Bob Jolliffe]

Anybody got any experience using pgpool with DHIS2?

---------- Forwarded message ---------
From: arvind chikne <arvind...@gmail.com>
Date: Mon, 7 Jan 2019 at 12:39
Subject: Database Master - Slave replication
To: Bob Jolliffe <bobjo...@gmail.com>

Hi Bob, 

Hope you are doing well.

I am doing R&D on DHIS2 High availability setup to avoid single point of failure and auto failover, in order to achieve that, on the database level I have done postgres Master slave replication and auto failover, I have achieved the master slave replication and its working fine on the database level.

Now I need to connect the database to the DHIS2 application, I have some doubts it would be relay great if you can help me to solve it.

1) Would it be possible to connect DHIS2 with a read-only database (Postgres) through dhis.conf (for reporting part no write queries will perform on this instance).

2) What configuration should I change in dhis.conf file to connect the postgres HA controller (PGPOOL)

I gave the following config in dhis.conf but it's not working 

connection.url = jdbc:postgresql://192.168.0.164:9999/db_name 

Error:- 

26-Dec-2018 13:11:07.669 WARNING [localhost-startStop-1] org.postgresql.jdbc.PgConnection.isValid Validating connection.

 org.postgresql.util.PSQLException: An I/O error occurred while sending to the backend.

        at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:333)

 

I have tried to make a high level diagram for your understanding, pls see below.

 

--

Thanks & Regards
Arvind rao chikne

9818979986

Think Green!!! Please consider your environmental responsibility before printing this e-mail