Database protection using block-level mapping
A system according to certain aspects may include a client computing device including: a database application configured to output a database file in a primary storage device(s), the database application outputting the database file as a series of application-level blocks; and a data agent configured to divide the database file into a plurality of first blocks having a first granularity larger than a second granularity of the application-level blocks such that each of the first blocks spans a plurality of the application-level blocks. The system may include a secondary storage controller computer(s) configured to: in response to instructions to create a secondary copy of the database file: copy the plurality of first blocks to a secondary storage device(s) to create a secondary copy of the database file; and create a table that provides a mapping between the copied plurality of first blocks and corresponding locations on the secondary storage device(s).
1. A method of protecting database files, the method comprising:
monitoring a plurality of application-level blocks associated with a database, file, the plurality of application-level blocks stored in primary memory with a first granularity;
converting the plurality of application-level blocks to one or more secondary storage blocks having a second granularity that is larger than the first granularity,
wherein the one or more of the secondary storage blocks comprises at least a portion of the plurality of application-level blocks;
copying the one or more secondary storage blocks to one or more secondary storage devices in a secondary storage subsystem to create a secondary copy of the plurality of application-level blocks associated with the database file; and
creating an index that maps the one or more secondary storage blocks with the plurality of application-level blocks.
2. The method of claim 1 , wherein the second granularity of the one or more secondary storage blocks is a multiple of the first granularity of the plurality of the application-level blocks.
3. The method of claim 1 , wherein size of one of the one or more secondary storage blocks is a multiple of size of one of the plurality of application-level blocks.
4. The method of claim 1 , wherein each of the one or more secondary storage blocks has a unique identifier (ID).
5. The method of claim 1 , wherein the index comprises information relating to at least:
the secondary copy of the plurality of application-level blocks associated with the database file,
at least one secondary storage block of the one or more secondary storage blocks,
a backup file identifier for a location of the at least one secondary storage block,
and a backup file offset for the location of the at least one secondary storage block in the secondary storage subsystem.
6. The method of claim 1 , wherein the secondary copy of the plurality of application-level blocks associated with the database file is provided as a file system in a user interface.
7. The method of claim 1 , further comprising:
dividing the database file into the plurality of application-level blocks by a data agent executing on a computing device that is different from a client computing device that generates the database file.
8. The method of claim 7 , wherein the data agent is a proxy data agent that executes on a computing device that is different from a computing device on which a database application associated with the database executes.
9. The method of claim 1 , wherein the second granularity of the one or more secondary storage blocks is based on size of a read operation by a database application that generates the database file.
10. The system method of claim 1 , wherein the index is stored separately from the one or more secondary storage blocks.
11. A data storage system for protecting database files, the system comprising:
a data agent executing on a hardware processor,
the data agent configured to monitor a plurality of application-level blocks associated with a database file, the plurality of application-level blocks stored in primary memory with a first granularity; and
one or more secondary storage controller computers comprising computer hardware configured to:
convert the plurality of application-level blocks to one or more secondary storage blocks having a second granularity that is larger than the first granularity, wherein the one or more secondary storage blocks comprises at least a portion of the plurality of application-level blocks,
copy the one or more secondary storage blocks to one or more secondary storage devices in a secondary storage subsystem to create a secondary copy of the plurality of application-level blocks associated with the database file; and
create an index that maps the one or more secondary storage blocks with the plurality of application-level blocks.
12. The system of claim 11 , wherein the second granularity of the one or more secondary storage blocks is a multiple of the first granularity of the plurality of application-level blocks.
13. The system of claim 11 , wherein size of one of the one or more secondary storage blocks is a multiple of size of one of the plurality of application-level blocks.
14. The system of claim 11 , wherein each of the one or more secondary storage blocks has a unique identifier (ID).
15. The system of claim 11 , wherein the index comprises information relating to at least:
the secondary copy of plurality of application-level blocks associated with the database file,
at least one secondary storage block of the one or more secondary storage blocks,
a backup file identifier for a location of the at least one secondary storage block, and
a backup file offset for the location of the at least one secondary storage block in the secondary storage subsystem.
16. The system of claim 11 , wherein the secondary copy of the plurality of application-level blocks associated with the database file is provided as a file system in a user interface.
17. The system of claim 11 , wherein the data agent is executing on a computing device that is different from a client computing device that generates the database file, the data agent is configured to divide the database file into the plurality of application-level blocks.
18. The system of claim 11 , wherein the second granularity of the one or more secondary storage blocks is based on size of a read operation by a database application that generates the database file.
19. The system of claim 11 , wherein the index is stored separately from the one or more secondary storage blocks.
20. The system of claim 11 , wherein the data agent is a proxy data agent that executes on a computing device that is different from a computing device on which a database application associated with the database file executes.