Instant recovery with write-ahead logging: page repair, system restart, media restore, and system failover
Traditional theory and practice of write-ahead logging and of database recovery focus on three failure classes: transaction failures (typically due to deadlocks) resolved by transaction rollback; system failures (typically power or software faults) resolved by restart with log analysis, "redo,&...
Gespeichert in:
| Hauptverfasser: | , , |
|---|---|
| Format: | Elektronisch E-Book |
| Sprache: | English |
| Veröffentlicht: |
[San Rafael, California]
Morgan & Claypool Publishers
[2016]
|
| Ausgabe: | Second edition |
| Schriftenreihe: | Synthesis lectures on data management
#44 |
| Schlagworte: | |
| Online-Zugang: | Volltext |
| Zusammenfassung: | Traditional theory and practice of write-ahead logging and of database recovery focus on three failure classes: transaction failures (typically due to deadlocks) resolved by transaction rollback; system failures (typically power or 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 the 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 the context of node and network failures, instant restart and instant restore combine to enable practically instant failover from a failing database node to one holding merely an out-of-date backup and a log archive, yet without loss of data, updates, or transactional integrity. In addition to these instant recovery techniques, the discussion introduces self-repairing indexes and much faster offline restore operations, which impose no slowdown in backup operations and hardly any slowdown in log archiving operations. The new restore techniques also render differential and incremental backups obsolete, complete backup commands on a database server practically instantly, and even permit taking full up-to-date backups without imposing any load on the database server. Compared to the first version of this book, this second edition adds sections on applications of single-page repair, instant restart, single-pass restore, and instant restore. Moreover, it adds sections on instant failover among nodes in a cluster, applications of instant failover, recovery for file systems and data files, and the performance of instant restart and instant restore |
| Beschreibung: | Part of: Synthesis digital library of engineering and computer science Title from PDF title page (viewed on May 13, 2016) |
| Beschreibung: | 1 Online-Resource (xvii, 113 Seiten) Illustrationen |
| ISBN: | 9781627054201 |
| DOI: | 10.2200/S00710ED2V01Y201603DTM044 |
Internformat
MARC
| LEADER | 00000nmm a2200000zcb4500 | ||
|---|---|---|---|
| 001 | BV046427542 | ||
| 003 | DE-604 | ||
| 005 | 20211125 | ||
| 007 | cr|uuu---uuuuu | ||
| 008 | 200217s2016 |||| o||u| ||||||eng d | ||
| 020 | |a 9781627054201 |c ebook |9 978-1-62705-420-1 | ||
| 024 | 7 | |a 10.2200/S00710ED2V01Y201603DTM044 |2 doi | |
| 035 | |a (ZDB-105-MCS)7464099 | ||
| 035 | |a (OCoLC)1141121398 | ||
| 035 | |a (DE-599)BVBBV046427542 | ||
| 040 | |a DE-604 |b ger |e rda | ||
| 041 | 0 | |a eng | |
| 049 | |a DE-83 | ||
| 082 | 0 | |a 005.86 |2 23 | |
| 084 | |a ST 274 |0 (DE-625)143641: |2 rvk | ||
| 100 | 1 | |a Graefe, Goetz |e Verfasser |0 (DE-588)106622496X |4 aut | |
| 245 | 1 | 0 | |a Instant recovery with write-ahead logging |b page repair, system restart, media restore, and system failover |c Goetz Graefe, Wey Guy, Caetano Sauer |
| 250 | |a Second edition | ||
| 264 | 1 | |a [San Rafael, California] |b Morgan & Claypool Publishers |c [2016] | |
| 264 | 4 | |c © 2016 | |
| 300 | |a 1 Online-Resource (xvii, 113 Seiten) |b Illustrationen | ||
| 336 | |b txt |2 rdacontent | ||
| 337 | |b c |2 rdamedia | ||
| 338 | |b cr |2 rdacarrier | ||
| 490 | 1 | |a Synthesis lectures on data management |v #44 | |
| 500 | |a Part of: Synthesis digital library of engineering and computer science | ||
| 500 | |a Title from PDF title page (viewed on May 13, 2016) | ||
| 520 | |a Traditional theory and practice of write-ahead logging and of database recovery focus on three failure classes: transaction failures (typically due to deadlocks) resolved by transaction rollback; system failures (typically power or 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 the 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. | ||
| 520 | |a 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 the context of node and network failures, instant restart and instant restore combine to enable practically instant failover from a failing database node to one holding merely an out-of-date backup and a log archive, yet without loss of data, updates, or transactional integrity. In addition to these instant recovery techniques, the discussion introduces self-repairing indexes and much faster offline restore operations, which impose no slowdown in backup operations and hardly any slowdown in log archiving operations. | ||
| 520 | |a The new restore techniques also render differential and incremental backups obsolete, complete backup commands on a database server practically instantly, and even permit taking full up-to-date backups without imposing any load on the database server. Compared to the first version of this book, this second edition adds sections on applications of single-page repair, instant restart, single-pass restore, and instant restore. Moreover, it adds sections on instant failover among nodes in a cluster, applications of instant failover, recovery for file systems and data files, and the performance of instant restart and instant restore | ||
| 650 | 4 | |a Data recovery (Computer science) | |
| 650 | 4 | |a Data logging | |
| 650 | 0 | 7 | |a Wiederherstellung |g Informatik |0 (DE-588)4177289-1 |2 gnd |9 rswk-swf |
| 650 | 0 | 7 | |a Datenerfassung |0 (DE-588)4011123-4 |2 gnd |9 rswk-swf |
| 689 | 0 | 0 | |a Wiederherstellung |g Informatik |0 (DE-588)4177289-1 |D s |
| 689 | 0 | 1 | |a Datenerfassung |0 (DE-588)4011123-4 |D s |
| 689 | 0 | |5 DE-604 | |
| 700 | 1 | |a Guy, Wey |e Verfasser |0 (DE-588)1066224994 |4 aut | |
| 700 | 1 | |a Sauer, Caetano |e Verfasser |0 (DE-588)1066225028 |4 aut | |
| 776 | 0 | 8 | |i Erscheint auch als |n Druck-Ausgabe |z 978-1-62705-872-8 |
| 830 | 0 | |a Synthesis lectures on data management |v #44 |w (DE-604)BV036731811 |9 44 | |
| 856 | 4 | 0 | |u https://doi.org/10.2200/S00710ED2V01Y201603DTM044 |x Verlag |z URL des Erstveröffentlichers |3 Volltext |
| 912 | |a ZDB-105-MCS |a ZDB-105-MCDM | ||
| 999 | |a oai:aleph.bib-bvb.de:BVB01-031839845 | ||
Datensatz im Suchindex
| _version_ | 1804180976760258560 |
|---|---|
| any_adam_object | |
| author | Graefe, Goetz Guy, Wey Sauer, Caetano |
| author_GND | (DE-588)106622496X (DE-588)1066224994 (DE-588)1066225028 |
| author_facet | Graefe, Goetz Guy, Wey Sauer, Caetano |
| author_role | aut aut aut |
| author_sort | Graefe, Goetz |
| author_variant | g g gg w g wg c s cs |
| building | Verbundindex |
| bvnumber | BV046427542 |
| classification_rvk | ST 274 |
| collection | ZDB-105-MCS ZDB-105-MCDM |
| ctrlnum | (ZDB-105-MCS)7464099 (OCoLC)1141121398 (DE-599)BVBBV046427542 |
| dewey-full | 005.86 |
| dewey-hundreds | 000 - Computer science, information, general works |
| dewey-ones | 005 - Computer programming, programs, data, security |
| dewey-raw | 005.86 |
| dewey-search | 005.86 |
| dewey-sort | 15.86 |
| dewey-tens | 000 - Computer science, information, general works |
| discipline | Informatik |
| doi_str_mv | 10.2200/S00710ED2V01Y201603DTM044 |
| edition | Second edition |
| format | Electronic eBook |
| fullrecord | <?xml version="1.0" encoding="UTF-8"?><collection xmlns="http://www.loc.gov/MARC21/slim"><record><leader>04489nmm a2200553zcb4500</leader><controlfield tag="001">BV046427542</controlfield><controlfield tag="003">DE-604</controlfield><controlfield tag="005">20211125 </controlfield><controlfield tag="007">cr|uuu---uuuuu</controlfield><controlfield tag="008">200217s2016 |||| o||u| ||||||eng d</controlfield><datafield tag="020" ind1=" " ind2=" "><subfield code="a">9781627054201</subfield><subfield code="c">ebook</subfield><subfield code="9">978-1-62705-420-1</subfield></datafield><datafield tag="024" ind1="7" ind2=" "><subfield code="a">10.2200/S00710ED2V01Y201603DTM044</subfield><subfield code="2">doi</subfield></datafield><datafield tag="035" ind1=" " ind2=" "><subfield code="a">(ZDB-105-MCS)7464099</subfield></datafield><datafield tag="035" ind1=" " ind2=" "><subfield code="a">(OCoLC)1141121398</subfield></datafield><datafield tag="035" ind1=" " ind2=" "><subfield code="a">(DE-599)BVBBV046427542</subfield></datafield><datafield tag="040" ind1=" " ind2=" "><subfield code="a">DE-604</subfield><subfield code="b">ger</subfield><subfield code="e">rda</subfield></datafield><datafield tag="041" ind1="0" ind2=" "><subfield code="a">eng</subfield></datafield><datafield tag="049" ind1=" " ind2=" "><subfield code="a">DE-83</subfield></datafield><datafield tag="082" ind1="0" ind2=" "><subfield code="a">005.86</subfield><subfield code="2">23</subfield></datafield><datafield tag="084" ind1=" " ind2=" "><subfield code="a">ST 274</subfield><subfield code="0">(DE-625)143641:</subfield><subfield code="2">rvk</subfield></datafield><datafield tag="100" ind1="1" ind2=" "><subfield code="a">Graefe, Goetz</subfield><subfield code="e">Verfasser</subfield><subfield code="0">(DE-588)106622496X</subfield><subfield code="4">aut</subfield></datafield><datafield tag="245" ind1="1" ind2="0"><subfield code="a">Instant recovery with write-ahead logging</subfield><subfield code="b">page repair, system restart, media restore, and system failover</subfield><subfield code="c">Goetz Graefe, Wey Guy, Caetano Sauer</subfield></datafield><datafield tag="250" ind1=" " ind2=" "><subfield code="a">Second edition</subfield></datafield><datafield tag="264" ind1=" " ind2="1"><subfield code="a">[San Rafael, California]</subfield><subfield code="b">Morgan & Claypool Publishers</subfield><subfield code="c">[2016]</subfield></datafield><datafield tag="264" ind1=" " ind2="4"><subfield code="c">© 2016</subfield></datafield><datafield tag="300" ind1=" " ind2=" "><subfield code="a">1 Online-Resource (xvii, 113 Seiten)</subfield><subfield code="b">Illustrationen</subfield></datafield><datafield tag="336" ind1=" " ind2=" "><subfield code="b">txt</subfield><subfield code="2">rdacontent</subfield></datafield><datafield tag="337" ind1=" " ind2=" "><subfield code="b">c</subfield><subfield code="2">rdamedia</subfield></datafield><datafield tag="338" ind1=" " ind2=" "><subfield code="b">cr</subfield><subfield code="2">rdacarrier</subfield></datafield><datafield tag="490" ind1="1" ind2=" "><subfield code="a">Synthesis lectures on data management</subfield><subfield code="v">#44</subfield></datafield><datafield tag="500" ind1=" " ind2=" "><subfield code="a">Part of: Synthesis digital library of engineering and computer science</subfield></datafield><datafield tag="500" ind1=" " ind2=" "><subfield code="a">Title from PDF title page (viewed on May 13, 2016)</subfield></datafield><datafield tag="520" ind1=" " ind2=" "><subfield code="a">Traditional theory and practice of write-ahead logging and of database recovery focus on three failure classes: transaction failures (typically due to deadlocks) resolved by transaction rollback; system failures (typically power or 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 the 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. </subfield></datafield><datafield tag="520" ind1=" " ind2=" "><subfield code="a">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 the context of node and network failures, instant restart and instant restore combine to enable practically instant failover from a failing database node to one holding merely an out-of-date backup and a log archive, yet without loss of data, updates, or transactional integrity. In addition to these instant recovery techniques, the discussion introduces self-repairing indexes and much faster offline restore operations, which impose no slowdown in backup operations and hardly any slowdown in log archiving operations. </subfield></datafield><datafield tag="520" ind1=" " ind2=" "><subfield code="a">The new restore techniques also render differential and incremental backups obsolete, complete backup commands on a database server practically instantly, and even permit taking full up-to-date backups without imposing any load on the database server. Compared to the first version of this book, this second edition adds sections on applications of single-page repair, instant restart, single-pass restore, and instant restore. Moreover, it adds sections on instant failover among nodes in a cluster, applications of instant failover, recovery for file systems and data files, and the performance of instant restart and instant restore</subfield></datafield><datafield tag="650" ind1=" " ind2="4"><subfield code="a">Data recovery (Computer science)</subfield></datafield><datafield tag="650" ind1=" " ind2="4"><subfield code="a">Data logging</subfield></datafield><datafield tag="650" ind1="0" ind2="7"><subfield code="a">Wiederherstellung</subfield><subfield code="g">Informatik</subfield><subfield code="0">(DE-588)4177289-1</subfield><subfield code="2">gnd</subfield><subfield code="9">rswk-swf</subfield></datafield><datafield tag="650" ind1="0" ind2="7"><subfield code="a">Datenerfassung</subfield><subfield code="0">(DE-588)4011123-4</subfield><subfield code="2">gnd</subfield><subfield code="9">rswk-swf</subfield></datafield><datafield tag="689" ind1="0" ind2="0"><subfield code="a">Wiederherstellung</subfield><subfield code="g">Informatik</subfield><subfield code="0">(DE-588)4177289-1</subfield><subfield code="D">s</subfield></datafield><datafield tag="689" ind1="0" ind2="1"><subfield code="a">Datenerfassung</subfield><subfield code="0">(DE-588)4011123-4</subfield><subfield code="D">s</subfield></datafield><datafield tag="689" ind1="0" ind2=" "><subfield code="5">DE-604</subfield></datafield><datafield tag="700" ind1="1" ind2=" "><subfield code="a">Guy, Wey</subfield><subfield code="e">Verfasser</subfield><subfield code="0">(DE-588)1066224994</subfield><subfield code="4">aut</subfield></datafield><datafield tag="700" ind1="1" ind2=" "><subfield code="a">Sauer, Caetano</subfield><subfield code="e">Verfasser</subfield><subfield code="0">(DE-588)1066225028</subfield><subfield code="4">aut</subfield></datafield><datafield tag="776" ind1="0" ind2="8"><subfield code="i">Erscheint auch als</subfield><subfield code="n">Druck-Ausgabe</subfield><subfield code="z">978-1-62705-872-8</subfield></datafield><datafield tag="830" ind1=" " ind2="0"><subfield code="a">Synthesis lectures on data management</subfield><subfield code="v">#44</subfield><subfield code="w">(DE-604)BV036731811</subfield><subfield code="9">44</subfield></datafield><datafield tag="856" ind1="4" ind2="0"><subfield code="u">https://doi.org/10.2200/S00710ED2V01Y201603DTM044</subfield><subfield code="x">Verlag</subfield><subfield code="z">URL des Erstveröffentlichers</subfield><subfield code="3">Volltext</subfield></datafield><datafield tag="912" ind1=" " ind2=" "><subfield code="a">ZDB-105-MCS</subfield><subfield code="a">ZDB-105-MCDM</subfield></datafield><datafield tag="999" ind1=" " ind2=" "><subfield code="a">oai:aleph.bib-bvb.de:BVB01-031839845</subfield></datafield></record></collection> |
| id | DE-604.BV046427542 |
| illustrated | Not Illustrated |
| indexdate | 2024-07-10T08:44:19Z |
| institution | BVB |
| isbn | 9781627054201 |
| language | English |
| oai_aleph_id | oai:aleph.bib-bvb.de:BVB01-031839845 |
| oclc_num | 1141121398 |
| open_access_boolean | |
| owner | DE-83 |
| owner_facet | DE-83 |
| physical | 1 Online-Resource (xvii, 113 Seiten) Illustrationen |
| psigel | ZDB-105-MCS ZDB-105-MCDM |
| publishDate | 2016 |
| publishDateSearch | 2016 |
| publishDateSort | 2016 |
| publisher | Morgan & Claypool Publishers |
| record_format | marc |
| series | Synthesis lectures on data management |
| series2 | Synthesis lectures on data management |
| spelling | Graefe, Goetz Verfasser (DE-588)106622496X aut Instant recovery with write-ahead logging page repair, system restart, media restore, and system failover Goetz Graefe, Wey Guy, Caetano Sauer Second edition [San Rafael, California] Morgan & Claypool Publishers [2016] © 2016 1 Online-Resource (xvii, 113 Seiten) Illustrationen txt rdacontent c rdamedia cr rdacarrier Synthesis lectures on data management #44 Part of: Synthesis digital library of engineering and computer science Title from PDF title page (viewed on May 13, 2016) Traditional theory and practice of write-ahead logging and of database recovery focus on three failure classes: transaction failures (typically due to deadlocks) resolved by transaction rollback; system failures (typically power or 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 the 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 the context of node and network failures, instant restart and instant restore combine to enable practically instant failover from a failing database node to one holding merely an out-of-date backup and a log archive, yet without loss of data, updates, or transactional integrity. In addition to these instant recovery techniques, the discussion introduces self-repairing indexes and much faster offline restore operations, which impose no slowdown in backup operations and hardly any slowdown in log archiving operations. The new restore techniques also render differential and incremental backups obsolete, complete backup commands on a database server practically instantly, and even permit taking full up-to-date backups without imposing any load on the database server. Compared to the first version of this book, this second edition adds sections on applications of single-page repair, instant restart, single-pass restore, and instant restore. Moreover, it adds sections on instant failover among nodes in a cluster, applications of instant failover, recovery for file systems and data files, and the performance of instant restart and instant restore Data recovery (Computer science) Data logging Wiederherstellung Informatik (DE-588)4177289-1 gnd rswk-swf Datenerfassung (DE-588)4011123-4 gnd rswk-swf Wiederherstellung Informatik (DE-588)4177289-1 s Datenerfassung (DE-588)4011123-4 s DE-604 Guy, Wey Verfasser (DE-588)1066224994 aut Sauer, Caetano Verfasser (DE-588)1066225028 aut Erscheint auch als Druck-Ausgabe 978-1-62705-872-8 Synthesis lectures on data management #44 (DE-604)BV036731811 44 https://doi.org/10.2200/S00710ED2V01Y201603DTM044 Verlag URL des Erstveröffentlichers Volltext |
| spellingShingle | Graefe, Goetz Guy, Wey Sauer, Caetano Instant recovery with write-ahead logging page repair, system restart, media restore, and system failover Synthesis lectures on data management Data recovery (Computer science) Data logging Wiederherstellung Informatik (DE-588)4177289-1 gnd Datenerfassung (DE-588)4011123-4 gnd |
| subject_GND | (DE-588)4177289-1 (DE-588)4011123-4 |
| title | Instant recovery with write-ahead logging page repair, system restart, media restore, and system failover |
| title_auth | Instant recovery with write-ahead logging page repair, system restart, media restore, and system failover |
| title_exact_search | Instant recovery with write-ahead logging page repair, system restart, media restore, and system failover |
| title_full | Instant recovery with write-ahead logging page repair, system restart, media restore, and system failover Goetz Graefe, Wey Guy, Caetano Sauer |
| title_fullStr | Instant recovery with write-ahead logging page repair, system restart, media restore, and system failover Goetz Graefe, Wey Guy, Caetano Sauer |
| title_full_unstemmed | Instant recovery with write-ahead logging page repair, system restart, media restore, and system failover Goetz Graefe, Wey Guy, Caetano Sauer |
| title_short | Instant recovery with write-ahead logging |
| title_sort | instant recovery with write ahead logging page repair system restart media restore and system failover |
| title_sub | page repair, system restart, media restore, and system failover |
| topic | Data recovery (Computer science) Data logging Wiederherstellung Informatik (DE-588)4177289-1 gnd Datenerfassung (DE-588)4011123-4 gnd |
| topic_facet | Data recovery (Computer science) Data logging Wiederherstellung Informatik Datenerfassung |
| url | https://doi.org/10.2200/S00710ED2V01Y201603DTM044 |
| volume_link | (DE-604)BV036731811 |
| work_keys_str_mv | AT graefegoetz instantrecoverywithwriteaheadloggingpagerepairsystemrestartmediarestoreandsystemfailover AT guywey instantrecoverywithwriteaheadloggingpagerepairsystemrestartmediarestoreandsystemfailover AT sauercaetano instantrecoverywithwriteaheadloggingpagerepairsystemrestartmediarestoreandsystemfailover |