Abstract:
Multiple-active database systems include at least two database systems that both store a common portion of a relational database. Each database system includes one or more data-storage facilities configured to store data forming the common portion of the relational database in one or more tables and one or more processing modules configured to manage access to the data in the data-storage facilities. One or more management components are configured to distribute database queries directed at the common portion of the relational database among the database systems and to synchronize the data across the database systems when changes are made to the data stored in at least one of the database systems.
Abstract:
Multiple-active database systems include at least two database systems that both store a common portion of a relational database. Each database system includes one or more data-storage facilities configured to store data forming the common portion of the relational database in one or more tables and one or more processing modules configured to manage access to the data in the data-storage facilities. One or more management components are configured to distribute database requests directed at the common portion of the relational database among the database systems and to synchronize the data across the database systems when changes are made to the data stored in at least one of the database systems.
Abstract:
A data-synchronization tool is used to ensure synchronization between at least two copies of a relational database that are stored in at least two database systems. The tool includes (a) a sync-control component configured to initiate synchronization of the copies of the database and (b) a sync-execution component configured to replicate one or more changes made to the copy stored in one of the database systems within the copy stored in another of the database systems.
Abstract:
A system-management tool is used in managing at least two copies of a relational database that are stored in at least two database systems. The tool includes (a) a monitoring component configured to monitor for the occurrence of an event within one of the database systems that creates a change in an operational status of that database system, and (b) a synchronization component configured to update state information stored in another of the database systems to reflect the change in operational status of the one database system.
Abstract:
A workload-management tool is used in distributing database requests across at least two database systems that both store copies of at least a portion of a relational database to which the database requests are directed. The tool includes one or more rules for routing database requests to the database systems and a routing component. The routing component is configured to receive an incoming database request, access the one or more rules for routing database requests to the database systems, and apply the one or more rules in selecting an appropriate one of the database systems to receive the incoming database request.
Abstract:
A system includes at least two database systems that both store a common portion of a relational database and that are configured to share in execution of a database workload against that relational database. The system also includes a system-management component configured to receive indication that a first one of the database systems is ceasing operation and, in response, take a second one of the database systems to an operational state in which at least a portion of the database workload that is scheduled to be carried out by the first database system is transferred to the second database system.