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