Results 1 to 3 of 3

Thread: MySQL replication for Zimbra

  1. #1
    msallee is offline Intermediate Member
    Join Date
    May 2009
    Location
    Boulder CO
    Posts
    16
    Rep Power
    6

    Default MySQL replication for Zimbra

    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.

  2. #2
    Rich Graves is offline Outstanding Member
    Join Date
    Jan 2007
    Location
    Minnesota
    Posts
    718
    Rep Power
    9

    Default

    Not a useful thing to do. MySQL is only one part of the system.

    You really need to replicate all of /opt/zimbra, data/amavisd/tmp and logs being the only exceptions that come to mind. And you need to get a point-in-time consistent copy. If you have a big budget, use a replicating SAN; a small budget and adequate expertise, DRDB or one of the free(-ish) NAS/iSCSI distributions; no budget, accept that the best you can do is scripted nightly cold backups, using LVM snaphsots to catch the filesystem in a quiet state.

  3. #3
    msallee is offline Intermediate Member
    Join Date
    May 2009
    Location
    Boulder CO
    Posts
    16
    Rep Power
    6

    Default

    Thanks for the suggestions on the best ways to replicate the servers. The reason I asked about this is that creating a clustered file system on a SAN will not allow me to test upgrades, patches without changing the whole system at once, thus the motivation to have a cold standby.

    Just for reference, I did find a script that shows how to copy over the MySQL dbs: the script dumprestore.sh at:

    Harley77-Backup - Zimbra :: Wiki

    which shows how to use a loop to back up the zimbra and the mbox MySQL dbs and restore them.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Zimbra fails after working for 2 weeks
    By Linsys in forum Administrators
    Replies: 10
    Last Post: 10-07-2008, 12:42 AM
  2. [SOLVED] Install Problem in Ubuntu 6.06 Server
    By xtimox in forum Installation
    Replies: 16
    Last Post: 03-27-2008, 09:36 AM
  3. MySQL Logger Replication Files
    By rsharpe in forum Administrators
    Replies: 0
    Last Post: 10-30-2006, 07:00 AM
  4. Message blobs in Mysql, easy replication?
    By kbaker in forum Developers
    Replies: 3
    Last Post: 02-08-2006, 11:43 PM
  5. Can't start MySQL to init db - Gentoo
    By fak3r in forum Installation
    Replies: 3
    Last Post: 10-10-2005, 06:59 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •