April 2021
Intermediate to advanced
384 pages
12h 22m
English
Content preview from Modern Data Protection
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
O’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.I wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.I’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.I'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.
Chapter 7. Protecting Databases
The life blood of most organizations is stored in some kind of database or an application that stores its data in a database. And yet, as I look back on the past three decades of work, most of the truly difficult backup and recovery problems I’ve had were with databases. I therefore think this may be the most important chapter in the book.
There are 13 types of database and 300 database products listed on db-engines.com, and each of them has a unique backup and recovery process. Some have entire manuals and books dedicated just to the best ways to back up those databases. Given the variety of types of database and the different ways they are backed up, the best I can do in this chapter is point you in the right direction.
My goal is to help you understand why databases are so hard to back up, explain the database architectural concept that someone tasked with backup should know, and describe the various ways that people back them up, including my opinion on the pros and cons of each method. I will then examine what I know of how these databases are backed up and offer my opinions there as well. My goal is to push you in the right direction and to give you enough knowledge to evaluate the details of your database backup methodology and potentially make improvements.
Before we start looking at the challenges and solutions of database backup and recovery, we need to talk about several categories of database. The first way that databases are delineated ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Read now
Unlock full access
More than 5,000 organizations count on O’Reilly
O’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.Julian F.
I wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.Addison B.
I’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.Amir M.
I'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.