|
From: John V. S. <js...@gm...> - 2008-11-05 07:32:17
|
Nicholas Goodman wrote: > If there was a way to, as part of the label creation logic, create a > snapshot of the catalog at that point in time it could make hot > backups/moving/etc easier. As a warehouse user, knowing that > absolutely, 100% hot backups are not really needed, the label feels like > it could be part of a great asynchronous backup/movement/replication/etc > framework. Create the label and a scheduled process simply periodically > creates backups "up to" the latest label (but not current which is more > complicated. Have you checked out Zelaine's backup spec? http://pub.eigenbase.org/wiki/LucidDbBackupRestore This is already available for testing in the 0.7.5 prerelease, and includes hot and incremental backup. It should already be possible to use incremental for replication too. If you kick off a backup immediately after creating a label, I think you already get pretty much what you're after, right? JVS |