Am 10.04.2017 um 19:44 schrieb Tim Kersten:
Hi folks,
Does anyone here use page compression ( https://mariadb.com/kb/en/mariadb/compression/ ) in production? (Or know folks who do?)
What prompted my question was seeing that XtraBackup is not supported when using page compression. Given the popularity of the XtraBackup, I'm left wondering if there's some other backup strategy people use (especially since it's also used to sync and provision slaves), or if page compression is simply not used by folks who have master/slave setups, or perhaps don't require backups?
well, for init salves i just rsync the master hot, the stop the master and do a second rsync for at least a decade, the downtime is short and it's completly scriptable (and delete existing binlogs in case you re-init a slave, the whole process scritable too) and for backups i just shutdown a slave instance, rsync the datadir to the backup location and start the slave again - no tools need, just some lines of shellscripts