Amazon MemoryDB for Redis

Support - Assistance technique
1

Hi there !
Has anyone ever used Amazon memorydb for redis with DHIS2? Is it even supported?
Really appreciate your help on this.
Thanks!

2

Hi @Anubha_Bawa,

Thanks for the question.

DHIS2 software uses PostgreSQL database which is a relational database and in the application source code SQL queries are used in uses tables to store data whereas the MemoryDB is a completely different type of database that doesn’t even use SQL queries and tables to handle the data.

Therefore, I doubt that anyone has ever attempted to use MemoryDB; however, there are Amazon services that can support the PostgreSQL database which is the most recommended database for DHIS2 software.

You’re welcome to add more about your use case. It might be possible to develop a web application that supports the transfer of information to both DBs.

3

We also tried to use AWS ElastiCache Redis and it throws the following error
Job aborted: ‘Leader election in cluster’, job of type: ‘LEADER_ELECTION’ is already running\

Any insight on this error? we get this error when we have 2 nodes of DHIS2 running in a ECS Cluster. With just one node it works with any error. Any DHIS2 configuration that needs to be done for this to work?