Is there any way to atomically update two collections in MongoDB?

You cannot remove documents from two collections at the same instant. What you can do is use a findAndModify() to remove a document so you get its exact state before it was deleted. This will take care of your unread count problem.


There are lots of answers here, but I want to fill in all of the blanks here:

Is there any way to atomically update two collections in MongoDB?

No. Atomic update of two collections is effectively a transaction. MongoDB does not support transactions across collections or even within a collection.

MongoDB provides several modifiers that are atomic on a single document. So you can increment several different variables at once ($inc). Though there are some limitations here, you cannot perform two different operations on a single property.

Is there a way to conditionally change something in one collection based on results of other collection in one shot?

There are some documents here on atomic updates in general. However, what you really need is a queue and some form of two-phase commit or you need triggers.

Triggers have not yet been implemented, so it's not really an option in your case.

There is a possibility that the message will be marked as read in between those actions, then I will decrease "unread" counts incorrectly.

At this point, you have a couple of different strategies for making this behave with some level of consistency. Frankly, based on your description, you may want to investigate building a simple queue that updates your totals.


No, unfortunately this isn't possible. MongoDB only supports atomic operations within the scope of a single document. There's no way to perform a transactional operation across multiple documents, even if they're in the same collection.