Next Saturday, 8 November 2014, at 19:30 I will be speaking about MySQL Fabric for PyConES 2014 (the Spanish version of the PyCon), the annual meeting point for all developers and enthusiasts of Python in Spain. While I say myself
My Tutorial on Query Optimization for Percona Live London 2014 (and Important Information If You Wish to Attend)
Monday next week, on November 3rd, I will be delivering a tutorial on the greatest MySQL European Conference, the Percona Live London 2014. The topic is a natural continuation of the one I delivered last year on the same venue,
Testing the Fastest Way to Import a Table into MySQL (and some interesting 5.7 performance results)
As I mentioned on my last post, where I compared the default configurations options in 5.6 and 5.7, I have been doing some testing for a particular load in several versions of MySQL. What I have been checking is different
Today is the day in which MyISAM is no longer needed
Of course, this is just a catchy title. As far as I know not all system tables can be converted to InnoDB yet (e.g. grant tables), which makes the header technically false. MyISAM is a very simple engine, and that
Changes in Configuration of Global Variables between MySQL 5.6.20 and MySQL 5.7.4 “Milestone 14”
While doing some testing (that I published later here) on the still-in-development MySQL 5.7 I wanted to do some analysis on the configuration to see if the changes in performance were due to the code changes or just to the
Which Compression Tool Should I Use for my Database Backups? (Part II: Decompression)
On my post last week, I analysed some of the most common compression tools and formats, and its compression speed and ratio. While that could give us a good idea of the performance of those tools, the analysis would be
Which Compression Tool Should I Use for my Database Backups? (Part I: Compression)
This week we are talking about size, which is a subject that should matter to any system administrator in charge of the backup system of any project, and in particular database backups. I sometimes get questions about what should be
How to install MySQL 5.6 on CentOS 7
A bit of history The latest version of Red Hat Enterprise Linux, one of the most popular and respected Linux distributions in the server market, was released in June 2014, followed by CentOS 7 and Oracle Linux releases in July