News for hackers. Stuff that matters.

A comment on Continuous MySQL backup validation: Restoring backups. Parent comment

Re:Continuous MySQL backup validation: Restoring backups by wanderr on Saturday October 29, 2016 @01:16AM (#12822735)
xtrabackup does differential backups as well...is there another advantage to doing logical backups? are the diffs significantly smaller?
[ Parent | on HN ]
Re:Continuous MySQL backup validation: Restoring backups by jivid on Sunday October 30, 2016 @12:08PM (#12830527)
In addition to what evanelias said, a logical dump also means we can load it into a MySQL instance running a different storage engine as well. In our case, it allows us to take a mysqldump from an InnoDB instance and load it into a MyRocks instance if we wish.
[ Parent | on HN ]
Re:Continuous MySQL backup validation: Restoring backups by evanelias on Sunday October 30, 2016 @02:13AM (#12828429)
Yes, logical backups are smaller due to lack of index overhead. And since logical backups are textual, they can also be used for other clever purposes, such as ETL pipelines.
[ Parent | on HN ]