EmergencyEMERGENCY? Get 24/7 Help Now!

Hardening your Cacti setup

 | March 19, 2014 |  Posted In: Percona Monitoring Plugins, 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:

In order, to access the Cacti web interface, most likely, you will be changing this configuration. Commenting out Deny/Require statements will […]

Read More

My Favorite MongoDB Replication Feature: Crash Safety

 | March 18, 2014 |  Posted In: Tokutek, TokuView

At an extremely high level, replication in MongoDB and MySQL are similar. Both databases have exactly one machine, the primary (or master), that accepts writes from clients. With a single transaction (or atomic operation, in MongoDB’s case), the tables and oplog (or binary log in MySQL) are modified to reflect the change. The log captures […]

Read More

Percona Server 5.6.16-64.1 is now available

 | March 17, 2014 |  Posted In: Events and Announcements, MySQL, Percona Server for MySQL, Percona Software

Percona is glad to announce the release of Percona Server 5.6.16-64.1 on March 17th, 2014 (Downloads are available here and from the Percona Software Repositories. Based on MySQL 5.6.16, including all the bug fixes in it, Percona Server 5.6.16-64.1 is the current GA release in the Percona Server 5.6 series. All of Percona’s software is […]

Read More

Percona Server 5.5.36-34.1 is now available

 | March 17, 2014 |  Posted In: Events and Announcements, Percona Server for MySQL, Percona Software

Percona is glad to announce the release of Percona Server 5.5.36-34.1 on March 17th, 2014 (Downloads are available here and from the Percona Software Repositories). Based on MySQL 5.5.36, including all the bug fixes in it, Percona Server 5.5.36-34.1 is now the current stable release in the 5.5 series. All of Percona‘s software is open-source and free, all the details of the release […]

Read More

MySQL Slow Query Log: Tools and Tips

 | March 14, 2014 |  Posted In: Insight for DBAs, MySQL

MySQL has a nice feature: MySQL slow query log, which allows you to log all queries that exceed a predefined about of time to execute. Peter Zaitsev first wrote about this back in 2006 – there have been a few other posts here on the MySQL Performance Blog since then (check this and this, too) […]

Read More

Percona Monitoring Plugins 1.1.2, now with Amazon RDS support

 | March 14, 2014 |  Posted In: Cloud and MySQL, Cloud and NoSQL, Events and Announcements, MySQL, Percona Monitoring Plugins

Percona is glad to announce the release of Percona Monitoring Plugins 1.1.2. Changelog: * Added Nagios plugin and Cacti template for Amazon RDS * Added Nagios config template to the documentation * Added an option to pmp-check-pt-table-checksum to check MAX(ts) of latest checksum * Added generic Nagios plugin for PT tables * Extended pmp-check-mysql-processlist with […]

Read More

Open Source Appreciation Day at the Percona Live MySQL Conference

 | March 13, 2014 |  Posted In: Events and Announcements, High-availability, Insight for DBAs, Insight for Developers, MySQL, OpenStack, Percona Live, Percona Software, Percona XtraDB Cluster

I am very pleased to announce a new event in conjunction with the Percona Live MySQL Conference and Expo this year: Open Source Appreciation Day on Monday, March 31st in the Santa Clara Convention Center! We are pleased to announce two separate groups holding events this year under this new umbrella. We are hosting an […]

Read More