Systems and methods for agentless and accelerated backup of a database
The disclosed computer-implemented method for agentless and accelerated backup of a database may include, receiving, by a data backup device from a data server, blocks of data that provide a full backup of data of the data server. The method additionally includes receiving, by the data backup device from the data server, one or more native logs indicating one or more transactions performed by the data server. The method also includes determining, by the data backup device and based on the native logs, one or more changed blocks of the blocks of data. The method further includes providing, by the data backup device, a point in time restore of the data server by creating a synthetic full backup that overlays one or more of the blocks of data with the one or more changed blocks, and that shares remaining blocks of the blocks of data with the full backup.
1. A computer-implemented method for agentless and accelerated backup of a database, at least a portion of the method being performed by a computing device comprising at least one processor, the method comprising:
receiving, by a data backup device from a data server, blocks of data that provide a full backup of data of the data server;
receiving, by the data backup device from the data server, one or more native logs indicating one or more transactions performed by the data server;
determining, by the data backup device and based on the native logs, one or more changed blocks of the blocks of data;
providing, by the data backup device, a point in time restore of the data server by creating a synthetic full backup that overlays one or more of the blocks of data with the one or more changed blocks, and that shares remaining blocks of the blocks of data with the full backup; and
retaining in memory, by the data backup device, at least one of the one or more native logs as one or more transaction level restore points.
2. The method of claim 1 , wherein receiving the blocks of data includes receiving the blocks of data over a file sharing mechanism that allows files copied over a file sharing protocol to be catalogued as backups.
3. The method of claim 2 , wherein the file sharing mechanism includes a network file sharing (NFS) data export mechanism.
4. The method of claim 2 , wherein the file sharing mechanism includes a writeable overlay.
5. The method of claim 2 , wherein the sharing mechanism includes a data deduplication engine.
6. The method of claim 1 , wherein receiving the one or more native logs includes receiving the native logs from the data server configured in log replication mode.
7. The method of claim 1 , wherein determining the one or more changed blocks includes spinning up a database container image, by the data backup device, and using the database container image to generate a synthetic full copy by applying the native logs to the full backup.
8. The method of claim 7 , wherein creating the synthetic full backup includes performing a backup of the synthetic full copy.
9. A system for agentless and accelerated backup of a database, the system comprising:
a computing device comprising at least one physical processor; and
physical memory coupled to the at least one physical processor, wherein the at least one physical processor is configured to:
receive, by a data backup device from a data server, blocks of data that provide a full backup of data of the data server;
receive, by the data backup device from the data server, one or more native logs indicating one or more transactions performed by the data server;
determine, by the data backup device and based on the native logs, one or more changed blocks of the blocks of data;
provide, by the data backup device, a point in time restore of the data server by creating a synthetic full backup that overlays one or more of the blocks of data with the one or more changed blocks, and that shares remaining blocks of the blocks of data with the full backup; and
retain in memory, by the data backup device, at least one of the one or more native logs as one or more transaction level restore points.
10. The system of claim 9 , wherein the at least one physical processor is configured to receive the blocks of data at least in part by receiving the blocks of data over a file sharing mechanism that allows files copied over a file sharing protocol to be catalogued as backups.
11. The system of claim 10 , wherein the file sharing mechanism includes a network file sharing (NFS) data export mechanism.
12. The system of claim 10 , wherein the file sharing mechanism includes a writeable overlay.
13. The system of claim 10 , wherein the sharing mechanism includes a data deduplication engine.
14. The system of claim 9 , wherein the at least one physical processor is configured to receive the one or more native logs at least in part by receiving the native logs from the data server configured in log replication mode.
15. The system of claim 9 , wherein the at least one physical processor is configured to determine the one or more changed blocks at least in part by spinning up a database container image, by the data backup device, and using the database container image to generate a synthetic full copy by applying the native logs to the full backup.
16. The system of claim 15 , wherein the at least one physical processor is configured to create the synthetic full backup at least in part by performing a backup of the synthetic full copy.
17. A non-transitory computer-readable medium comprising one or more computer-executable instructions that, when executed by at least one processor of a computing device, cause the computing device to:
receive, by a data backup device from a data server, blocks of data that provide a full backup of data of the data server;
receive, by the data backup device from the data server, one or more native logs indicating one or more transactions performed by the data server;
determine, by the data backup device and based on the native logs, one or more changed blocks of the blocks of data;
provide, by the data backup device, a point in time restore of the data server by creating a synthetic full backup that overlays one or more of the blocks of data with the one or more changed blocks, and that shares remaining blocks of the blocks of data with the full backup; and
retaining in memory, by the data backup device, at least one of the one or more native logs as one or more transaction level restore points.
18. The non-transitory computer-readable medium of claim 17 , wherein the one or more computer-executable instructions cause the computing device to receive the blocks of data at least in part by receiving the blocks of data over a file sharing mechanism that allows files copied over a file sharing protocol to be catalogued as backups.
19. The non-transitory computer-readable medium of claim 17 , wherein the one or more computer-executable instructions cause the computing device to determine the one or more changed blocks at least in part by spinning up a database container image, by the data backup device, and using the database container image to generate a synthetic full copy by applying the native logs to the full backup.
20. The non-transitory computer-readable medium of claim 19 , wherein the one or more computer-executable instructions cause the computing device to create the synthetic full backup at least in part by performing a backup of the synthetic full copy.