Making mosip_ida DB as read-only database for HA

Support
1

Dear MOSIP Team,

We have deployed MOSIP v1.2.0.1 on-prem. We were testing Active-Active and Active-Passive topology for HA for authentication service but when made mosip_ida as read-only I was not able to authenticate as it tries to write into few tables like otp_transaction, auth_transaction, kyc_token_store, etc.
Is it possible or is there any way to make mosip_ida database as read-only for HA?

2

Hi @Durgesh ,

Thank you for reaching out to us. Our team is checking on your query will resolve your issue as soon as possible.

Regards,
N. Chandra Sekhar

3

Hi @chandra_sekhar ,
Sure, thank you for the reply.

4

Hello @Durgesh

Could you please clarify the reason for proposing that the MOSIP IDA database be configured as read-only?

The MOSIP IDA system continuously writes data to the database as part of its core functionality. For example, during an OTP authentication flow, an OTP request is first generated and the corresponding transaction details are recorded in the database. Additionally, every authentication transaction processed by IDA is logged in the database.

Whenever a new identity is created in MOSIP, the relevant data is also shared with IDA to enable authentication, which again involves database write operations.

Given these ongoing write requirements, the IDA database cannot be set to read-only, regardless of the HA topology in use.

Thanks,

Mahammed Taheer

5

This topic was automatically closed 10 days after the last reply. New replies are no longer allowed.