开发者

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

开发者 https://www.devze.com 2022-12-18 11:12 出处:网络
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

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

精彩评论

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