Dynamic deactivation of cold database in database service

Patent metadata

Field	Value
Publication number	US-11169982-B2
Application number	US-201615199345-A
Country	US
Kind code	B2
Filing date	Jun 30, 2016
Priority date	Jun 30, 2016
Publication date	Nov 9, 2021
Grant date	Nov 9, 2021

Abstract

Managing databases implemented in a cloud computing environment. A method includes detecting that a database implemented in the cloud computing environment is in a state of non-use. The method further includes as a result of detecting that a database implemented in the cloud computing environment is in a state of non-use, instantiating a workload in the cloud computing environment to deactivate the database. The workload is configured to store metadata for the database and database data remotely in cloud storage such that the database can be reactivated at a later time.

First claim

What is claimed is:

1. A computer system comprising:
one or more processors; and
one or more non-transitory computer-readable media having stored thereon instructions that are executable by the one or more processors to configure the computer system to manage databases implemented by one or more clusters in a cloud computing environment, including instructions that are executable to configure the computer system to perform at least the following:
detect that a database implemented in the cloud computing environment is in a state of non-use; and
as a result of detecting that a database implemented in the cloud computing environment is in a state of non-use, instantiate a deactivation workflow by a workflow service coupled to the one or more clusters in the cloud computing environment to deactivate the database, wherein the deactivation workflow is configured to:
determine if a new connection was initiated during deactivation of the database;
in response to determining a new connection was initiated during the deactivation, cancel the deactivation workflow; and
in response to determining that a new connection was not initiated, store metadata for the database and database data remotely in cloud storage such that the database can be reactivated at a later time;

identify a database interaction for the database; and
trigger, by a cluster of the one or more clusters in the cloud computing environment, the workflow service to start an activation workflow to reactivate the database in response to the identifying the database interaction.

2. The computer system of claim 1 , wherein to identify the database interaction for the database, the instructions are executable to configure the computer system to:
detect user interaction directed at the database; and
wherein reactivating the database is configured to be performed as a result of detecting user interaction directed at the database.

3. The computer system of claim 1 , wherein to identify the database interaction for the database, the instructions are executable to configure the computer system to:
detect system interaction, exclusive of user interaction, directed at the database; and
wherein reactivating the database is configured to be performed as a result of detecting system interaction, exclusive of user interaction, directed at the database.

4. The computer system of claim 1 , wherein to identify the database interaction for the database, the instructions are executable to configure the computer system to:
identify potential database interaction; and
wherein reactivating the database is configured to be performed as a result of identifying potential database interaction.

5. The computer system of claim 1 , wherein detecting that the database implemented in the cloud computing environment is in a state of non-use comprises detecting that the database has not been used for a predetermined amount of time.

6. The computer system of claim 1 , wherein detecting that the database implemented in the cloud computing environment is in a state of non-use comprises detecting that the database is unlikely to be used for a period of time based on aggressive detection methods.

7. The computer system of claim 1 , wherein the one or more non-transitory computer-readable media further have stored thereon instructions that are executable by the one or more processors to configure the computer system to perform at least the following:
indicate, in a database table, a deactivation status that the database is being deactivated.

8. In a cloud computing environment, a method of managing databases implemented by one or more clusters in the cloud computing environment, the method comprising:
detecting that a database implemented in the cloud computing environment is in a state of non-use; and
as a result of detecting that a database implemented in the cloud computing environment is in a state of non-use, instantiating a deactivation workflow by a workflow service coupled to the one or more clusters in the cloud computing environment to deactivate the database, wherein the deactivation workflow is configured to:
determine if a new connection was initiated during deactivation of the database;
in response to determining a new connection was initiated during the deactivation, cancel the deactivation workflow; and
in response to determining that a new connection was not initiated, store metadata for the database and database data remotely in cloud storage such that the database can be reactivated at a later time;

identify a database interaction for the database; and
trigger, by a cluster of the one or more clusters in the cloud computing environment, the workflow service to start an activation workflow to reactivate the database in response to the identifying the database interaction.

9. The method of claim 8 , wherein the identifying the database interaction for the database comprises detecting user interaction directed at the database; and
wherein reactivating the database is performed as a result of detecting user interaction directed at the database.

10. The method of claim 8 , wherein the identifying the database interaction for the database comprises detecting system interaction, exclusive of user interaction, directed at the database; and
wherein reactivating the database is performed as a result of detecting system interaction, exclusive of user interaction, directed at the database.

11. The method of claim 8 , further comprising: wherein the identifying the database interaction for the database comprises identifying potential database interaction; and
wherein reactivating the database is performed as a result of identifying potential database interaction.

12. The method of claim 8 , wherein detecting that the database implemented in the cloud computing environment is in a state of non-use comprises detecting that the database has not been used for a predetermined amount of time.

13. The method of claim 8 , wherein detecting that the database implemented in the cloud computing environment is in a state of non-use comprises detecting that the database is unlikely to be used for a period of time based on aggressive detection methods.

14. The method of claim 8 , further comprising:
indicating, in a database table, a deactivation status that the database is being deactivated.

15. A computer system comprising:
one or more clusters configured to host databases for users in a cloud computing environment;
remote cloud storage coupled to the one or more clusters, wherein the remote storage is configured to store metadata for databases and database data remotely from the clusters;
one or more processors; and
one or more non-transitory computer-readable media having stored thereon instructions that are executable by the one or more processors, the instructions comprising:
a workflow service coupled to the one or more clusters, and wherein the workflow service is configured to:
detect that a database implemented in the cloud computing environment is in a state of non-use and to instantiate a deactivation workflow in the cloud computing environment to deactivate the database, wherein the deactivation workflow is configured to:
determine if a new connection was initiated during deactivation of the database;
in response to determining a new connection was initiated during the deactivation, cancel the deactivation workflow; and
in response to determining that a new connection was not initiated, store metadata for the database and database data remotely in the remote cloud storage such that the database can be reactivated at a later time;

identify a datab

Assignees

• Microsoft Technology Licensing Llc

Inventors

• Kalhan Ajay
• Talius Tomas
• Arora Pankaj
• Guo Qun
• Xu Shize

Classifications

• G06F16/2308

  Concurrency control (transaction processing G06F9/466) · CPC title

• G06F16/2358 Primary

  Change logging, detection, and notification (replication G06F16/27) · CPC title

• G06F16/217

  Database tuning (G06F16/2282 takes precedence; database performance monitoring G06F11/3409) · CPC title

• G06F9/505 Primary

  considering the load · CPC title