by Fernando Ipar | Jul 14, 2016 | MongoDB
In this post, I want to talk about MongoDB data durability options across MongoDB versions.I consider a write durable if, once confirmed by the server, it becomes permanent at the node or cluster level (ignoring catastrophic failures like all nodes on a cluster... by Fernando Ipar | Jun 14, 2016 | MongoDB
In this blog, I will discuss how I found some of my basic SQL assumptions that don’t hold true when dealing with MongoDB and non-existent collections.Coming from a MySQL background, I have some assumptions about databases that don’t apply to MongoDB (or... by Fernando Ipar | May 13, 2016 | Benchmarks, MongoDB
In this blog post, we’ll discuss how to benchmark MongoDB with sysbench.In an earlier post, I mentioned our use of sysbench-mongodb (via this fork) to run benchmarks of MongoDB servers. I now want to share our work extending sysbench to make it work with... by Fernando Ipar | Feb 26, 2016 | MongoDB
In this blog post, we’ll discuss how using Prometheus can help with monitoring MongoDB response time. I am currently comparing the performance of different storage engines on Percona Server for MongoDB, using a slightly customized version of Tim... by Fernando Ipar | Feb 1, 2016 | Benchmarks
In a recent post, Vadim compared the performance of Amazon Aurora and Percona Server on AWS. This time, I am comparing write throughput for InnoDB and TokuDB, using the same workload (sysbench oltp/update/update_non_index) and a... by Fernando Ipar | Jul 9, 2015 | Insight for DBAs, MySQL
I recently helped a customer figure out why a minor version MySQL upgrade was indicating that some tables needed to be rebuilt. The mysql_upgrade program should be run for every upgrade, no matter how big or small the version difference is, but when only the minor... by Fernando Ipar | Aug 4, 2014 | Insight for DBAs, MySQL, Webinars
Martin Arrieta and I gave an online presentation last week on “Putting MySQL Fabric To Use.” If you missed it, you can find a recording and the slides here, and the vagrant environment we used plus a transcript of the commands we ran here (be... 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... by Fernando Ipar | Jul 11, 2014 | Insight for DBAs, MySQL
by Fernando Ipar | May 30, 2014 | Insight for DBAs, MySQL
This is the third post in our MySQL Fabric series. If you missed the previous two, we started with an overall introduction, and then a discussion of MySQL Fabric’s high-availability (HA) features. MySQL Fabric was RC when we started this series,... by Fernando Ipar | May 15, 2014 | Insight for DBAs, MySQL
In our previous post, we introduced the MySQL Fabric utility and said we would dig deeper into it. This post is the first part of our test of MySQL Fabric’s High Availability (HA) functionality.Today, we’ll review MySQL Fabric’s HA... by Fernando Ipar | Apr 25, 2014 | Insight for DBAs, Insight for Developers, MySQL
While built-in replication has been a major cause for MySQL’s wide adoption, official tools to help DBAs manage replication topologies have typically been missing from the picture. The community has produced many good products to fill in this gap, but... by Fernando Ipar | Oct 29, 2013 | Insight for DBAs, Percona Events, Webinars
Next week, on Nov. 6, I will be delivering a webinar about running MySQL on Windows, with a strong focus on Linux-based sysadmins and DBAs – and how not to go crazy in the process.An interesting (and challenging!) part of working for Percona is that you never... by Fernando Ipar | Aug 9, 2013 | MySQL, Percona Software, Webinars
I’m happy to announce that the recording for my recent webinar “5 Proactive Measures to Minimize MySQL Downtime” is now available, along with the slides. They can both be found here.My webinar focused on the top 5 operational measures that prevent or... by Fernando Ipar | Jul 10, 2013 | MySQL, Percona Events, Webinars
Failure is an unavoidable part of IT life, but it does not always have to imply MySQL service downtime. In the years I have been working at Percona, I have been involved in many customer emergency cases, and I have seen a good number of problems that could have been... by Fernando Ipar | May 23, 2013 | Insight for DBAs, MySQL
I recently had to do some customer work involving the McAfee MySQL Audit Plugin and would like to share my experience in this post.Auditing user activity in MySQL has traditionally been challenging. Most data can be obtained from the slow or general log,... by Fernando Ipar | Apr 23, 2013 | MySQL
I had the chance to work on an interesting case last week, and I thought I’d share what I think is a little known goodie from Percona Toolkit for MySQL called pt-query-digest.One customer was suffering from periods of high load on their database server, leading... by Fernando Ipar | Dec 19, 2012 | Insight for DBAs, MySQL
First, a thank you to everyone who attended the webinar Today, I appreciate your time and nice comments. As promised, here are answers to questions that couldn’t be answered during the talk: Q: How do you install the tools? The manual has full details, but... by Fernando Ipar | Dec 12, 2012 | MySQL, Percona Events
On December 19th at 1 PM Eastern / 10 AM Pacific, I will be giving a webinar entitled “10 Percona Toolkit Tools Every MySQL DBA Should Know About”. As a Consultant, I make heavy use of Percona Toolkit tools while solving customers’ problems, and I... by Fernando Ipar | Jun 22, 2011 | MySQL
On July 12th at 9 AM PST I will be giving a webinar about performance implications for Hibernate and Connector/J. If you cannot attend at this time, a recorded session will be available soon after the webinar. MySQL is not only about LAMP, and a lot of people use it...