in reply to Re: Re: Distributed DBM data storage
in thread Distributed DBM data storage

MySQL and Postgres both have "replication" facilities, which probably do what you want to do, only they've been written and tested already, and are supported in a commercial capacity should you require it.

Further, if you're using BerkleyDB, you could very easily switch to an RDBMS by tying your data to SQL instead of a flat file. Your program will hardly notice the difference. There are several examples of this sort of thing floating around, one of which is in the MySQL and mSQL book from O'Reilly. You won't be able to use any of the fancy SQL features without rewriting parts, of course, but at least this is optional.

Replies are listed 'Best First'.
Re: Re^3: Distributed DBM data storage
by agoth (Chaplain) on Jul 06, 2001 at 16:17 UTC
    Im quite happy with RDBMS as a solution, and in fact have hardly ever worked with BerkeleyDB, but the current application has:
    • Simple data i.e. key / value
    • Requirement for fast access
    • Ratio of about 8 reads to 1 update / insert
    That's why i was veering towards DB files,
    But thats an interesting point about the conversion from DB...