Fixing ‘Missing dependency Cache::Cache at /usr/share/munin/plugins/mysql_’ error

While installing MySQL plugins for munin in Fedora 15 you may encounter this problem: [root@monitor plugins]# /usr/share/munin/plugins/mysql_ suggest Missing dependency Cache::Cache at /usr/share/munin/plugins/mysql_ line 716. [root@monitor plugins]# It means that your system lacks perl-Cache-Cache and perl-IPC-ShareLite packages. After installation you can proceed: yum install perl-Cache-Cache perl-IPC-ShareLite [root@monitor plugins]# /usr/share/munin/plugins/mysql_ suggest bin_relay_log commands connections files_tables innodb_bpool…

Cleaning ‘Failed actions’ message in Pacemaker/Corosync cluster setup

Sometimes when using Pacemaker/Corosync-based cluster you can see warning message in crm_mon output: Failed actions: drbd_mysql:0_promote_0 (node=node2.cluster.org, call=11, rc=-2, status=Timed Out): unknown exec error To clean it up you can use command crm_resource which checks health of resources: [root@node1 ~]# crm_resource -P Waiting for 1 replies from the CRMd. OK [root@node1 ~]# To check cluster’s…

Automatic GeoIP database update

Free binary GeoLite Country database by MaxMind is being ¬†updated every month. To update it automatically you can¬† put this script to cron at the beginning of a month. #!/bin/sh cd /usr/share/GeoIP wget -q http://geolite.maxmind.com/download/geoip/database/GeoLiteCountry/GeoIP.dat.gz gzip -d -f GeoIP.dat.gz [root@playground ~]# sh -x /usr/local/sbin/geoip-update.sh + cd /usr/share/GeoIP + wget -q http://geolite.maxmind.com/download/geoip/database/GeoLiteCountry/GeoIP.dat.gz + gzip -d -f…