Recovery Broker Database Locks for Message Disaster Recovery

Resolve Bottlenecks,
Find Innovative Solutions
Generate Solutions

Solution Overview

Problem

Existing multi-node computing architectures with replicated databases face challenges in disaster recovery due to restricted network visibility, making existing JMS solutions unusable in secure environments like banking, where message loss can be costly.

Innovation Solution

A system and method that uses recovery brokers to access messages across sites via database locks on a common replicated database, ensuring only one master broker operates concurrently, allowing for disaster recovery even without network visibility between sites.

Engineering Contradictions & Design Principles

VSEngineering Contradiction Analysis

1Object-affected harmful factors

If network visibility is restricted at the broker level for security reasons, then security is improved, but message recovery capability deteriorates

Engineering Contradiction:
ImprovesecurityVSAvoidmessage recovery capability
Core Design Contradiction:
Object-affected harmful factorsVSReliability

Solution Approach 1:

The patent introduces database locks as an intermediary mechanism that enables message recovery without requiring broker-level network visibility. The recovery broker uses database locks to detect and recover messages from failed brokers, bypassing the need for direct broker-to-broker communication while maintaining security restrictions.

Inventive Principle:
Principle #24Intermediary (Mediator)

Solution Approach 2:

The patent replaces the mechanical system of broker-level network communication with a database-based mechanism. Instead of relying on brokers to communicate directly over the network, the system uses database locks and replicated databases to enable message recovery, substituting network visibility requirements with database access capabilities.

Inventive Principle:
Principle #28Mechanics substitution (Replace mechanical system)

2Productivity

If multiple brokers operate concurrently on different sites, then system availability is improved, but message consistency deteriorates

Engineering Contradiction:
Improvesystem availabilityVSAvoidmessage consistency
Core Design Contradiction:
ProductivityVSManufacturing precision

Solution Approach 1:

The patent implements a feedback mechanism through database locks that allow recovery brokers to detect the state of other brokers and adjust their behavior accordingly. The lock mechanism provides feedback about broker availability, enabling the system to maintain consistency by preventing conflicting operations on the same messages while preserving high availability through distributed operation.

Inventive Principle:
Principle #23Feedback

3Object-affected harmful factors

If network visibility between sites is eliminated for security reasons, then security is improved, but disaster recovery capability deteriorates

Engineering Contradiction:
ImprovesecurityVSAvoiddisaster recovery capability
Core Design Contradiction:
Object-affected harmful factorsVSReliability

Solution Approach 1:

The patent uses database locks as an intermediary that enables disaster recovery without requiring network visibility between sites. The recovery broker at one site can acquire locks on messages in the replicated database at another site, allowing message recovery while maintaining security restrictions that prevent direct network communication between distributed brokers.

Inventive Principle:
Principle #24Intermediary (Mediator)

Solution Approach 2:

The patent replaces the mechanical requirement of network visibility with a database-based mechanism. Disaster recovery is achieved through database lock acquisition and message transfer, eliminating the need for network-level communication between sites while preserving the ability to recover from failures.

Inventive Principle:
Principle #28Mechanics substitution (Replace mechanical system)

Data Source

PatentUS10999392B2Message recovery system for computing nodes with replicated databases
Publication Date: 2021.05.04 ACCENTURE GLOBAL SOLUTIONS LTD
  • US10999392B2 patent drawing
  • US10999392B2 patent drawing
  • US10999392B2 patent drawing

AI summary

A system and method for recovering messages in a multi-node system that incorporates an active-active architecture with replicated databases is disclosed. The system comprises two or more computing nodes where each computing node includes brokers for processing local messages and a recovery broker for recovering messages from the replicated database when another node in the system fails. Each recovery broker competes with brokers on another node to acquire locks on database information. The recovery broker is successful if the network of brokers on the other node are unavailable and fail to obtain or retain locks on the database information. In this situation, the recovery broker can retrieve messages from the database information and pass the messages to other brokers on the same computing node for processing and completing any ongoing transactions.