PDA

View Full Version : Incremental backups when hosting many databases



azzegai
August 24th, 2007, 07:25 AM
Does ZRM use the '--database=<db_name>' 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

paddy
August 27th, 2007, 04:56 PM
Does ZRM use the '--database=<db_name>' 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