Replicating from a higher to lower MySQL version
As we know, replication is only supported officially between consecutive major MySQL versions, and...
Pythian Blog: Data Analytics, Cloud Computing, and Database Management | Ivan Groenewold (2)
Multi Tb migration using mydumper
In this post I will explain how to transfer a multi terabyte size database between two MySQL...
Using transportable tablespaces with partitioned tables
Overview In this post I will explain how to transfer a partitioned table using transportable...
Auditing MySQL Users With McAfee Plugin
It is a common auditing requirement to log user connection events, including whether or not...
Your Xtrabackup cheat sheet
My goal in this post is to present you with examples of useful operations using xtrabackup, using...
InnoDB flushing and Linux I/O
Since documentation is not very clear to me on the topic of InnoDB flushing in combination with...
Reserved words usage in MySQL
It is not uncommon to come across MySQL databases where reserved words are in use as identifiers...
