Self-healing infrastructure for a dual-database system

Patent metadata

Field	Value
Publication number	US-11301435-B2
Application number	US-202016855744-A
Country	US
Kind code	B2
Filing date	Apr 22, 2020
Priority date	Apr 22, 2020
Publication date	Apr 12, 2022
Grant date	Apr 12, 2022

Abstract

A database system could include a first database engine, a second database engine, and a replication engine. The database system could also include processors configured to perform operations. The operations could involve obtaining indicators that are respectively associated with performance issues that can occur in the database system, each indicator defining one or more conditions that, when satisfied, cause the indicator to become active. The operations could also involve obtaining mappings between: (i) at least some of the indicators, and (ii) remediation subroutines. The operations could additionally involve receiving operational data related to the first database engine, the second database engine, or the replication engine; determining, based on the operational data and the conditions defined by the indicators, that a particular indicator is active; determining, based on the mappings, that the particular indicator has an associated remediation subroutine; and executing the associated remediation subroutine.

First claim

What is claimed is:

1. A database system comprising:
a first database, a second database, and a replicator configured to perform: (i) a replication process to replicate entries from the first database to the second database, and (ii) a defragmentation process to defragment the entries that are in the second database; and
one or more processors configured to perform operations including:
obtaining a set of indicators that are respectively associated with performance issues that can occur in the database system, wherein each respective indicator defines one or more conditions that cause the respective indicator to become active, and wherein the one or more conditions relate to the first database, the second database, the replicator, the replication process, or the defragmentation process;
obtaining a set of mappings between: (i) at least some of the set of indicators, and (ii) remediation subroutines;
receiving operational data related to one or more of the first database, the second database, the replicator, the replication process, or the defragmentation process;
determining, based on the operational data and the conditions defined by the set of indicators, that a particular indicator is active;
responsive to the particular indicator being active, determining, based on the set of mappings, that the particular indicator has an associated remediation subroutine; and
executing the associated remediation subroutine.

2. The database system of claim 1 , wherein the operational data is received from one or more of the first database, the second database, or the replicator.

3. The database system of claim 1 , wherein each of the remediation subroutines addresses performance issues related to its associated indicator from the set of mappings.

4. The database system of claim 1 , wherein the operations further include:
determining, based on the operational data and the conditions defined by the set of indicators, that a second particular indicator is active;
responsive to the second particular indicator being active, determining, based on the set of mappings, that the second particular indicator does not have an associated subroutine; and
assigning a performance issue associated with the second particular indicator to an agent.

5. The database system of claim 4 , wherein assigning the performance issue associated with the second particular indicator to the agent comprises:
generating, for display on a graphical user interface, a representation of the performance issue and the one or more conditions associated with the second particular indicator; and
transmitting the representations as generated to a client device associated with the agent.

6. The database system of claim 1 , wherein the operations further include:
after executing the associated remediation subroutine, receiving additional operational data related to one or more of the first database, the second database, the replicator, the replication process, or the defragmentation process;
determining, based on the additional operational data, that the particular indicator is still active; and
assigning a performance issue associated with the particular indicator to an agent.

7. The database system of claim 1 , wherein the operations further include:
determining, based on the operational data and the conditions defined by the indicators, that a second particular indicator is not active;
after determining that the second particular indicator is not active, receiving additional operational data related to one or more of the first database, the second database, the replicator, the replication process, or the defragmentation process;
determining, based on the additional operational data, that the second particular indicator is active;
responsive to the second particular indicator being active, determining, based on the set of mappings, that the second particular indicator has an associated second remediation subroutine; and
executing the associated second remediation subroutine.

8. The database system of claim 7 , wherein receiving the additional operational data occurs after a first period of time from receiving the operational data, wherein determining that the second particular indicator is active occurs after a second period of time from determining that the second particular indicator is not active, and wherein second period of time is greater than the first period of time.

9. The database system of claim 1 , wherein obtaining the set of indicators comprises:
generating one or more graphical user interfaces with data entry elements for the one or more conditions of each of the set of indicators;
providing, to a client device, a representation of the one or more graphical user interfaces; and
receiving, from the client device and entered by way of the data entry elements, the one or more conditions of each of the set of indicators.

10. The database system of claim 1 , further comprising:
a router configured to receive database queries and perform a routing process to route the database queries to either the first database or the second database, wherein the operational data further comprises data related to one or more of the router or the routing process.

11. The database system of claim 1 , wherein the second database is a read-only replica of the first database.

12. The database system of claim 1 , wherein the second database is column-oriented database.

13. The database system of claim 1 , wherein the first database is an authoritative database for the database system.

14. A computer-implemented method comprising:
obtaining, by one or more processors disposed within a database system, a set of indicators that are respectively associated with performance issues that can occur in the database system, wherein each respective indicator defines one or more conditions that cause the respective indicator to become active, wherein the database system contains a first database, a second database, and a replicator configured to perform: (i) a replication process to replicate entries from the first database to the second database, and (ii) a defragmentation process to defragment the entries that are in the second database, and wherein the one or more conditions relate to the first database, the second database, the replicator, the replication process, or the defragmentation process;
obtaining, by the one or more processors, a set of mappings between: (i) at least some of the set of indicators, and (ii) remediation subroutines;
receiving, by the one or more processors, operational data related to one or more of the first database, the second database, the replicator, the replication process, or the defragmentation process;
determining, by the one or more processors and based on the operational data and the conditions defined by the set of indicators, that a particular indicator is active;
responsive to the particular indicator being active, determining, by the one or more processors and based on the set of mappings, that the particular indicator has an associated remediation subroutine; and
executing, by the one or more processors, the associated remediation subroutine.

15. The computer-implemented method of claim 14 , wherein the operational data is received from one or more of the first database, the second database, or the replicator.

16. The computer-implemented method of claim 14 , wherein each of the remediation subroutines addresses performance issues related to its associated indicator from the set of mappings.

17. The computer-implemented method of claim 14 , further comprising:
determining,

Assignees

• Servicenow Inc

Inventors

• Shah Siddharth Rajendra
• Norris Jeremy

Classifications

• G06F16/1734

  Details of monitoring file system events, e.g. by the use of hooks, filter drivers, logs · CPC title

• G06F16/211

  Schema design and management · CPC title

• G06F16/221

  Column-oriented storage; Management thereof · CPC title

• G06F16/217 Primary

  Database tuning (G06F16/2282 takes precedence; database performance monitoring G06F11/3409) · CPC title

• G06F16/1844 Primary

  Management specifically adapted to replicated file systems · CPC title