This should be done in zabbix if we can. We should be monitoring per user connections to the db, for example on db2:
ps auxwww | grep -c mirroradmin
We'd then want a per host graph that stacks each request so we can see the total grouping.
Zabbix is gone and I just got this working in collectd:
https://admin.fedoraproject.org/collectd/bin/index.cgi?hostname=db02&plugin=pg_conns×pan=3600&action=show_selection&ok_button=OK
Login to comment on this ticket.