Tagged: mydumper

pigz parallel gzip compression revisited

Today, revisiting pigz – a parallel gzip compression alternative to gzip. I had a client who’s MySQL sql database backup came in at 9.9 gigabytes in size and he was running a level 9 gzip compression on the file which took ~48 minutes to run on his WHM/Cpanel powered dual...

MariaDB 5.5.24 Release working mydumper !

MariaDB 5.5.24 MySQL server was released last month and they finally released RPM packages for MariaDB 5.5 – including an official MariaDB YUM repository. I decided to test and found out if the multi-threaded MySQL backup and restore tool, mydumper worked with MariaDB 5.5.24 or if it suffered the same incompatibility...

MariaDB 5.5 RPM builds ?

MariaDB 5.5.23 has been announced as stable release since last month but there isn’t an official MariaDB 5.5 RPM available for download yet. Seems there’s problems that need to be ironed out with the official RPM builds for MariaDB 5.5.23. Update: seems official MariaDB 5.5 RPMs might be coming soon...

Web Tech Articles Recap

In the last 12 months, I have written quite a few articles which I myself keep referencing back to or linking back to for other folks. So thought I’d revisit them with an all in one listing. Hope you folks, find some of these articles useful. If you do, don’t...

MySQL Back up & Restore: Faster InnoDB database backup / restore using Mydumper and Myloader multi-threaded tools

Previous article compared MyISAM database backup methods for mysqldump and multi-threaded Mydumper/Myloader tools. This time testing a full 100% InnoDB database and comparing InnoDB backup and restore times with mysqldump non-blocking (–single-transaction ) backup and restore with Mydumper and Myloader multi-threaded backup tools. When it comes to backup and restores,...

Faster alternative to MySQL mysqldump backup & restore with multi-threaded Mydumper & Myloader tool

Mydumper is a multi-threaded MySQL backup and restore tool written in C by MySQL engineers who worked for MySQL and later moved to Facebook, SkySQL etc. Mydumper claims to be up to 10x times faster than mysqldump for backups. I’ve even suggested to WHM/Cpanel folks to incorporate Mydumper for faster...

mysqlmybackup.sh – multi feature MySQL database backup and restore script with Percona XtraBackup & Mydumper tool support

mysqlmybackup.sh started out as a mysqldump based MySQL back up script which I started on June 20th, 2011. I compiled the script based on the modified MySQL mysqldump backup script by Vivek Gite and merged it with Zarafa.com script. Script Evolution: The script has since evolved from the original Vivek...