公开(公告)号：US09720951B2

公开(公告)日：2017-08-01

申请号：US14936535

申请日：2015-11-09

Applicant: salesforce.com, inc.

Inventor： Scott Yancey ,  Chandni Jain ,  Gerald Noorthoek

IPC: G06F17/30 ,  G06F11/14

CPC classification number: G06F17/30368 ,  G06F11/14 ,  G06F17/30292 ,  G06F17/30362 ,  G06F17/30377 ,  G06F17/30557 ,  G06F17/30581 ,  G06F17/30864

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.