开发者

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

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!


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.


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

0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜