Tagged: mysqldump

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...

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...

It’s official, Percona XtraBackup does not support MariaDB 5.2 & 5.3 MySQL yet

Percona XtraBackup tool for non-blocking MySQL InnoDB and XtraDB backups has been out for a while now. There’s been an outstanding bug #733665 logged since March, 2011 with regards to Percona XtraBackup’s innobackupex-1.5.1 script not detecting MariaDB 5.2 and now 5.3 based MySQL forks. When you run Percona XtraBackup’s innobackupex-1.5.1...

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...

MySQL Backup Bash Shell Script

Which MySQL backup scripts do I use ? The question has come up a few times already so decided to post what MySQL backup script I am using right now. I’ve used quite a few different ones all using some form of mysqldump.