🔥 The DB Grill 🔥

Where database blog posts get flame-broiled to perfection

Perform Point-In-Time-Recovery (PITR) in Valkey/Redis
Originally from percona.com/blog/feed/
December 15, 2025 • Roasted by Sarah "Burnout" Chen Read Original Article

Oh, this is just fantastic. Another blog post that promises a solution so simple, so elegant, it makes you wonder why you didn't think of it yourself. I’m truly grateful for this enlightenment on Point-in-Time-Recovery. It’s a feature I’ve only dreamed of, right after “a full night’s sleep” and “a Jira ticket with a clear acceptance criteria.”

I especially love the part where it mentions you just need to have append-only logging enabled. And then, as a delightful little footnote, you also need to enable aof-timestamp-enabled. It’s so thoughtful of the Valkey/Redis team to make the one parameter that makes PITR actually possible an optional, non-default setting. It’s a wonderful little surprise for the next engineer who inherits this system, like an Easter egg in a minefield. I can already see the post-mortem now: “We had backups, but tragically, we were only backing up the ‘what’ and not the ‘when’.”

This reminds me of my last "simple" migration. You know, the one where "just flip the switch" turned into a 72-hour incident involving:

This article gives me that same warm, fuzzy feeling. That tingling sensation of impending doom. Because this isn't just a feature; it's a whole new suite of exciting failure modes. I can’t wait to be paged at 3 AM because the AOF file, now bloated with billions of tiny timestamps, has finally consumed all available disk space. The performance hit from adding a timestamp to every single write operation will surely be negligible, right? It's just a few extra bytes per command. What's a little more disk I/O between friends?

By default, AOF in Valkey/Redis only records the operations that have been executed against the instance, not when they were executed.

Reading this line filled me with a profound sense of peace. The kind of peace you feel when you realize you were right to be paranoid all along. It’s not a bug, it’s a feature discovery opportunity for the on-call engineer.

Truly, this is the solution we’ve been waiting for. It doesn't solve our old problems, it just gives us a new, more innovative set of problems to solve. And that’s what engineering is all about, isn’t it? Not stability, but the thrilling, resume-building adventure of cleaning up a catastrophic data loss event caused by a feature that was almost configured correctly.

Thanks for the tips! I’ll be sure to file this away in the 'Reasons to Seek a New Career in Alpaca Farming' folder. Will absolutely not be reading this blog again.