There are lots of tips about monitoring RDS using CloudWatch and other ways to monitor it without actually connecting to it. This is not ideal for me.
I have a PHP app that connects to RDS as its database instance. I would like to use a Zabbix Agent process running on the same server as PHP to monitor basic statistics of the RDS instance (uptime, connections/sec, etc). I would assume I can just use the Zabbix Agent to connect to the RDS instance and gather stats onit.
On other servers that run MySQL locally, I've used the Zabbix's "MySQL via Zabbix Agent" just fine. But when the server is "remote" like RDS is, can't seem to get much more than mysqi.ping to work. All other metrics won't work, despite having defined macros like {$MYSQL_HOST} with the DNS to the server, just like the PHP instance is using.
I'm also familiar with the solution at https://git.zabbix.com/projects/ZBX/...at=release/6.0 but it only works well for local MySQL servers (ie. running on the same server as the Zabbix Agent).
Before I go and write one of these templates from scratch, is there anything out there that does this?
Update: I've started to build a template with system calls using mysqladmin, but as it's calling out to the CLI, it's a hack for sure.
I have a PHP app that connects to RDS as its database instance. I would like to use a Zabbix Agent process running on the same server as PHP to monitor basic statistics of the RDS instance (uptime, connections/sec, etc). I would assume I can just use the Zabbix Agent to connect to the RDS instance and gather stats onit.
On other servers that run MySQL locally, I've used the Zabbix's "MySQL via Zabbix Agent" just fine. But when the server is "remote" like RDS is, can't seem to get much more than mysqi.ping to work. All other metrics won't work, despite having defined macros like {$MYSQL_HOST} with the DNS to the server, just like the PHP instance is using.
I'm also familiar with the solution at https://git.zabbix.com/projects/ZBX/...at=release/6.0 but it only works well for local MySQL servers (ie. running on the same server as the Zabbix Agent).
Before I go and write one of these templates from scratch, is there anything out there that does this?
Update: I've started to build a template with system calls using mysqladmin, but as it's calling out to the CLI, it's a hack for sure.