mydumper备份恢复

比眉伴天荒 2022-03-06 13:56 359阅读 0赞

mydumper优点总结：多线程备份工具，支持文件压缩功能，支持多线程恢复，保证数据的一致性，比mysqldump要快。

[https://launchpad.net/mydumper/+download][https_launchpad.net_mydumper_download]  
yum install glib2-devel mysql-devel zlib-devel pcre-devel openssl-devel  
mysql> select version();  
±-----------+  
| version() |  
±-----------+  
| 5.6.37-log |  
±-----------+  
备份test全库：  
\-bash-4.1 m y d u m p e r − u r o o t − p r o o t − S / g g / m y s q l / d a t a / m y s q l . s o c k − B t e s t − o / g g / m y s q l / b a c k u p − b a s h − 4.1 mydumper -u root -p root -S /gg/mysql/data/mysql.sock -B test -o /gg/mysql/backup -bash-4.1 mydumper−uroot−proot−S/gg/mysql/data/mysql.sock−Btest−o/gg/mysql/backup−bash−4.1 cd /gg/mysql/backup  
\-bash-4.1$ ll  
总用量 16  
\-rw-rw-r-- 1 mysql mysql 174 3月 19 09:51 metadata  
\-rw-rw-r-- 1 mysql mysql 65 3月 19 09:51 test-schema-create.sql  
\-rw-rw-r-- 1 mysql mysql 154 3月 19 09:51 test.t-schema.sql  
\-rw-rw-r-- 1 mysql mysql 140 3月 19 09:51 test.t.sql

\-bash-4.1$ cat metadata  
Started dump at: 2019-03-19 09:51:16  
SHOW MASTER STATUS:  
Log: bin.000016  
Pos: 1136  
GTID:f96a00e1-f1e8-11e7-81a5-000c2957b7f4:1-3905  
Finished dump at: 2019-03-19 09:51:16  
\-bash-4.1$ cat test-schema-create.sql  
CREATE DATABASE `test` /*!40100 DEFAULT CHARACTER SET latin1 /;  
\-bash-4.1$  
\-bash-4.1$ cat test.t-schema.sql  
/!40101 SET NAMES binary*/;  
/*!40014 SET FOREIGN\_KEY\_CHECKS=0*/;  
CREATE TABLE `t` (  
`id` int(11) DEFAULT NULL  
) ENGINE=InnoDB DEFAULT CHARSET=latin1;  
\-bash-4.1$ cat test.t.sql  
/*!40101 SET NAMES binary*/;  
/*!40014 SET FOREIGN\_KEY\_CHECKS=0*/;  
/\*!40103 SET TIME\_ZONE=’+00:00’ \*/;  
INSERT INTO `t` VALUES  
(1),  
(2),  
(3);  
恢复数据：  
myloader -u root -p root -S /gg/mysql/data/mysql.sock - B test -o t -d /gg/mysql/backup

备份单表：  
mydumper -u root -p root -S /gg/mysql/data/mysql.sock -B test -T t -o /gg/mysql/backup

[https_launchpad.net_mydumper_download]: https://launchpad.net/mydumper/+download