topic GKE PostgreSQL database merging in Cloud platforms

GKE PostgreSQL database merging

paolo_fumanelli — Wed, 14 Jun 2023 08:47:59 GMT

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

Re: GKE PostgreSQL database merging

AurelienGravier — Wed, 22 Mar 2023 16:40:56 GMT

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.

Re: GKE PostgreSQL database merging

paolo_fumanelli — Thu, 23 Mar 2023 08:07:39 GMT

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

Re: GKE PostgreSQL database merging

AurelienGravier — Fri, 05 May 2023 07:47:38 GMT

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-database/idi-p/211279

Thx

Re: GKE PostgreSQL database merging

paolo_fumanelli — Fri, 05 May 2023 08:04:20 GMT

Great, thank you