by Michael Coburn | Jul 28, 2014 | Cloud, Insight for DBAs, MySQL, Percona Services
Hi, I recently had the experience of assisting with a migration of a customer MySQL installation to Amazon RDS (Relational Database Service). Amazon RDS is a great platform for hosting your MySQL installation and offers the following list of pros and cons: You can...
by Stephane Combaudon | Jul 25, 2014 | Insight for DBAs, MySQL, Percona Software
Monitoring flow control in a Galera cluster is very important. If you do not, you will not understand why writes may sometimes be stalled. Percona XtraDB Cluster 5.6 provides 2 status variables for such monitoring: wsrep_flow_control_paused and...
by Zardosht.Kasheff | Jul 25, 2014 | MySQL
This is the second post in a series of posts that explains Ark, a consensus algorithm we’ve developed for TokuMX and MongoDB to fix known issues in elections and failover. The tech report we released last week describes the algorithm in full detail. These posts are a...
by Fernando Ipar | Jul 24, 2014 | MySQL, Webinars
Martin and I have recently been blogging together about MySQL Fabric (in case you’ve missed this, you can find the first post of the series here), and on July 30th, we’re going to be presenting a webinar on this topic titled “Putting MySQL Fabric to...
by Dimitri Vanoverbeke | Jul 24, 2014 | Insight for DBAs, MySQL
We’ll be publishing a series of posts on OpenStack and Trove over the next few weeks, diving into their usage and purpose. For readers who are already familiar with these technologies, there should be no doubt as to why we are incredibly excited about them, but...
by Peter Zaitsev | Jul 23, 2014 | MySQL
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...
by Vadim Tkachenko | Jul 22, 2014 | Insight for DBAs, MySQL, Percona Software
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...
by Zardosht.Kasheff | Jul 22, 2014 | MySQL
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...
by Hrvoje Matijakovic | Jul 21, 2014 | MySQL, Percona Events, Percona Software
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...
by Roman Vynar | 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...
by Stephane Combaudon | Jul 21, 2014 | Insight for DBAs, MySQL, Percona Software
I recently worked on a case where one node of a Galera cluster had its schema desynchronized with the other nodes. And that was although Total Order Isolation method was in effect to perform the schema changes. Let’s see what happened. Background For those of...
by David Busby | Jul 18, 2014 | Insight for DBAs, MySQL, Percona Services
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...
by Zardosht.Kasheff | Jul 18, 2014 | MySQL
Most of the time, our blog posts explain what’s great about the MongoDB improvements we’ve already shipped in TokuMX. Sometimes, though, it’s fun to talk about what’s coming soon, especially when user feedback would really help get the feature right. In my next...
by Bill Karwin | Jul 17, 2014 | Insight for Developers, MySQL, 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...
by Jervin Real | Jul 16, 2014 | Insight for DBAs, Insight for Developers, MySQL, Percona Software
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...
by Vadim Tkachenko | Jul 15, 2014 | MySQL, Percona Software
In my recent post, “TokuDB gotchas: slow INFORMATION_SCHEMA TABLES,” I saw a couple questions and tweets asking if we use TokuDB in production. Actually I mentioned it in that post and we also blogged about it in a couple of other recent posts: Getting to...
by Jervin Real | Jul 14, 2014 | Insight for Developers, MySQL
I had the pleasure of presenting to the PHP Users Group Philippines a few days ago about mysqlnd_ms. The mysqlnd plugin, MySQL Master Slave, is a transparent layer on top of mysqlnd extension. This allows you to do read-write splitting and slave reads load balancing...
by Martin Arrieta | Jul 11, 2014 | Insight for DBAs, MySQL
by Hrvoje Matijakovic | Jul 10, 2014 | MySQL, Percona Events, Percona Software
Percona is glad to announce the release of Percona Toolkit 2.2.9 on July 10, 2014 (downloads are available here and from the Percona Software Repositories). This release is the current GA (Generally Available) stable release in the 2.2 series. Bugs Fixed: Fixed bug...
by Vadim Tkachenko | Jul 9, 2014 | Insight for DBAs, MySQL, Percona Software
We are using Percona Server + TokuDB engine extensively in Percona Cloud Tools and getting real usage operational experience with this engine. So I want to share some findings we came across, in hope it may help someone in their work with TokuDB. So, one problem I...
