- the backup compression feature only applies to InnoDB tables.
- when InnoDB tablespace files are compressed during backup, they receive the extension .ibz rather than the usual .ibd extension.
- you can only use the --compress option for full backups, not for incremental backups.
MySQL Enterprise Backup (MEB) Compress Option
I have used compression tools before and was interested to understand a little more about MEB's use of compression. Jumping straight in, here are a couple of points to consider:
MySQL 5.6 Transportable Tablespaces Example
Transportable tablespaces allows copying individual
InnoDB
tables from
one MySQL instance to another.Here is a basic example of it's usage.
Oracle and Flashback Retention
Interestingly, I had a database that was running a large load of data. I was running across issues with space.
Subscribe to:
Posts (Atom)