利用xtrabackup 全量备份的mysql5.6.40实例的100G的数据恢复MySQL5.7.24实例上到单实例消耗的时间:
服务器的环境如下:
dell r620 双颗CPU,单核心是12核心,内存是72G ,硬盘伪sata接口的企业级的SSD固态硬盘:500G
固态盘型号如下:
PD Type: SATA
Raw Size: 465.761 GB [0x3a386030 Sectors]
Inquiry Data: S3Z3NB0K116201W Samsung SSD 860 EVO 500GB RVT01B6Q
Device Speed: 6.0Gb/s
消耗时间测试演示如下:
[root@e ~]# time innobackupex --apply-log /data/backup/db_3306_20190812
InnoDB: Shutdown completed; log sequence number 143003422760
190815 16:53:30 completed OK!
real 0m13.475s
user 0m0.445s
sys 0m3.182s
[root@e db_3306_20190812]# time innobackupex --defaults-file=/data/mysql5.7/my3306.cnf --copy-back /data/backup/db_3306_20190812/
190815 17:12:06 [01] Copying ./ib_buffer_pool to /data/mysql5.7/3306/data/ib_buffer_pool
190815 17:12:06 [01] ...done