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.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...
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,...
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...
MariaDB 5.3.0 Beta MySQL and Percona Xtrabackup 1.6.2 releases have been announced one day apart. MariaDB 5.3.0 Beta can be downloaded here.
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...
Lynne from vBulletin, posted in vBulletin Hosting Options forum a thread with a list of questions a vBulletin user should ask a new prospective web host before selecting them for vBulletin hosting. The web host questions are more geared towards shared hosting providers who implement restrictions on server resource usage...
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.
Name: George Liu
Online Handle: eva2000
Location: Brisbane, Australia
Occupation: vBulletin.com technical support since 2001
This is personal blog and no way officially affiliated with vBulletin.com. [More...]