Results 1 to 2 of 2

Thread: Incremental backups when hosting many databases

  1. #1

    Default Incremental backups when hosting many databases

    Does ZRM use the '--database=' option to mysqlbinlog when doing incremental backups when using separate backup sets for each database or does the entire binary log get backed up for each backup set? This obviously assumes that incremental backups use mysqlbinlog at all and don't just do backups of the binary log files.

    So say I have two databases, each one configured to be backed up using a different backup set. Database A is a high transaction volume database (lets say it generates 90% of transactions logged to the binary log), whereas database B is a low transaction volume database. Will the incremental backup of B also include all transactions relating to A? Is it even possible to use ZRM in such a way that separate incremental backups are maintained for separate databases, each configured as a separate backup set?

    Thanks
    Last edited by azzegai; August 24th, 2007 at 08:10 AM.

  2. #2
    Join Date
    Oct 2005
    Posts
    1,559

    Default

    Quote Originally Posted by azzegai View Post
    Does ZRM use the '--database=' option to mysqlbinlog when doing incremental backups when using separate backup sets for each database or does the entire binary log get backed up for each backup set? This obviously assumes that incremental backups use mysqlbinlog at all and don't just do backups of the binary log files.
    Binary logs are kept for each MySQL server. Entire binary log will be backed up as part of incremental backup for each backup set.

    So say I have two databases, each one configured to be backed up using a different backup set. Database A is a high transaction volume database (lets say it generates 90% of transactions logged to the binary log), whereas database B is a low transaction volume database. Will the incremental backup of B also include all transactions relating to A? Is it even possible to use ZRM in such a way that separate incremental backups are maintained for separate databases, each configured as a separate backup set?

    Thanks
    Only way to do this is to use different MySQL servers for each database.

    Paddy

Posting Permissions

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