Enable the Audit log purge scheduler in Openshift

Products

• CA API Developer Portal

Issue/Introduction

The Audit log database is heavily loaded, so the synchronization between nodes of the xxx DB cluster is no longer working? How can automation of the purging of the DB can be implemented in Openshift.

 

Environment

5.2.3

Cause

Basically for openshift the  Audit event log purging is enabled and set to 365 days retention by default.

Resolution

Set this variable to customize the retention period. Set the value to 0 to disable this feature. this variable should be added in the values.yaml prod

Environment Variable
Description
portalData.additionalEnv.AUDIT_LOG_RETENTION_DAYS
The number of days of logs to retain
portalData.additionalEnv.AUDIT_LOG_TRUNCATE_BATCH_SIZE
The max number of logs to be removed during a single interval
portalData.additionalEnv.AUDIT_LOG_TRUNCATE_FREQ_MIN
The frequency of log truncation intervals in minutes