Description:
Dear community,
Once again we need your help about PMM product. This time we have trouble with getting info about replication between two servers.
To prepare our migration plan, we need to test new MySQL version and also replication. After installing our 2 test servers, we added them in PMM but replication dedicated dashboard show nothing
Only these informations are missing, PMM works well with performance metrics or QAN for these test servers.
Also we check that in local PMM user can run query to get replication information (no problem with that).
Steps to Reproduce:
Install two server with MySQL, enable replication between them and configure PMM client on each server as described in Quickstart guide - Percona Monitoring and Management.
Version:
OS : Ubuntu Server 24.04 LTS
MySQL : 8.4.5 community server
PMM : 2.43.2 (Server and Client)
Expected Result:
In MySQL Replication summary dashboard, the “IO Thread Running”, “SQL Thread Running” and “MySQL Replication Lag” panel display “Yes” or “No” value
Actual Result:
Actual value is “No data”
Additional info
Is this possible that PMM always uses SHOW SLAVE STATUS to get replication info ?
This command is no longer available in MySQL 8.4 and now we must use SHOW REPLICA STATUS instead.