US 2007/0168704 A1 · System and method of configuring a database system with replicated data and automatic failover and recovery

Abstract

A graphical user interface based method of configuring automatic failover from a primary database system to a standby database system that is coupled to the primary database system by a network. Also coupled to the network is an observer process that is independent of the database systems and that initiates the failover process. The observer periodically pings the database systems to determine whether a failover is necessary. The graphical user interface permits a user to specify the primary and secondary database systems, configure the observer, and specify conditions under which a failover may occur and to enable automatic failover. A failover context is created from the inputs to the GUI and stored in persistent storage belonging to the database systems. If the Observer's context is stale, the Observer fetches the database system's context.

Claims38

Dependent claims

A method of configuring automatic failover from a primary database system to a standby database system, the primary database system and the standby database system being coupled together by a network and the method comprising the steps of:

in a graphical user interface server that is coupled to the network, providing a graphical user interface to a graphical user interface client that is coupled to the network, the graphical user interface client receiving automatic failover configuration information input by a user thereof and the graphical user interface server receiving the automatic failover configuration from the graphical user interface client and storing the automatic failover configuration information in persistent storage accessible via the network;
and
in an observer that is coupled to the network and executes independently of the primary database system and the standby database system, obtaining the automatic failover configuration information from the persistent storage,
the observer initiating the automatic failover from the primary database system to the standby database system in accordance with the automatic failover configuration information.

1 more element

Apparatus for configuring automatic failover from a primary database system to a standby database system, the primary database system and the standby database system being coupled together by a network and the apparatus comprising:

persistent storage accessible via the network;
a graphical user interface server that is coupled to the network, the graphical user interface server providing a graphical user interface to a graphical user interface client that is coupled to the network, the graphical user interface client receiving automatic failover configuration information input by a user thereof and the graphical user interface server receiving the automatic failover configuration from the graphical user interface client and storing the automatic failover configuration information in the persistent storage;
and
an observer that is coupled to the network and executes independently of the primary database system and the standby database system and that obtains the automatic failover configuration information from the persistent storage, the observer initiating the automatic failover from the primary database system to the standby database system in accordance with the automatic failover configuration information.

1 more element

Dependencies are inferred from the claim text.

System and method of configuring a database system with replicated data and automatic failover and recovery

Life of this patent

System and method of configuring a database system with replicated data and automatic failover and recovery

Life of this patent

Abstract

Claims38