Author - Roman Vynar

Django with time zone support and MySQL

This is yet another story of Django web-framework with time zone support and pain dealing with python datetimes and MySQL on the backend. In other words, offset-naive vs offset-aware datetimes.
Shortly, more about the problem. After reading the official documentation about the time zones, it makes clear that in order to reflect python datetime […]

Read more

Percona Monitoring Plugins 1.1.4 release

Percona is glad to announce the release of Percona Monitoring Plugins 1.1.4.
Changelog:

* Added login-path support to Nagios plugins with MySQL client 5.6 (bug 1338549)
* Added a new threshold option for delayed slaves to pmp-check-mysql-replication-delay (bug 1318280)
* Added delayed slave support to pmp-check-mysql-replication-running (bug 1332082)
* Updated Nagios plugins and Cacti script to leverage lock-free SHOW […]

Read more

Percona Monitoring Plugins 1.1.3. Addressed CVE-2014-2569.

Percona is glad to announce the release of Percona Monitoring Plugins 1.1.3.
Changelog:

* Introduced more secure location of PHP script configs to harden a Cacti setup
* Addressed CVE-2014-2569

We have introduced a more secure location /etc/cacti/ for PHP script configs. Earlier, the only way was to keep .php.cnf configs inside of scripts/ folder which falls under […]

Read more

Hardening your Cacti setup

If you are using Percona Monitoring Plugins for Cacti, this article should be important to you.
By default, the Cacti setup is closed from accessing from Web. Here is an excerpt from /etc/httpd/conf.d/cacti.conf:

Shell

# httpd 2.4
Require host localhost

# httpd 2.2
Order deny,allow
Deny from all
Allow from localhost

1234567

# httpd 2.4 Require host localhost  # httpd 2.2 Order deny,allow Deny from all Allow from localhost

In […]

Read more

Percona Monitoring Plugins 1.1.2, now with Amazon RDS support

Percona is glad to announce the release of RDS metrics from Amazon CloudWatch. With Nagios you can have the following checks per instance: RDS Status, RDS Load Average, RDS Free Storage, RDS Free Memory. Also check out the examples of Configuration Best Practices section with it.
Freshness check for checksumming. A new option of the […]

Read more