EmergencyEMERGENCY? Get 24/7 Help Now!

Why TokuDB hates Transparent HugePages

 | July 23, 2014 |  Posted In: MySQL, TokuDB

If you try to install the TokuDB storage engine on a modern Linux distribution it might fail with following error message: 2014-07-17 19:02:55 13865 [ERROR] TokuDB will not run with transparent huge pages enabled. 2014-07-17 19:02:55 13865 [ERROR] Please disable them to continue. 2014-07-17 19:02:55 13865 [ERROR] (echo never > /sys/kernel/mm/transparent_hugepage/enabled) You might be curious […]

Read More

Reference architecture for a write-intensive MySQL deployment

 | July 22, 2014 |  Posted In: Insight for DBAs, MySQL, Percona Cloud Tools, Percona Server for MySQL, TokuDB

We designed Percona Cloud Tools (both hardware and software setup) to handle a very high-intensive MySQL write workload. For example, we already observe inserts of 1bln+ datapoints per day. So I wanted to share what kind of hardware we use to achieve this result. Let me describe what we use, and later I will explain […]

Read More

Explaining Ark Part 1: The Basics

 | July 22, 2014 |  Posted In: Tokutek, TokuView

Last week, we introduced Ark, a consensus algorithm similar to Raft and Paxos we’ve developed for TokuMX and MongoDB. The purpose of Ark is to fix known issues in elections and failover. While the tech report detailing Ark explains everything formally, over the next few blog posts, I will go over Ark in layman’s terms. […]

Read More

Percona XtraDB Cluster 5.6.19-25.6 is now available

 | July 21, 2014 |  Posted In: Events and Announcements, MySQL, Percona Software, Percona XtraDB Cluster

Percona is glad to announce the new release of Percona XtraDB Cluster 5.6 on July 21st 2014. Binaries are available from downloads area or from our software repositories. We’re also happy to announce that Ubuntu 14.04 LTS users can now download, install, and upgrade Percona XtraDB Cluster 5.6 from Percona’s software repositories. Based on Percona […]

Read More

Percona Monitoring Plugins 1.1.4 release

 | July 21, 2014 |  Posted In: Events and Announcements, Percona Monitoring Plugins

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

Read More

Systemtap solves phantom MySQLd SIGTERM / SIGKILL issue

 | July 18, 2014 |  Posted In: Insight for DBAs, MySQL, Percona Managed Services, Percona Remote DBA

The Percona Managed Services team recently faced a somewhat peculiar client issue. We’d receive pages about their MySQL service being unreachable. However, studying the logs showed nothing out of the ordinary…. for the most part it appeared to be a normal shutdown and there was nothing in anyone’s command history nor a cron task to speak […]

Read More

Q&A: Even More Deadly Mistakes of MySQL Development

 | July 17, 2014 |  Posted In: Insight for Developers, MySQL, Technical Webinars

On Wednesday I gave a presentation on “How to Avoid Even More Common (but Deadly) MySQL Development Mistakes” for Percona MySQL Webinars.  If you missed it, you can still register to view the recording and my slides. Thanks to everyone who attended, and especially to folks who asked the great questions.  I answered as many as we had […]

Read More

High Availability with mysqlnd_ms on Percona XtraDB Cluster

 | July 16, 2014 |  Posted In: High-availability, Insight for Developers, MySQL, Percona XtraDB Cluster

This is the second part of my series on High Availability with mysqlnd_ms. In my first post, “Simple MySQL Master HA with mysqlnd_ms,” I showed a simple HA solution using asynchronous MySQL replication. This time we will see how to leverage an all-primary cluster where you can write to all nodes. In this post I used […]

Read More