Can we add output of SQL query in MariaDB to PMM dashboard

Percona Monitoring and Management (PMM)
1

Description:

HI Team,
Since there is no option to monitor multi channel replication yet in PMM, I am looking for an alternate solution in which I can run a query to get the required fields of show slave status in MariaDB and write the output to a file or to a table within MariaDB from which I can pull the stats using PMM agent to add the details in PMM dashboard. Can you let me know if this can be done, if so can you share me the steps.

Steps to Reproduce:

Version:

PMM 2.41.2

Logs:

Expected Result:

Actual Result:

Additional Information:

2

Hi @tee952,

I think this is what you are looking for:

Let us know how it goes.