PMM QAN - External clustered clickhouse schema issue

Percona Monitoring and Management (PMM) PMM 3.x
,
1

Hi Team ,

We are hosting pmm on k8s environment with external clickhouse and postgresql and we started the pod with external by giving creds in the env config. PMM QAN API2 is created database and tables on the clkickhouse but its not clustered. Its not using on cluster command for database and replicatedmergetree for tables , without this clickhouse will not be a clustered one , whatever pmm is inserting it will go into single node which defeats the purpose of clustering on clkickhouse. Please help how we can give support for external clustered clickhouse.

2

Hi,

It seems like we have a gap there and PMM will need to implement the `replicatedmergetree` engine for the clustered ClickHouse configurations. Therefore, please feel free to create a feature request in PMM Jira.

Meanwhile, it should be possible to work around it by running a DDL statement that alters the engine to make it `replicatedmergetree` instead.

Cheers