Almost everybody has these stories:
I've been there. It sucks.
The crazy part are that these are seen as eventualities. And maybe they are!
But they don't have to be catastrophic. What if we could ensure they were just minor annoyances?
Get the details on improving your backups,
learn how to prevent data loss,
and undo bad queries.
Pay with PayPal. Add your email to the note!
Luckily, guarding against data loss isn't as hard as you think!
With just a few key concepts and examples, you'll know how to guard against accidents and server failures with minimum or no data loss!
It's a great start, but it's not enough to prevent future headaches.
There's just a few concepts you need to know to really understand how to make effective backups.
Even done properly, periodic backups on a busy database are out of date before they're even finished. On the flip side, recovering from continuous backups can take hours to rebuild from query history.
We need both styles of backups to be truly effective. This course will cover:
No, I'm not setting you up to for database replication (although that's good too)!
We'll cover ways to keep your database backups as up to date as possible without forcing you to manage another database.
Untested backups are a gamble. We'll power-up our backup strategy by covering:
Ever wished for a way to "undo" queries?
We'll cover how to rewrite query history and use point-in-time recovery.
43 videos • 6 hours at 1x
I'm Chris Fidao. I create videos and articles for developers and their servers at Servers for Hackers. I try to help as many developers as I can learn the basics of web servers so they can avoid server-related nightmares.