Many databases implement durability by writing all transactions into a transaction log that can be played back to recreate the system state right before a failure. A transaction can only be deemed committed after it is safely in the log.
Questions tagged [durability]
45 questions
2
votes
1 answer
what does Durability mean actually in DBMS?
From Durability
Once a user issues a commit command, then the transaction is first
written to the database files stored on a non-volatile medium such as
a hard disk, which is done before confirming to the user that the save
has occurred. If a…

scott miles
- 1,511
- 2
- 21
- 36
2
votes
1 answer
RabbitMQ Durability
I'm using rabbitMQ on docker.
When executing the rabbitmq, I want to set the message durability (durable/transient).
Is there any way to set up durability? (except when declare Queue and Exchange)

hyeyoung
- 87
- 10
2
votes
4 answers
How do in-memory databases provide durability?
More specifically, are there any databases that don't require secondary storage (e.g. HDD) to provide durability?
Note:This is a follow up of my earlier question.

Enno Shioji
- 26,542
- 13
- 70
- 109
1
vote
1 answer
Is ftruncate considered a "write operation" for the purposes of O_SYNC?
When writing to a file opened with O_SYNC, the data (and metadata) is guaranteed to be written to persistent storage when the write call returns, and no explicit fsync call is needed.
Is the same true for ftruncate? Or do I still need to call fsync…

yuri kilochek
- 12,709
- 2
- 32
- 59
1
vote
1 answer
MongoDB: When Primary fails
I would like to understand what guarantees, if any does MongoDB provide as it relates to durability of data in a scenarios when Primary fails permanently or temporarily, or when it becomes separated at the network level from the rest of the replica…

Y.S.
- 35
- 6
1
vote
1 answer
Are there any databases really durable?
I was reading http://www.h2database.com/html/advanced.html#durability_problems and i found
Some databases claim they can guarantee durability, but such claims are wrong. A durability test was run against H2, HSQLDB, PostgreSQL, and Derby. All of…

Shreyans jain
- 559
- 6
- 18
1
vote
0 answers
Replacing multiple fdatasync() calls with a single sync() call
I have an application with thousands of files being updated. Periodically the application needs to commit the changes to the disk, and currently I am calling fdatasync(), which takes significant amount of time (minutes). [Reducing the number of…

Alexey
- 406
- 3
- 6
1
vote
0 answers
how to make every message is durable in kafka
Set log.flush.interval.messages=1.
the flush is asynchronous or synchronous? in this way, when producer client got ack, it means that the message is durable or not?

rickfeng
- 21
- 4
1
vote
1 answer
Is there any strong support for SQL database to persist rabbitmq message
We have achieved persistent mechanism with activemq as it has built in support to store messages in SQL database.
But our requirement to store message in SQL using rabbitmq but after some research we are unable to find any strong support or help for…

Yogesh Prajapati
- 4,770
- 2
- 36
- 77
1
vote
3 answers
Are there databases that bases durability on redundancy and not on persistent storage?
Sorry that the title isn't exactly obvious, but I couldn't word it better.
We are right now using a conventional DB (oracle) as our job queue, and these "jobs" are consumed by some number of nodes (machines). So the DB server gets hit by these…

Enno Shioji
- 26,542
- 13
- 70
- 109
1
vote
1 answer
Using durable subscribers with virtual topics in ActiveMQ and does Subscription Recovery Policy play any role?
I am a bit confused here on how to properly use ActiveMQ.
What i'm trying to do
I have system A which produces messages to a virtual topic. Then there's system B and C which both consume messages from the same virtual topic. There is a chance that…

Indrek Ots
- 3,701
- 1
- 19
- 24
1
vote
1 answer
Pymongo default journaling
When using pymongo (since 2.4), when doing this :
m = pymongo.MongoClient()
m.write_concern = {'w': 2}
m.write_concern['j'] = True
We specify that we want acknowledged (on 2 replicas) and journaled write.
If we mention nothing in the write concern…

scoulomb
- 630
- 2
- 7
- 19
1
vote
2 answers
What does single server durability mean?
Can some one explain Single Server Durability in detail? I came across it while I was going through MongoDB concepts.

Srik
- 155
- 1
- 1
- 6
1
vote
2 answers
PostgreSQL turn off durabilty
I want to make a script that will run postgres in-memory without durability.
I read this page: http://www.postgresql.org/docs/9.1/static/non-durability.html
But I didn't understand how I can set this parameters in script. Could you please, help…

pfedotovsky
- 711
- 2
- 10
- 23
0
votes
1 answer
Does a MongoDB write concern make assurances about previous writes?
MongoDB has configurable durability: When doing an update operation, you can specify a "write concern" to tell the system that you want the update to only be considered complete when the data has (for example) been flushed to disk and replicated to…

Thilo
- 257,207
- 101
- 511
- 656