Yearly Archives - 2013

Percona Monitoring Plugins 1.1, now with Zabbix support

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 […]

Read more

Percona XtraDB Cluster 5.6.15-25.2 first Release Candidate is now available

Percona is glad to announce the first RC release of Percona XtraDB Cluster 5.6 on December 18th, 2013. Binaries are available from downloads area or from our software repositories.
Based on Percona Server 5.6.15-63.0 including all the bug fixes in it, Galera Replicator 3.2 and on Codership wsrep API 5.6.15-25.2 is now the first RELEASE […]

Read more

Seconds_Behind_Master fluctuating wildly? Check for events caught in a loop

Recently I was working with a customer where we noticed that Seconds_Behind_Master fluctuating from an expected value of 0 seconds behind to a fairly high six figure value.  The servers were configured in a master-master relationship and used 5 figure server_id values, and we had just migrated this cluster from one data centre to […]

Read more

One more InnoDB gap lock to avoid

While troubleshooting deadlocks for a customer, I came around an interesting situation involving InnoDB gap locks. For a non-INSERT write operation where the WHERE clause does not match any row, I expected there should’ve been no locks to be held by the transaction, but I was wrong. Let’s take a look at this table […]

Read more

A sneak peek at the Percona Live MySQL Conference & Expo 2014

Percona founder and CEO Peter Zaitsev delivers the opening keynote at Percona Live 2013 in Santa Clara, Calif.
MySQL gurus from Oracle, Facebook, Google, LinkedIn, Twitter, Yelp (and more) have submitted papers and will speak at the third annual Percona Live MySQL Conference and Expo 2014 in sunny Santa Clara, California this coming April 1-4.
If […]

Read more

December 17 Webinar: Use Your MySQL Knowledge to Become a MongoDB Guru

Use your MySQL expertise to analyze the strengths and weaknesses of MongoDB.
SPEAKER: Tim Callaghan, VP of Engineering at Tokutek
DATE: Tuesday, December 17th
TIME: 1pm ET
Register Now!
MongoDB is a popular NoSQL DBMS that shares the ease-of-use and quick setup that made MySQL famous. But is MongoDB really up to the job? Is it right for your […]

Read more

Q&A: Geographical disaster recovery with Percona Replication Manager

My December 4 webinar, “Geographical disaster recovery with  Percona Replication Manager (PRM),”  gave rise to a few questions. The recording of the webinar and the slides are available here, and I’ve answered the questions I didn’t have time to address below.
Q1: Hi, I was wondering if corosync will work in cloud environment. As far as […]

Read more

Linux performance tuning tips for MySQL

Because most MySQL production systems probably run on Linux, I’ve decided to place the most important Linux tuning tips that will help improve MySQL performance. There is nothing new here, most of them are well known, however, I’ve decided to collect those Linux configuration tips into 1 blog post.
Filesystem

ext4 (or xfs), mount with noatime
Scheduler […]

Read more

Nominate Tokutek for the 7th Annual Crunchies Awards

Nominate Tokutek for the 2013 Best Technology Achievement Crunchies award! Help us be recognized for our database performance engines, TokuMX™ and TokuDB, and our revolutionary Fractal Tree® technology. Nominations will only be accepted until December 15, 2013 at 11:59pm PST – so vote now! We appreciate your support.
Each year, CrunchTech hosts an annual […]

Read more

December 10 Webinar: Understanding Indexing

Get the Most out of Your Database – Understand Indexing
SPEAKER: Zardosht Kasheff, Tokutek
DATE: Tuesday, December 10th
TIME: 1pm ET
Register Now!
Join Tokutek’s Zardosht Kasheff as he discusses one of the quickest and least expensive ways to increase your application performance.
Application performance often depends on how fast a query can respond and query performance almost always depends […]

Read more