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?
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!
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.
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.