cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 

GKE PostgreSQL database merging

Hi, in one of our monitored GKE clusters we have several PostgreSQL databases. The problem is that for each worker node, a new instance of PostgreSQL database is detected (see image below). That's formally correct but we'd like to be able to merge those databases into a single one to simplify analysis and troubleshooting.

Any hint for this?

Thanks
PF

paolo_fumanelli_1-1675174209480.png

 

 

2 REPLIES 2

AurelienGravier
Advisor

hello @paolo_fumanelli ,

 

I encounter the same issue as you on GKE environment with PostgreSQL.

Same issue here. We are using SQL-Proxies (client com.google.cloud.sql.postgres.SocketFactory) on all kubernetes Nodes to connect to our Database.

Dynatrace perceives a databases per node :

AurelienGravier_1-1679502893789.png

 

Properties are the same for earch database service :

AurelienGravier_2-1679502966869.png

 

The connection string used is :

spring:

datasource:
url: jdbc:postgresql:///${ClientName.sql.database-name}
hikari:
minimum-idle: 1
maximum-pool-size: 20
data-source-properties:
sslmode: disable
socketFactory: com.google.cloud.sql.postgres.SocketFactory
cloudSqlInstance: ${ClientName.sql.instance-connection-name}
enableIamAuth: true
user: ${ClientName.sql.username}

schema: db_amx

 

Did you find a workaround ?

 

 Thank you.

 

Observability consultant - Dynatrace Associate/Pro/Services certified

Hello Aurelien, unfortunately I didn't. Our main contact in Dynatrace told us that some news regarding database service should come later in the next quarters but no precise news about it.ù

bye
Paolo