Dec 12, 2016 |
MongoDB, MySQL, Percona Events, Percona Software
Percona announces the release of Percona Monitoring and Management 1.0.7. The Percona Monitoring and Management Server (PMM) is distributed through Docker Hub, PMM Client – through tarball or system packages. The instructions for installing or upgrading PMM are available in the documentation. PMM Server changelog Added new widgets and graphs to “PXC/Galera Graphs” dashboard. Fixed […]
Dec 09, 2016 |
MongoDB, MySQL, Percona Events
Percona announces the release of Percona Monitoring Plugins 1.1.7. Changelog New Nagios script pmp-check-mongo.py for MongoDB. Added MySQL socket and flag options to Cacti PHP script. Added disk volume check on “Mounted on” in addition to “Filesystem” to Cacti PHP script to allow monitoring of tmpfs mounts. Allow delayed slave to have SQL thread stopped […]
Oct 25, 2016 |
Cloud, Insight for DBAs, Percona Software
This article describes how to visualize and monitor OS metrics for Amazon RDS instances using Grafana. We use CloudWatch as a data source, and Grafana to query CloudWatch API in real-time to get data. The setup instructions include just four quick steps (assuming you already use Grafana). Setup 1. Create an IAM user on the AWS […]
Oct 14, 2016 |
Percona Events, Percona Software
Percona is glad to announce the release of Percona Monitoring and Management 1.0.5. PMM Server is distributed through Docker Hub, PMM Client – through tarball or system packages. The instructions for installing or upgrading PMM are available in the documentation. PMM Server changelog Prometheus 1.1.3 Consul 0.7.0 Added Orchestrator – a MySQL replication topology management […]
Sep 23, 2016 |
MySQL, Percona Software
In this blog, I will provide answers to the Q & A for the Identifying and Solving Database Performance Issues with PMM webinar. First, I want to thank everybody for attending the September 15 webinar. The recording and slides for the webinar are available here. Thanks for so many good questions. Below is the list […]
Sep 07, 2016 |
MySQL, Security
This post will tell you how to get MySQL passwords in plain text using the .mylogin.cnf file. Since MySQL 5.6.6, it became possible to store MySQL credentials in an encrypted login path file named .mylogin.cnf, using the
May 26, 2016 |
Monitoring
Percona has released a new Percona App for Grafana! Are you using Grafana 3.x with Prometheus’ time-series database? Now there is a “Percona App” available on Grafana.net! The app provides a set of dashboards for MySQL performance and system monitoring with Prometheus’ datasource, and make it easy for users install them. The dashboards rely on the alias label […]
Feb 29, 2016 |
Monitoring, MySQL
This post explains how you can quickly start using such trending tools as Prometheus and Grafana for monitoring and graphing of MySQL and system performance. Update, February 20, 2017: Since this blog post was published, we have released Percona Monitoring and Management (PMM), which is the easiest way to monitor MySQL and MongoDB using Grafana and […]
Jan 12, 2016 |
Percona Events
Percona is glad to announce the release of Percona Monitoring Plugins 1.1.6. Changelog: Added new RDS instance classes to RDS scripts. Added boto profile support to RDS scripts. Added AWS region support and ability to specify all regions to RDS scripts. Added ability to set AWS region and boto profile on data source level in […]
Jun 22, 2015 |
Percona Events
Percona is glad to announce the release of Percona Monitoring Plugins 1.1.5. Changelog: Added more DB instance classes to pmp-check-aws-rds.py (issue 1398911) Added configurable query period and average time to pmp-check-aws-rds.py (issue 1436943) Added region support to pmp-check-aws-rds.py (issue 1442980) Added an option to alert when server is not configured as replica to pmp-check-mysql-replication-delay (issue […]
Jan 07, 2015 |
Insight for Developers, 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 in […]
Jul 21, 2014 |
Percona Events
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 […]
Mar 21, 2014 |
MySQL, Percona Events
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 […]
Mar 19, 2014 |
Security
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:
|
# httpd 2.4 Require host localhost # httpd 2.2 Order deny,allow Deny from all Allow from localhost |
In order, to access the Cacti web interface, most likely, you will be changing this configuration. Commenting out Deny/Require statements will […]
Mar 14, 2014 |
Cloud, MySQL, Percona Events
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 […]
Dec 30, 2013 |
MySQL, Percona Events
Percona announces the release of Percona Monitoring Plugins 1.1.1 to address the critical bug that appears after the 1.1 upgrade. Changelog: * Cacti mysql graphs stop working with data input field “server-id” after 1.1 upgrade (bug 1264814) * Non-integer poller errors for MySQL Query Response Time (bug 1264353) A new tarball is available from downloads […]
Dec 18, 2013 |
MySQL, Percona Events
Percona is glad to announce the release of Percona Monitoring Plugins 1.1. The components are designed to integrate seamlessly with widely deployed solutions such as Nagios, Cacti and Zabbix, and are delivered in the form of templates, plugins, and scripts. In this release we have added MySQL template for Zabbix 2.0.x adopted from the existing […]
Oct 11, 2013 |
MySQL, Percona Events, Percona Software
Percona is glad to announce the release of Percona Monitoring Plugins 1.0.5 for MySQL. The components are designed to integrate seamlessly with widely deployed solutions such as Nagios and Cacti, and are delivered in the form of templates, plugins, and scripts. Changelog: * Added mysql-ca option to ss_get_mysql_stats.php (bug 1213857) * Added user info to […]
Sep 16, 2013 |
Insight for DBAs, MySQL
Working day to day with Percona Remote DBA customers, we have been facing an issue from time to time when MySQL replication lag is flapping between 0 and XXXXX constantly – i.e. Seconds_Behind_Master is 0 for a few secs, then it’s like 6287 or 25341, again 0 and so on. I would like to note […]
Jul 25, 2013 |
MySQL, Percona Events, Percona Software
Percona is glad to announce the release of Percona Monitoring Plugins 1.0.4. The components are designed to integrate seamlessly with widely deployed solutions such as Nagios and Cacti, and are delivered in the form of templates, plugins, and scripts. Changelog: * Added Galera/MySQL Monitoring Template for Cacti * Added “Disk Read/Write Time per IO Request […]