Efficient database migration using an intermediary secondary storage system
A portion of contents of a database is received from a first server. The received contents of the database is stored in a secondary storage system that tracks changes between different backup versions of contents of the database. A request to migrate the contents of the database to a second server is received. A version of contents of the database is provided to the second server using the secondary storage system. The secondary storage system is configured to determine an amount of changes to the database content from one of the versions of the database content provided to the second server and the amount of changes is utilized in determining whether to quiesce the database hosted on the first server.
1. A method, comprising:
receiving, at a storage system, a request to migrate database content associated with a first server to a second server;
migrating data associated with one or more backed up versions of the database content from the storage system to the second server hosting an updated version of a database while backing up one or more new versions of the database content from the first server hosting a previous version of the database to the storage system until an amount of time to migrate data associated with a latest backed up version of the database content that was backed up from the first server to the storage system is less than a downtime threshold, wherein migrating the data associated with the one or more backed up versions of database content from the storage system to the second server hosting the updated version of the database includes determining the amount of time to migrate the data associated with the latest backed up version of the database content that was backed up from the first server to the storage system; and
in response to determining that the amount of time to migrate the data associated with the latest backed up version of the database content that was backed up from the first server to the storage system is less than the downtime threshold, providing from the storage system to the second server hosting the updated version of the database the data associated with the latest backed up version of the database content that was backed up from the first server to the storage system, wherein one or more users associated with the previous version of the database are reassigned from the previous version of the database hosted on the first server to the updated version of the database hosted on the second server.
2. The method of claim 1 , wherein the one or more new versions of the database content are based on one or more incremental backups of the database content.
3. The method of claim 1 , wherein the data associated with the latest backed up version of the database content corresponds to database content that changed between the latest backed up version of the database content and one or more previous versions of the database content.
4. The method of claim 1 , wherein the one or more users associated with the previous version of the database are assigned to the previous version of the database while the one or more new versions of the database content are backed up from the first server hosting the previous version of the database to the storage system.
5. The method of claim 1 , wherein the one or more backed up versions of the database content are backed up from the first server hosting the previous version of the database to the storage system.
6. The method of claim 1 , wherein the previous version of the database is accessible by the one or more users while the data associated with the one or more backed up versions of database content is being migrated from the storage system to the second server hosting the updated version of the database.
7. The method of claim 1 , wherein the previous version of the database is quiesced before the data associated with the latest backed up version of the database content is provided to the second server hosting the updated version of the database.
8. The method of claim 1 , further comprising providing to an operator associated with the first server hosting the previous version of the database a notification that includes an estimated amount of time to migrate the data associated with the latest backed up version of the database content.
9. The method of claim 8 , further comprising receiving an indication to migrate the data associated with the latest backed up version of the database content.
10. The method of claim 1 , wherein a rate at which the first server hosting the previous version of the database is configured to perform an incremental backup is adjusted in response to a migration of the data associated with an initial backed up version of the database content being initiated.
11. The method of claim 1 , wherein the one or more backed up versions of the database content are associated with a corresponding tree data structure.
12. The method of claim 11 , wherein the data associated with the one or more backed up versions of database content is migrated in part by traversing tree data structures associated with the one or more backed up versions of the database content to locate the data associated with the one or more backed up versions of database content.
13. A computer program product, the computer program product comprising a non-transitory computer readable storage medium and comprising computer instructions for:
receiving a request to migrate database content associated with a first server to a second server;
migrating data associated with one or more backed up versions of the database content from a storage system to the second server hosting an updated version of a database while backing up one or more new versions of the database content from the first server hosting a previous version of the database to the storage system until an amount of time to migrate data associated with a latest backed up version of the database content that was backed up from the first server to the storage system is less than a downtime threshold, wherein migrating the data associated with the one or more backed up versions of database content from the storage system to the second server hosting the updated version of the database includes determining the amount of time to migrate the data associated with the latest backed up version of the database content that was backed up from the first server to the storage system; and
in response to determining that the amount of time to migrate the data associated with the latest backed up version of the database content that was backed up from the first server to the storage system is less than the downtime threshold, providing from the storage system to the second server hosting the updated version of the database the data associated with the latest backed up version of the database content that was backed up from the first server to the storage system, wherein one or more users associated with the previous version of the database are reassigned from the previous version of the database hosted on the first server to the updated version of the database hosted on the second server.
14. The computer program product of claim 13 , wherein the one or more new versions of the database content are based on one or more incremental backups of the database content.
15. The computer program product of claim 13 , wherein the data associated with the latest backed up version of the database content corresponds to database content that changed between the latest backed up version of the database content and one or more previous versions of the database content.
16. The computer program product of claim 13 , wherein the one or more users associated with the previous version of the database are assigned to the previous version of the database while the one or more new versions of the database content are backed up from the first server hosting the previous version of the database to the storage system.
17. The computer program product of claim 13 , wherein the one or more backed up versions of the database content are backed up from the first server hosting the previous version of the database to the storage system.
18. The computer program product of claim 13 , wherein the previous version of the database is quiesced before the data associated with the latest backed up version of the database content is provided to the second server hosting the updated version of the database.
19. A storage system, comprising:
a processor configured to:
receive a request to migrate database content associated with a first server to a second server;
migrate data associated with one or more backed up versions of the database content from the storage system to the second server hosting an updated version of a database while backing up one or more new versions of the database content from the first server hosting a previous version of the database to the storage system until an amount of time to migrate data associated with a latest backed up version of the database content that was backed up from the first server to the storage system is less than a downtime threshold, wherein migrating the data associated with the one or more backed up versions of database content from the storage system to the second server hosting the updated version of the database includes determining the amount of time to migrate the data associated with the latest backed up version of the database content that was backed up from the first server to the storage system; and
in response to a determination that the amount of time to migrate the data associated with the latest backed up version of the database content that was backed up from the first server to the storage system is less than the downtime threshold, providing from the storage system to the second server hosting the updated version of the database the data associated with the latest backed up version of the database content that was backed up from the first server to the storage system, wherein one or more users associated with the previous version of the database are reassigned from the previous version of the database hosted on the first server to the updated version of the database hosted on the second server; and
a memory coupled to the processor and configured to provide the processor with instructions.