Is it possible to use Cacti to monitor MySQL on Amazon's RDS?

Question

I noticed that the instructions to setup cacti with mysql mention granting SUPER priveleges:

Create a MySQL user with the SUPER and PROCESS privileges on each server you want to monitor

However, it looks like using the Relational Database Service from Amazon (RDS), you cannot grant SUPER privileges. Does this mean I can't use cacti?

Thanks!

Answer 1

Unfortunately the answer is NO.

Since you are aware that cacti needs privileges on MYSQL if you are looking to monitor things like innodb duffer pool, table locks, query cache, checkpoint e.t.c .

I would recommend moving out of RDS if this is possible. If high availability is an issue then you can look into MMM, or galera cache for High availability of you Master server.

Answer 2

Yes, you can. Here you have the percona documentation.

http://www.percona.com/doc/percona-monitoring-plugins/1.1/cacti/rds-templates.html

KR, Antonio