Question Details

Browse

Zmanda for MySQL hot backups?

By Nigel Smith - Mar. 21, 2008

I am trying to do hot backups. I can run a mysqldump while the db is running. I noticed that Zmanda allows for hot backups and am considering using that. Any thoughts? This is for a small project that uses mysql.


Answers

Add Answer
  1. By an anonymous user on Mar. 22, 2008

    Haven't tried Zmanda, but try Innodb (http://www.innodb.com)


    2 Votes
  2. By an anonymous user on Mar. 22, 2008

    Do you use innodb tables or do you use myisam tables? Depending on which ones you use, you have different options.


    1 Votes
  3. By an anonymous user on Mar. 22, 2008

    If you use innodb tables, you can use innodb hot backup (link mentioned above).


    1 Votes
  4. By Nigel Smith on Mar. 23, 2008

    Thank you! Well, my database has a mix of InnoDB and MyISAM tables. I have looked at InnoDB hot backup, but I don't think those apply. Currently, I take a backup while the database is running using mysql dump. I'm not sure if my data integrity will be maintained in case a table is updated when mysqldump is running. I do not want to take my database offline when running the backup (hence, the need for hot backups).


    Thanks.


    1 Votes
  5. By an anonymous user on Oct. 24, 2008

    if you want to dump and be consistent, use the --master-data switch.


    Be sure to note the DB is effectively read locked for the duration of the dump however.


    The added benefit of this is that you know the checkpoint on which the backup was made and can roll logs forward from there.


    0 Votes
  6. By wadise wu on Oct. 25, 2008

    google team has an opensource for hot backup mysql.. but i forget its name..you can google it


    0 Votes
Share your knowledge