[SERVER-4803] Is there any way to "record" the series of DB commands that modify the database so that those commands can be reverted? Created: 28/Jan/12  Updated: 28/Jan/12  Resolved: 28/Jan/12

Status: Closed
Project: Core Server
Component/s: None
Affects Version/s: None
Fix Version/s: None

Type: Question Priority: Major - P3
Reporter: Richard Chen Assignee: Unassigned
Resolution: Done Votes: 0
Labels: None
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified

Participants:

 Description   

Is there any way to "record" the series of DB commands that modify the database so that those commands can be reverted? Assume that none of those commands are "destructive." They will only add rows/values or modify existing rows/values.

The goal of this request is to determine if it is possible to "checkpoint" the DB and then "rollback" any changes after that checkpoint if necessary.



 Comments   
Comment by Richard Chen [ 28/Jan/12 ]

Thanks! That should do it!

Comment by Eliot Horowitz (Inactive) [ 28/Jan/12 ]

You can use the replication oplog for something like this:

http://www.snailinaturtleneck.com/blog/2010/10/12/replication-internals/

Generated at Thu Feb 08 03:07:02 UTC 2024 using Jira 9.7.1#970001-sha1:2222b88b221c4928ef0de3161136cc90c8356a66.