000 04855nam a22005175i 4500
001 978-3-031-01857-2
003 DE-He213
005 20240730163733.0
007 cr nn 008mamaa
008 220601s2016 sz | s |||| 0|eng d
020 _a9783031018572
_9978-3-031-01857-2
024 7 _a10.1007/978-3-031-01857-2
_2doi
050 4 _aTK5105.5-5105.9
072 7 _aUKN
_2bicssc
072 7 _aCOM043000
_2bisacsh
072 7 _aUKN
_2thema
082 0 4 _a004.6
_223
100 1 _aGraefe, Goetz.
_eauthor.
_4aut
_4http://id.loc.gov/vocabulary/relators/aut
_980283
245 1 0 _aInstant Recovery with Write-Ahead Logging
_h[electronic resource] /
_cby Goetz Graefe, Wey Guy, Caetano Sauer.
250 _a2nd ed. 2016.
264 1 _aCham :
_bSpringer International Publishing :
_bImprint: Springer,
_c2016.
300 _aXVII, 113 p.
_bonline resource.
336 _atext
_btxt
_2rdacontent
337 _acomputer
_bc
_2rdamedia
338 _aonline resource
_bcr
_2rdacarrier
347 _atext file
_bPDF
_2rda
490 1 _aSynthesis Lectures on Data Management,
_x2153-5426
505 0 _aPreface -- Acknowledgments -- Introduction -- Related Prior Work -- Single-Page Recovery -- Applications of Single-Page Recovery -- Instant Restart after a System Failure -- Applications of Instant Restart -- Single-Pass Restore -- Applications of Single-Pass Restore -- Instant Restore after a Media Failure -- Applications of Instant Restore -- Multiple Pate, System and Media Failures -- Instant Failover -- Applications of Instant Failover -- File Systems and Data Files -- Performance and Scalability -- Conclusions -- References -- Author Biographies .
520 _aTraditional 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 aftersystem 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.
650 0 _aComputer networks .
_931572
650 0 _aData structures (Computer science).
_98188
650 0 _aInformation theory.
_914256
650 1 4 _aComputer Communication Networks.
_980284
650 2 4 _aData Structures and Information Theory.
_931923
700 1 _aGuy, Wey.
_eauthor.
_4aut
_4http://id.loc.gov/vocabulary/relators/aut
_980285
700 1 _aSauer, Caetano.
_eauthor.
_4aut
_4http://id.loc.gov/vocabulary/relators/aut
_980286
710 2 _aSpringerLink (Online service)
_980287
773 0 _tSpringer Nature eBook
776 0 8 _iPrinted edition:
_z9783031007293
776 0 8 _iPrinted edition:
_z9783031029851
830 0 _aSynthesis Lectures on Data Management,
_x2153-5426
_980288
856 4 0 _uhttps://doi.org/10.1007/978-3-031-01857-2
912 _aZDB-2-SXSC
942 _cEBK
999 _c84932
_d84932