Instant Recovery with Write-Ahead Logging | Buch | 978-1-62705-554-3 | sack.de

Buch, Englisch, 85 Seiten, Paperback, Format (B × H): 187 mm x 235 mm

Reihe: Synthesis Lectures on Data Management

Instant Recovery with Write-Ahead Logging

Page Repair, System Restart, and Media Restore
Erscheinungsjahr 2014
ISBN: 978-1-62705-554-3
Verlag: Morgan & Claypool Publishers

Page Repair, System Restart, and Media Restore

Buch, Englisch, 85 Seiten, Paperback, Format (B × H): 187 mm x 235 mm

Reihe: Synthesis Lectures on Data Management

ISBN: 978-1-62705-554-3
Verlag: Morgan & Claypool Publishers


Traditional theory and practice of write-ahead logging and of database recovery techniques revolve around three failure classes: transaction failures resolved by rollback; system failures (typically software faults) resolved by restart with log analysis, “redo,” and “undo” phases; and media failures (typically hardware faults) resolved by restore operations that combine multiple types of backups and log replay.

The recent addition of single-page failures and single-page recovery has opened new opportunities far beyond its original aim of immediate, lossless repair of single-page wear-out in novel or traditional storage hardware. In the contexts of system and media failures, efficient single-page recovery enables on-demand incremental “redo” and “undo” as part of system restart or media restore operations. This can give the illusion of practically instantaneous restart and restore: instant restart permits processing new queries and updates seconds after system reboot and instant restore permits resuming queries and updates on empty replacement media as if those were already fully recovered.

In addition to these instant recovery techniques, the discussion introduces much faster offline restore operations without slowdown in backup operations and with hardly any slowdown in log archiving operations. The new restore techniques also render differential and incremental backups obsolete, complete backup commands on the database server practically instantly, and even permit taking full backups without imposing any load on the database server.
Instant Recovery with Write-Ahead Logging jetzt bestellen!

Autoren/Hrsg.


Weitere Infos & Material


- Preface
- Acknowledgments
- Introduction
- Related Prior Work
- Single-Page Recovery
- Applications of Single-Page Recovery
- Instant Restart after a System Failure
- Single-Pass Restore
- Applications of Single-Pass Restore
- Instant Restore after a Media Failure
- Multiple Failures
- Conclusions
- References
- Author Biographies


Ihre Fragen, Wünsche oder Anmerkungen
Vorname*
Nachname*
Ihre E-Mail-Adresse*
Kundennr.
Ihre Nachricht*
Lediglich mit * gekennzeichnete Felder sind Pflichtfelder.
Wenn Sie die im Kontaktformular eingegebenen Daten durch Klick auf den nachfolgenden Button übersenden, erklären Sie sich damit einverstanden, dass wir Ihr Angaben für die Beantwortung Ihrer Anfrage verwenden. Selbstverständlich werden Ihre Daten vertraulich behandelt und nicht an Dritte weitergegeben. Sie können der Verwendung Ihrer Daten jederzeit widersprechen. Das Datenhandling bei Sack Fachmedien erklären wir Ihnen in unserer Datenschutzerklärung.