3 ms·
xtrabackup does differential backups as well...is there another advantage to doing logical backups? are the diffs significantly smaller?
by wanderr 10y ago
xtrabackup does differential backups as well...is there another advantage to doing logical backups? are the diffs significantly smaller?
- evanelias 10y agoYes, 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.
- jivid 10y agoIn 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.