[pybsddb] Snapshotting / replicating bdb

[andrew]

Excellent, thanks for that, Jesus. Looks like copying the database files
is the way to go.

Cheers, Andrew.

On Fri, 2009-05-22 at 13:06 +0200, Jesus Cea wrote:
> -----BEGIN PGP SIGNED MESSAGE-----
> Hash: SHA1
> 
> andrew wrote:
> > The
> > production databases are under constant load, and when I try to run a
> > table scan of one of them (2M objects) it tends to kill the database
> > for some unknown reason. Hence I want to try doing this analysis
> > against a separate, readonly version.

(snip)

> I would use the "copy" approach :).
> 
> If you have a "decent" operating system, like Solaris 10 under ZFS, you
> can snapshot&clone your database live, with zero overhead and only a
> couple of seconds, independently of the size of it. Then you run your
> read-only code in the clone, and when done you delete the clone and the
> snapshot, all in seconds and with your main application running live.
> This is what I actually use daily.