Results 1 to 2 of 2

Thread: Why is it necessary to backup the mysql database?

Hybrid View

  1. #1
    Join Date
    Aug 2012
    Posts
    11
    Rep Power
    3

    Default Why is it necessary to backup the mysql database?

    Hi,
    I am testing Zimbra 8 NE (single node). I read in the doc:
    MySQL Backup and Restore - Zimbra :: Wiki
    "Sites that need an extra level of redundancy for their MySQL data can use the MySQL Binary Log and mysqldump. (...) As of HELIX (version 7.x) of ZCS, there is an option to automatically run full mysqldumps as part of the nightly zmbackup (mysql_backup_retention)"

    Sorry for the naive question, but I don't understand why the proper procedure to recover from a mysql crash is not to restore the latest zimbra backup. If mysql is restored, how to be sure that the message store is synchronized with the restored dump?
    Thanks,

  2. #2
    Join Date
    Dec 2006
    Location
    Minneapolis MN
    Posts
    777
    Rep Power
    9

    Default

    That is specifically for the MySQL database. Larger sites will have that on a different high performance volume, and it is possible that the database may crash, while the rest of the server remains in tact. For a large site, if there is only a database server/volume crash, they can recover just the database much faster than absolutely everything.

    The Zimbra backups do include what is needed for the database, so it is not required to backup the database as described in that document. It's just another level of added redundancy for people who care to take it that far.
    01 Networks, LLC / Cybernetik.net
    Zimbra NE and OSS Cloud Hosting
    Shared Web Hosting
    Consulting Services

Similar Threads

  1. externel Acces to MYSQL Database
    By Pacnos in forum Administrators
    Replies: 3
    Last Post: 02-04-2010, 08:13 AM
  2. MYSQL database error
    By 3RiversTechAdmin in forum Administrators
    Replies: 2
    Last Post: 03-08-2009, 06:24 PM
  3. where is the postion of mysql database?
    By antelopeming in forum Developers
    Replies: 0
    Last Post: 05-23-2008, 04:08 AM
  4. MySQL database doesn't seem to want to get initialized
    By carllerche in forum Installation
    Replies: 2
    Last Post: 04-05-2007, 05:21 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
  •