[Users] ZCS OSE Hot DR Solutions

[Adam Cody]

Hey everyone,

 IMO - this "documentation" or "code" should be put out on github under the zeta alliance. Many have tried to do this and IMO they never fully documented their solution as being reliable. It would be a good project, again IMO, now that Synacor/Zimbra is allowing their channel to do support for f/loss. We could get some traction on this project.

Regards,
Adam



----- Original Message -----
From: "Andrew Martin" <amartin at xes-inc.com>
To: users at lists.zetalliance.org
Sent: Monday, September 26, 2016 3:42:03 PM
Subject: [Users] ZCS OSE Hot DR Solutions

Hello,

I am running ZCS OSE 8.7 on Ubuntu 14.04 in a single-node configuration. My 
current backup/DR strategy is to perform these steps nightly:
* zmcontrol stop
* rsync -avHKS --delete /opt/zimbra backupserver:/opt/zimbra
* zmcontrol start
* mysqldump all tables (just as a precaution)
* zmslapcat (just as a precaution)

This works pretty well, but it has a couple disadvantages:
* requires zimbra downtime every night
* RPO of 24 hours

It would be nice to have an OSE hot backup solution as well, nothing as fancy
as ZExtras Backup (which does per-account restore), but just a basic DR
solution. It seems like this would be possible with a combination of the
following:
* rsync /opt/zimbra to catch index, misc files, and store
* zmslapcat to get the LDAP database
* Percona XtraBackup for consistent MySQL backups

The challenge would be making sure that the database backup and 
/opt/zimbra/store were in sync.

Has anyone developed a solution for OSE hot DR backups, or something similar to
what I've described?

Thanks,

Andrew