How to Properly Add MySQL Router to PMM v3 Monitoring?

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

Hello Percona Community,

I need help configuring PMM v3 to monitor MySQL Router instances while maintaining proper InnoDB Cluster detection. Here’s my environment:

Environment:

  • MySQL InnoDB Cluster (3 nodes, MySQL 8.0)
  • MySQL Router (3 nodes, 8.0)
  • PMM Server v3.x
  • Architecture: On-premises

Current Situation:

  1. PMM successfully monitors the InnoDB Cluster nodes
  2. Need to add 3 MySQL Router instances to PMM monitoring
  3. Want to keep Router monitoring separate from existing cluster metrics

Key Questions:

  1. Should I use the ProxySQL addition method for MySQL Router?
  2. What’s the proper way to configure read/write ports (6446/6447) in PMM?
  3. How do I know the read-only and read-write ports are working properly?
2

Hello @huangsijun17,

PMM does not natively support monitoring MySQL Router. I found this 3rd party exporter that you can add to PMM using external support.

You will need to import custom dashboards to see this info which will be separate from other metrics.

No, you pick either ProxySQL or MySQL Router. In our testing, MySQL Router was the worst performing proxy with the least flexibility, and features.

You don’t use PMM to configure MySQL Router. PMM does not manage configuration of MySQL Router.

Run some tests :smiley: Use mysql command-line client to test the ports.