availability, recovery semantics, and guarantees Vasiliki Kalavri | Boston University 2020 Today’s topics • High-availability and fault-tolerance in distributed stream processing • Recovery semantics against failures and guarantee correct results after recovery? • how can we ensure minimal downtime and fast recovery? • how can we hide recovery side-effects from downstream applications? Vasiliki failures. 7 Vasiliki Kalavri | Boston University 2020 Recovery types 8 Vasiliki Kalavri | Boston University 2020 Recovery types • Precise recovery (exactly-once) • It hides the effects of a failure

............................................................355 23.3. On-line backup and point-in-time recovery (PITR) ....................................................356 23.3.1. Setting up WAL archiving with an On-line Backup...............................................................361 23.3.3.1. Recovery Settings...............................................................................362 23.3 ...............................................................................1217 49.5. Crash Recovery................................................................................................

......................................................456 24.3. Continuous Archiving and Point-In-Time Recovery (PITR) ......................................457 24.3.1. Setting up WAL archiving...... Recovering using a Continuous Archive Backup ...........................................462 24.3.3.1. Recovery Settings...............................................................................464 24.3 ...............................................................................1480 51.5. Crash Recovery................................................................................................

......................................................376 23.3. Continuous Archiving and Point-In-Time Recovery (PITR) ......................................377 23.3.1. Setting up WAL archiving...... Recovering using a Continuous Archive Backup ...........................................381 23.3.3.1. Recovery Settings...............................................................................383 23.3 ...............................................................................1332 50.5. Crash Recovery................................................................................................

......................................................429 24.3. Continuous Archiving and Point-In-Time Recovery (PITR) ...............................430 xi 24.3.1. Setting up WAL archiving......... Recovering using a Continuous Archive Backup ....................................434 24.3.3.1. Recovery Settings........................................................................436 24.3.4. Timelines ...............................................................................1394 51.5. Crash Recovery................................................................................................

............................................................305 22.3. On-line backup and point-in-time recovery (PITR) .............................................306 22.3.1. Setting up WAL archiving Recovering with an On-line Backup........................................................310 22.3.3.1. Recovery Settings........................................................................311 22.3.4. Timelines following options are intended for work on the PostgreSQL source, and in some cases to assist with recovery of severely damaged databases. There should be no reason to use them in a production database setup

............................................................323 22.3. On-line backup and point-in-time recovery (PITR) ....................................................324 22.3.1. Setting up WAL archiving with an On-line Backup...............................................................328 22.3.3.1. Recovery Settings...............................................................................330 22.3 following options are intended for work on the PostgreSQL source, and in some cases to assist with recovery of severely damaged databases. There should be no reason to use them in a production database setup

............................................................357 23.3. On-line backup and point-in-time recovery (PITR) ....................................................358 23.3.1. Setting up WAL archiving with an On-line Backup...............................................................363 23.3.3.1. Recovery Settings...............................................................................364 23.3 ...............................................................................1224 49.5. Crash Recovery................................................................................................

......................................................376 23.3. Continuous Archiving and Point-In-Time Recovery (PITR) ......................................377 23.3.1. Setting up WAL archiving...... Recovering using a Continuous Archive Backup ...........................................381 23.3.3.1. Recovery Settings...............................................................................383 23.3 ...............................................................................1332 50.5. Crash Recovery................................................................................................

......................................................499 24.3. Continuous Archiving and Point-In-Time Recovery (PITR) ......................................500 24.3.1. Setting up WAL archiving...... Recovering using a Continuous Archive Backup ...........................................505 24.3.3.1. Recovery Settings...............................................................................507 24.3 ...............................................................................1613 51.5. Crash Recovery................................................................................................