search cancel

DX APM Postgres Database questions

book

Article ID: 229491

calendar_today

Updated On:

Products

DX Application Performance Management

Issue/Introduction

We need to know if on premise DX APM 20.X/21.X uses Postgres as APM Database.

What is the purpose of this Postgres for DX APM?

What type of data will be stored in Postgres?

Postgres runs in a container/pod?

DX APM can use Postgres other than within the installation?

Do you have any diagram and connectivity table (A table that shows what DX APM component communicate with the Postgres)?

Environment

Release : 20.2

Component : Introscope

Resolution

The postgres DB is required for DX platform (APM is part of DX platform).

The Postgres DB in DX APM 20.X performs different functions compare to APM 10.7.

There are multiple instances in the same pod. It runs as a pod - dxi-postgresql The data for the DB is written to NFS to make it permanent.

For example, it has the aoplatform instance, which was the DB in AXA.
That stores the main user info, tenant information etc. There are also other instances like doi for situations, for DSP (data science processing), for CPA (capacity analytics)

The core APM data is no longer stored in Postgresql, we use TAS and NASS for that and these are based on RocksDB. 
ACC which handles agent bundle preparation and distribution uses Postgresql for storing the bundle information.

Generally speaking, Acc has a dedicated Postgres DB deployed by ng-acc-configserver-db-deployment. 
This Postgres DB is used by Acc only - it contains all Acc entities (packages, bundles, agents, ....) and Acc configuration only.

The communications are normally handled within the cluster, routes are set up so the other pods that need to contact the DB can reach it.

We don't know about having a different DB but it's pretty much coded in at the moment so it may be not that straight forward. Also, our document does not mentioned to use another DB or different DB. Customers should only be using postgres database that gets installed during installation.

There is a video on this page that runs through the architecture, it's 20 minutes and gives good detail. It shows the data flows in the product.

https://techdocs.broadcom.com/us/en/ca-enterprise-software/it-operations-management/dx-platform-on-premise/20-2/installing/deployment-architecture.html

There is this technical document that has good information related to fixing issues in the postgres DB. 

https://knowledge.broadcom.com/external/article?articleId=184125