取代mysqldump的新工具mydumper
下载地址：https://launchpadlibrarian.net/225370879/mydumper-0.9.1.tar.gz# yum -y install glib2-devel mysql-devel zlib-devel pcre-devel cmake
# tar xf mydumper-0.9.1.tar.gz
# cd mydumper-0.9.1
# cmake .
# make && make install
解压的安装的mysql server 报错：
# mydumper -h
mydumper: error while loading shared libraries: libmysqlclient.so.18: cannot open shared object file: No such file or directory
拷贝库到/lib64/下：
# cp /home/data/mysql-5.6.32/lib/libmysqlclient.so.18 /lib64/
备份性能比较：
# time mydumper -u root -p "123456"-B zabbix -o /usr/local/src/bak/1/
real 0m2.733s
user 0m1.075s
sys 0m0.158s
# time /data/mysql-5.6.32/bin/mysqldump -u root -p"123456" -q --single-transaction -B zabbix > zabbix.sql
real 0m15.019s
user 0m1.495s
sys 0m0.271s
用myloader导入该XXDB数据库
# time myloader -u root -p 123456 -d /usr/local/src/bak/1/
导出 mydumper 要比mysqldump快一倍
导入 myloader 要比自带的mysql快一倍
页:
[1]