Client-less database system recovery

Patent metadata

Field	Value
Publication number	US-2022164266-A1
Application number	US-202017101341-A
Country	US
Kind code	A1
Filing date	Nov 23, 2020
Priority date	Nov 23, 2020
Publication date	May 26, 2022
Grant date	—

Abstract

One or more computer processors install a trigger on a primary database. The one or more computer processors, responsive to the trigger activating and a data modification associated with the primary database, format the data modification into a universal format for a plurality of backup databases. The one or more computer processors rotate an active backup database from the plurality of backup databases based on a determined alternating backup period. The one or more computer processors synchronize in real-time the primary database with the active backup database.

First claim

What is claimed is:

1 . A computer-implemented method comprising:
installing, by one or more computer processors, a trigger on a primary database; responsive to the trigger activating and a data modification associated with the primary database, formatting, by one or more computer processors, the data modification into a universal format for a plurality of backup databases; rotating, by one or more computer processors, an active backup database from the plurality of backup databases based on a determined alternating backup period; and synchronizing in real-time, by one or more computer processors, the primary database with the active backup database.

2 . The computer-implemented method of claim 1 , further comprising:
monitoring, by one or more computer processors, the primary database for one or more database or table failures.

3 . The computer-implemented method of claim 2 , further comprising:
responsive to one or more database or table failures associated with the monitored primary database, replacing, by one or more computer processors, the primary database with the active backup database, wherein the active backup database takes over all database operations; and selecting, by one or more computer processors, a new active backup database from the plurality of backup databases.

4 . The computer-implemented method of claim 2 , further comprising:
responsive to one or more database or table failures associated with the monitored primary database and the active backup database, selecting, by one or more computer processors, a backup database with a last successful data synchronization from the plurality of backup databases; replacing, by one or more computer processors, the primary database with the backup database with the last successful data synchronization; and selecting, by one or more computer processors, a new active backup database from the plurality of backup databases.

5 . The computer-implemented method of claim 1 , wherein the trigger is based on a number of transactional changes, a specific time interval, or whether a database transfer size threshold is reached.

6 . The computer-implemented method of claim 1 , wherein the active backup database receives all asynchronous backups of the primary database.

7 . The computer-implemented method of claim 1 , further comprising:
adjusting, by one or more computer processors, the alternating backup period based on one or more specifications associated with the plurality of backup databases, wherein the specifications include database permissions, network latency, geographical distances, database capacity, and redundancy.

8 . A computer program product comprising:
one or more computer readable storage media and program instructions stored on the one or more computer readable storage media, the stored program instructions comprising: program instructions to install a trigger on a primary database; program instructions to, responsive to the trigger activating and a data modification associated with the primary database, format the data modification into a universal format for a plurality of backup databases; program instructions to rotate an active backup database from the plurality of backup databases based on a determined alternating backup period; and program instructions to synchronize in real-time the primary database with the active backup database.

9 . The computer program product of claim 8 , wherein the program instructions, stored on the one or more computer readable storage media, further comprise:
program instructions to monitor the primary database for one or more database or table failures.

10 . The computer program product of claim 9 , wherein the program instructions, stored on the one or more computer readable storage media, further comprise:
program instructions to responsive to one or more database or table failures associated with the monitored primary database, replace the primary database with the active backup database, wherein the active backup database takes over all database operations; and program instructions to select a new active backup database from the plurality of backup databases.

11 . The computer program product of claim 9 , wherein the program instructions, stored on the one or more computer readable storage media, further comprise:
program instructions to responsive to one or more database or table failures associated with the monitored primary database and the active backup database, select a backup database with a last successful data synchronization from the plurality of backup databases; program instructions to replace the primary database with the backup database with the last successful data synchronization; and program instructions to select a new active backup database from the plurality of backup databases.

12 . The computer program product of claim 8 , wherein the trigger is based on a number of transactional changes, a specific time interval, or whether a database transfer size threshold is reached.

13 . The computer program product of claim 8 , wherein the active backup database receives all asynchronous backups of the primary database.

14 . The computer program product of claim 8 , wherein the program instructions, stored on the one or more computer readable storage media, further comprise:
program instructions to adjust the alternating backup period based on one or more specifications associated with the plurality of backup databases, wherein the specifications include database permissions, network latency, geographical distances, database capacity, and redundancy.

15 . A computer system comprising:
one or more computer processors; one or more computer readable storage media; and program instructions stored on the computer readable storage media for execution by at least one of the one or more processors, the stored program instructions comprising:
program instructions to install a trigger on a primary database;
program instructions to, responsive to the trigger activating and a data modification associated with the primary database, format the data modification into a universal format for a plurality of backup databases;
program instructions to rotate an active backup database from the plurality of backup databases based on a determined alternating backup period; and
program instructions to synchronize in real-time the primary database with the active backup database.

16 . The computer system of claim 15 , wherein the program instructions, stored on the one or more computer readable storage media, further comprise:
program instructions to monitor the primary database for one or more database or table failures.

17 . The computer system of claim 16 , wherein the program instructions, stored on the one or more computer readable storage media, further comprise:
program instructions to responsive to one or more database or table failures associated with the monitored primary database, replace the primary database with the active backup database, wherein the active backup database takes over all database operations; and program instructions to select a new active backup database from the plurality of backup databases.

18 . The computer system of claim 16 , wherein the program instructions, stored on the one or more computer readable storage media, further comprise:
program instructions to responsive to one or more database or table failures associated with the monitored primary database and the active backup database, select a backup database with a last successful data sync

Assignees

• IBM

Inventors

• Butucea Panait Marcel
• Rueger Erik
• Sgobba Nicolo
• Paluch Michal

Classifications

• G06F11/2035

  without idle spare hardware · CPC title

• G06F11/1471

  involving logging of persistent data for recovery · CPC title

• G06F11/2094

  Redundant storage or storage space (G06F11/2056 takes precedence) · CPC title

• G06F11/2097

  maintaining the standby controller/processing unit updated (initialisation or re-synchronisation thereof G06F11/1658 and subgroups) · CPC title

• G06F11/2028

  eliminating a faulty processor or activating a spare · CPC title