GKE PostgreSQL database merging

[paolo_fumanelli]

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

[AurelienGravier]

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 :

Properties are the same for earch database service :

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.

[paolo_fumanelli]

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

[AurelienGravier · Accepted solution]

Hello @paolo_fumanelli ,

I created the following RFE, I suggest voting and adding a comment from your side : 

https://community.dynatrace.com/t5/Product-ideas/Make-Dynatrace-compatible-with-Google-Cloud-SQL-IAM...

Thx

[paolo_fumanelli]

Great, thank you