Questions tagged [durability]

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.

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