Reducing database downtime
First Claim
1. A computer-implemented method of reducing database downtime for online applications, the 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 one or more designated tables in the target database, wherein database-level triggers are created for all tables for which access is to be restricted and the triggers operate to restrict a database access to sanctioned operations through implementation of a special database user, wherein the database trigger raises an exception for every INSERT, UPDATE, or DELETE attempt and the database trigger permits temporary or short-term modifications to data that are not to be copied back to the source database;
redirecting general traffic from the source database to the target database, wherein the redirection occurs for a duration of a maintenance period;
capturing, using the one or more processors associated with the one or more servers, data modifications occurring in the target database during the maintenance period;
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.
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.
-
Citations
36 Claims
-
1. A computer-implemented method of reducing database downtime for online applications, the 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 one or more designated tables in the target database, wherein database-level triggers are created for all tables for which access is to be restricted and the triggers operate to restrict a database access to sanctioned operations through implementation of a special database user, wherein the database trigger raises an exception for every INSERT, UPDATE, or DELETE attempt and the database trigger permits temporary or short-term modifications to data that are not to be copied back to the source database; redirecting general traffic from the source database to the target database, wherein the redirection occurs for a duration of a maintenance period; capturing, using the one or more processors associated with the one or more servers, data modifications occurring in the target database during the maintenance period; 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. - View Dependent Claims (2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12)
-
-
13. A system for reducing database downtime for online applications, the system comprising:
-
a network interface; a non-transitory computer-readable medium tangibly embodied with program code; and one or more servers, including one or more processors, for executing the program code, the program code comprising; instructions to copy data from a source database to a target database to create a mirrored set of data; instructions to access to one or more designated tables in the target database, wherein database-level triggers are created for all tables for which access is to be restricted and the triggers operate to restrict a database access to sanctioned operations through implementation of a special database user, wherein the database trigger raises an exception for every INSERT, UPDATE, or DELETE attempt and the database trigger permits temporary or short-term modifications to data that are not to be copied back to the source database; instructions to redirect general traffic from the source database to the target database, wherein the redirection occurs for a duration of a maintenance period; instructions to capture data modifications occurring in the target database during the maintenance period; instructions to replicate the data modifications into the source database; and instructions to redirect general traffic from the target database to the source database. - View Dependent Claims (14, 15, 16, 17, 18, 19, 20, 21, 22, 23, 24)
-
-
25. A non-transitory computer-readable medium containing program code executable by a processor in a computer to reduce database downtime for online applications, the program code including instructions 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 one or more designated tables in the target database, wherein database-level triggers are created for all tables for which access is to be restricted and the triggers operate to restrict a database access to sanctioned operations through implementation of a special database user, wherein the database trigger raises an exception for every INSERT, UPDATE, or DELETE attempt and the database trigger permits temporary or short-term modifications to data that are not to be copied back to the source database; redirect general traffic from the source database to the target database, wherein the redirection occurs for a duration of a maintenance period; capture, using the one or more processors associated with the one or more servers, data modifications occurring in the target database during the maintenance period; replicate, using the one or more processors associated with the one or more servers, the data modifications into the source database; and redirect general traffic from the target database to the source database. - View Dependent Claims (26, 27, 28, 29, 30, 31, 32, 33, 34, 35, 36)
-
Specification