concurrent DB access and transactons at same time??

Michael Cahill · *nix forums Guru Wannabe Joined: 26 May 2005 Posts: 219

Yes, you can have multiple processes sharing transactional
environments. Each process can also be multithreaded. That is the
Berkeley DB Transactional Data Store product, which sounds like it's
what you need.

The Concurrent Data Store product offers a simpler concurrency model
without trasactions, but it still allows multiple processes to share an
environment.

Please see this page fr more information:

http://www.sleepycat.com/products/whichproduct.shtml

Regards,
Michael.

berkeleydb_user · *nix forums beginner Joined: 16 Mar 2005 Posts: 17

am a newbie to BerkeleyDB. Can DB support transactions ie., ACID while
multiple processes or threads are accessing the database at same time.

the docs says:

To create Berkeley DB Concurrent Data Store applications, you must
first initialize an environment by calling DB_ENV->open. You must
specify the DB_INIT_CDB and DB_INIT_MPOOL flags to that method. It is
an error to specify any of the other DB_ENV->open subsystem or recovery
configuration flags, for example, DB_INIT_LOCK, DB_INIT_TXN, or
DB_RECOVER.

does it mean that i can't have transaction support at the same time
when multiple threads/processes are reading/writing the database.

thanks

Google