I am backuping database by online backup percona xtrabackup and binlog. My data is about 16G. I scheduled to do a full backup by xtrabackup. Binlog is for point in time recovery. Backup is OK.
When I make a disaster plan, I make a try to test recovery. I see the restore of full backup is so quick. It is about 2 minutes. But when I do point in time recovery using binlog is so slow. It takes more 30 minutes.
This is the way I follow to do point in time recovery:
cat xtrabackup_binlog_info
mysql-bin.000004 413 0-88-28524789
mysql-bin.000004 is also the lastest binlog.
sudo mysqlbinlog mysql-bin.000004 --start-position=413 | mysql -u root -p
This database is very critical. I need to recover as quick as possible. More 30 mins is so much. How to improve the speed of point in time recovery ?
Aucun commentaire:
Enregistrer un commentaire