[Users] ZCS OSE Hot DR Solutions

[Andrew Martin]

----- Original Message -----
> From: "Andreas Wolske" <andreas.wolske at managedhosting.de>
> To: gebhardt at openfactory.ch
> Cc: "users" <users at lists.zetalliance.org>
> Sent: Tuesday, September 27, 2016 9:21:42 AM
> Subject: Re: [Users] ZCS OSE Hot DR Solutions

> ----- Am 27. Sep 2016 um 15:46 schrieb  gebhardt at openfactory.ch:
> 
>> Personally, I only know of one solution that does actual hot backups of
>> mysql properly and that's r1soft - that's what we use.
> 
> We use Percona XtraBackup:
> https://www.percona.com/software/mysql-database/percona-xtrabackup
> for MySQL Hot Backups. There's extensive Documentation and ready to run
> Scripts available: https://www.percona.com/doc/percona-xtrabackup/2.2/index.html
> 
> HTH
> 
Andreas,

Thanks, I had considered using XtraBackup as well, however you still have
the problem of the time period between when XtraBackup runs and when /opt/zimbra/store
is saved off. Unless these are coordinated, you could end up with some message
metadata in the db which doesn't have a corresponding file in /opt/zimbra/store
or vise versa. How do you ensure that the backup is fully self-consistent?

Thanks,

Andrew