Reducing database downtime
First Claim
1. A method comprising:
- copying data, using one or more processors associated with one or more servers, from a source database to a target database to create a mirrored set of data;
limiting access to a subset of one or more selected tables in the target database;
redirecting general traffic from the source database to the target database, wherein the redirection occurs for a period of time during which maintenance operations are performed on the source database, wherein redirecting general traffic comprises concurrently permitting the administrative traffic to access the source database while redirecting the general traffic from the source database to the target database by determining whether a request is related to general traffic or administrative traffic based on a device address corresponding to a request;
capturing, using the one or more processors associated with the one or more servers, data modifications occurring in the target database during the period of time to be applied to the source database after the period of time;
replicating, using the one or more processors associated with the one or more servers, the data modifications into the source database; and
redirecting general traffic from the target database to the source database after the period of time.
1 Assignment
0 Petitions
Accused Products
Abstract
Embodiments enable reduction of database downtime in a live production environment of an on-demand database service during repair and/or maintenance tasks. A source database and a target database are provided. Data is copied from the source database to the target database to create a mirrored set of data. Access is limited to one or more designated tables in the target database. General traffic is redirected from the source database to the target database, wherein the redirection occurs for a duration of a maintenance period. Data modifications that occur in the target database during the maintenance period are captured and then replicated into the source database. Finally, general traffic is redirected from the target database to the source database.
125 Citations
30 Claims
-
1. A method comprising:
-
copying data, using one or more processors associated with one or more servers, from a source database to a target database to create a mirrored set of data; limiting access to a subset of one or more selected tables in the target database; redirecting general traffic from the source database to the target database, wherein the redirection occurs for a period of time during which maintenance operations are performed on the source database, wherein redirecting general traffic comprises concurrently permitting the administrative traffic to access the source database while redirecting the general traffic from the source database to the target database by determining whether a request is related to general traffic or administrative traffic based on a device address corresponding to a request; capturing, using the one or more processors associated with the one or more servers, data modifications occurring in the target database during the period of time to be applied to the source database after the period of time; replicating, using the one or more processors associated with the one or more servers, the data modifications into the source database; and redirecting general traffic from the target database to the source database after the period of time. - View Dependent Claims (2, 3, 4, 5, 6, 7, 8, 9, 10, 20)
-
-
11. A system for reducing database downtime for online applications, the system comprising:
-
a network interface; one or more servers, including one or more processors coupled with the network interface, the one or more processors to copy data from a source database to a target database to create a mirrored set of data, to limit access to a subset of one or more selected tables in the target database, wherein the one or more tables are selected based, at least in part, on row ownership, to redirect general traffic from the source database to the target database, wherein the redirection occurs for a period of time during which maintenance operations are performed on the source database, wherein redirecting general traffic comprises concurrently permitting the administrative traffic to access the source database while redirecting the general traffic from the source database to the target database by determining whether a request is related to general traffic or administrative traffic based on a device address corresponding to a request, to capture data modifications occurring in the target database during the period of time to be applied to the source database after the period of time, to replicate the data modifications into the source database, and to redirect general traffic from the target database to the source database after the period of time. - View Dependent Claims (12, 13, 14, 15, 16, 17, 18, 19)
-
-
21. A non-transitory computer-readable medium having stored thereon instructions that, when executed, cause one or more processors to:
-
copy data, using one or more processors associated with one or more servers, from a source database to a target database to create a mirrored set of data; limit access to a subset of one or more selected tables in the target database, wherein the one or more tables are selected based, at least in part, on row ownership; redirect general traffic from the source database to the target database, wherein the redirection occurs for a period of time during which maintenance operations are performed on the source database, wherein redirecting general traffic comprises concurrently permitting the administrative traffic to access the source database while redirecting the general traffic from the source database to the target database by determining whether a request is related to general traffic or administrative traffic based on a device address corresponding to a request; capture, using the one or more processors associated with the one or more servers, data modifications occurring in the target database during the period of time to be applied to the source database after the period of time; replicate the data modifications into the source database; and redirect general traffic from the target database to the source database after the period of time. - View Dependent Claims (22, 23, 24, 25, 26, 27, 28, 29, 30)
-
Specification