The Future of Backups for DBAs
DBAs have used vendor solutions for backups for years.
- In the Oracle world RMAN has been the primary tool used for Oracle backups.
- In the MySQL world replication, InnoDB hot backup have been primary tools used for backups.
However as databases grow into the two terabyte range and larger, the old ways are just not efficient any longer. In the future you will see snapshots and split mirror backups become more prominent in large database enviroments.
Snapshots and split mirror backups offered by logical volume managers and some operating systems allow a backup to be taken in a few seconds. Higher availability requirements and time windows required to perform backups are becoming bigger issues as database servers continue to grow in size.
Snapshots and split mirror backups offered by logical volume managers and some operating systems allow a backup to be taken in a few seconds. Higher availability requirements and time windows required to perform backups are becoming bigger issues as database servers continue to grow in size.
Labels: Best Practices
posted by Unknown @ 12:27 AM
2 comments
2 Comments:
"the old ways are just not efficient any longer"
Newsflash. These tools (or at least RMAN) do actually improve over time. Block change tracking, incremental backups.
Plus the fact that volume snapshots can ONLY work if they are don in conjunction with database operations. In Oracle you would have to ensure that the tablespaces are in backup mode otherwise the Oracle database blocks may be inconsistent (as they don't map one-to-one with file blocks) and would be unusable for a point-in-time recovery.
If you stop using database tools for backup, you stop backing up your database.
Gary thanks for the input. You're right snapshots do have to be synched up with database operations. Snapshots can backup multi-terabyte systems in a few seconds.
RMAN is a great tool and most Oracle environments use it. I'm just seeing that as databases get above the 2 TB range, organizations are looking at other options.
Post a Comment
<< Home