SDP Offline Checkpoint Illustration Document Version 2 7

SDP Offline Checkpoint Illustration Document Version 2. 7 (15 July, 2019)

SDP Physical Layout /hxdepots/p 4/acme/checkpoints /hxdepots/p 4/acme/depots /hxdepots/p 4/common Backup This Volume /hxmetadata/p 4/acme/root /hxmetadata/p 4/acme/offline_db Do NOT backup metadata directly /hxlogs/p 4/acme/logs (journal) Backup optional (Exclude Active Journal) /p 4 Contains symlinks /p 4/acme/bin, /p 4/acme/. p 4 tickets /hxdepots Versioned files, checkpoints, rotated journals /hxmetadata Live & Offline db. * /hxlogs Active Journal, various logs / (root volume) Animation Complete

SDP Logical Layout (symlinks) /p 4/acme/ /hxdepots/p 4/acme/checkpoints /hxdepots/p 4/acme/depots /hxdepots/p 4/common root /hxmetadata/p 4/acme/root offline_db /hxmetadata/p 4/acme/offline_db logs db. *, server. id, license tmp /hxlogs/p 4/acme/logs /p 4/common journal, log /hxlogs/p 4/acme/tmp /p 4/ssl (Host Local) /p 4/acme (Local). p 4 tickets*. p 4 trusts*

SDP Offline Checkpoint Procedure Key Features • No daily downtime. • Snapshot capability not needed on /hxmetadata. • Can use Snapshot capability /hxdepots volume. • Incorporates database integrity checks (not shown). • Occasional (quarterly? ) database regeneration. § Requires only a few minutes of downtime when run. § Does not require reset of attached replication. § Usually run with p 4 d upgrades. • Works with older versions of p 4 d (99. 1+? ). § Does not rely on replication functionality §Augments replication § Provides optimal recovery option for ‘sudden death’ failures.

d 1. 2. 3. 4. Initialization: Seed Offline DB Sp 4 configure set journal. Prefix=/p 4/1/checkpoints/p 4_1 Sp 4 d_1 -r /p 4/1/root -J /p 4/1/logs/journal –jc Sp 4 d_1 -r /p 4/1/offline_db -jr /p 4/1/checkpoints/p 4_1. ckp. 3240. gz Initiate Snapshot and backup of /hxdepots volume. /hxmetadata /p 4/1/offline_db /p 4/1/root /hxlogs /p 4/1/logs/journal /hxdepots /p 4/1/depots, checkpoints, etc. p 4_1. jnl. 3239 p 4_1. ckp. 3240. gz Animation Complete

d 1. 2. 3. 4. 5. 6. Sample Daily Procedure Sp 4 d_1 -r /p 4/1/root -J /p 4/1/logs/journal –jj Sp 4 d_1 -r /p 4/1/offline_db -jr /p 4/1/checkpoints/p 4_1. jnl. 3241 Sp 4 d_1 -r /p 4/1/offline_db -jd -z /p 4/1/checkpoints/p 4_1. ckp. 3242. gz Initiate Snapshot and backup of /hxdepots volume. Srm –f /p 4/1/offline_db/db. * Sp 4 d_1 -r /p 4/1/offline_db -jr -z /p 4/1/checkpoints/p 4_1. ckp. 3242. gz Note: With P 4 D 2018. 1+, -z no longer needed; compress/uncompressed files can be in one call. /hxmetadata /p 4/1/offline_db /p 4/1/root /hxlogs /p 4/1/logs/journal /hxdepots /p 4/1/depots, checkpoints, etc. p 4_1. jnl. 3241 p 4_1. ckp. 3242. gz Animation Complete

d 1. 2. 3. 4. 5. 6. 7. 8. 9. Sample Rebuild Procedure (On Demand) p 4 d_1_init stop p 4 d_1 -r /p 4/1/root -J /p 4/1/logs/journal –jj p 4 d_1 -r /p 4/1/offline_db -jr /p 4/1/checkpoints/p 4_1. jnl. 3245 Swap out live and offline db. * files (mv root -> save, mv offline_db -> root). p 4 d_1_init start p 4 d_1 -r /p 4/1/root/save -jd -z /p 4/1/checkpoints/p 4_1. ckp. 3246. gz Initiate Snapshot and backup of /hxdepots volume. rm –f /p 4/1/root/save/db. * p 4 d_1 -r /p 4/1/offline_db -jr -z /p 4/1/checkpoints/p 4_1. ckp. 3246. gz /hxmetadata /p 4/1/offline_db /p 4/1/root/save /hxlogs /p 4/1/logs/journal db. * /hxdepots /p 4/1/depots, checkpoints, etc. p 4_1. jnl. 3245 p 4_1. jnl. 3246. gz Animation Complete

Questions?