Extensible Storage Engine - Logging and Crash Recovery

Logging and Crash Recovery

The logging and recovery feature of ESE supports guaranteed data integrity and consistency in the event of a system crash. Logging is the process of redundantly recording database update operations in a log file. The log file structure is very robust against system crashes. Recovery is the process of using this log to restore databases to a consistent state after a system crash.

Transaction operations are logged and the log is flushed to disk during each commit to transaction level 0. This allows the recovery process to redo updates made by transactions which commit to transaction level 0, and undo changes made by transactions which did not commit to transaction level 0. This type of recovery scheme is often referred to as a ‘roll-forward/roll-backward’ recovery scheme. Logs can be retained until the data is safely copied via a backup process described below, or logs can be reused in a circular fashion as soon as they are no longer needed for recovery from system crash. Circular logging minimizes the amount of disk space needed for the log but has implications on the ability to recreate a data state in the event of a media failure.

Read more about this topic:  Extensible Storage Engine

Famous quotes containing the words crash and/or recovery:

    At the crash of economic collapse of which the rumblings can already be heard, the sleeping soldiers of the proletariat will awake as at the fanfare of the Last Judgment and the corpses of the victims of the struggle will arise and demand an accounting from those who are loaded down with curses.
    Karl Liebknecht (1871–1919)

    Walking, and leaping, and praising God.
    Bible: New Testament Acts, 3:8.

    Referring to the miraculous recovery of a lame man, through the intervention of Peter.