Can someone provide information on how to replicate the Zimbra MySQL databases to a secondary Zimbra server set as a cold standby? I guess we could always manually import the latest backup but that wouldn't be optimal.
I just did a check on mysql.com and found this document, but I doubt it would be easy to do since Zimbra appears to create new databases for each mailbox - such as mboxgroup1 - and I have around 50 right now and it may grow.
MySQL :: Re: Adding Multiple Databases to replication... This is How...
and here is the helpful how-to for one MySQL db replication:
How To Set Up Database Replication In MySQL | HowtoForge - Linux Howtos and Tutorials
Thanks for sharing your experience on this.