Automatic Replication Mode Switching in RDBMS

Resolve Bottlenecks,
Find Innovative Solutions
Generate Solutions

Solution Overview

Problem

Relational Database Management Systems (RDMS) face challenges in efficiently switching between synchronous and asynchronous replication modes, particularly due to network outages or slow communication, which can lead to delayed transaction confirmations and impact database performance.

Innovation Solution

Implementing a replication agent that automatically switches between synchronous and asynchronous replication modes based on detected events, such as timer expirations or network conditions, allowing database tasks to continue processing without waiting for confirmation notifications.

Engineering Contradictions & Design Principles

VSEngineering Contradiction Analysis

1Reliability

If synchronous replication mode is used to ensure data consistency, then data integrity is improved, but transaction response time deteriorates due to waiting for confirmation notifications

Engineering Contradiction:
Improvedata integrityVSAvoidtransaction response time
Core Design Contradiction:
ReliabilityVSLoss of time

Solution Approach 1:

The system dynamically switches between synchronous and asynchronous replication modes based on the operational context. When a database task is actively monitoring for confirmation notifications, synchronous mode is used to ensure data integrity. When no task is waiting for confirmation, the system transitions to asynchronous mode to improve transaction response time. This dynamic adaptation resolves the contradiction by adjusting the replication strategy in real-time based on system state.

Inventive Principle:
Principle #15Dynamics

Solution Approach 2:

The replication mode parameter is changed based on the presence or absence of database tasks waiting for confirmation. The system monitors whether any database task is in a waiting state and adjusts the replication mode accordingly - maintaining synchronous mode when tasks are waiting to preserve data integrity, and switching to asynchronous mode when no tasks are waiting to reduce transaction response time.

Inventive Principle:
Principle #35Parameter changes

2Reliability

If synchronous replication mode is used to ensure data consistency, then data integrity is improved, but network communication efficiency deteriorates due to delayed confirmations

Engineering Contradiction:
Improvedata consistencyVSAvoidnetwork communication efficiency
Core Design Contradiction:
ReliabilityVSProductivity

Solution Approach 1:

The system dynamically adjusts its replication strategy based on network conditions and task states. When network confirmations are delayed but no database task is actively waiting, the system switches to asynchronous mode to maintain network communication efficiency. When a task is waiting for confirmation, it transitions to synchronous mode to ensure data consistency, thus dynamically balancing reliability and productivity.

Inventive Principle:
Principle #15Dynamics

Solution Approach 2:

The replication mode parameter is adjusted based on whether database tasks are waiting for confirmations and the current network state. This parameter change allows the system to optimize network communication efficiency by using asynchronous mode when confirmations are delayed but not critical, while maintaining data consistency through synchronous mode when tasks are actively waiting.

Inventive Principle:
Principle #35Parameter changes

3Speed

If asynchronous replication mode is used to improve transaction response time, then transaction processing speed is improved, but data availability deteriorates during network outages

Engineering Contradiction:
Improvetransaction processing speedVSAvoiddata availability
Core Design Contradiction:
SpeedVSReliability

Solution Approach 1:

The system dynamically switches between asynchronous and synchronous replication modes based on network availability and task states. When network outages are detected and database tasks are waiting for confirmations, the system transitions to synchronous mode to ensure data availability. When network conditions are good and no tasks are waiting, it uses asynchronous mode to maximize transaction processing speed.

Inventive Principle:
Principle #15Dynamics

Solution Approach 2:

The system implements feedback mechanisms to monitor network conditions and database task states. Based on this feedback, it automatically adjusts the replication mode - switching to synchronous mode when network outages occur and tasks are waiting for confirmations to maintain data availability, and switching to asynchronous mode when conditions are favorable for improved transaction processing speed.

Inventive Principle:
Principle #23Feedback

4Adaptability or versatility

If automatic mode switching is implemented to balance performance and reliability, then system adaptability is improved, but device complexity increases

Engineering Contradiction:
Improvesystem adaptabilityVSAvoidreplication management complexity
Core Design Contradiction:
Adaptability or versatilityVSDevice complexity

Solution Approach 1:

The system performs automatic mode switching based on monitoring its own state - specifically whether database tasks are waiting for confirmation notifications and current network conditions. This self-service approach improves system adaptability without requiring complex external control mechanisms, as the system autonomously determines when to switch between synchronous and asynchronous modes based on predefined criteria.

Inventive Principle:
Principle #25Self-service

Solution Approach 2:

The automatic mode switching mechanism uses feedback from the system's own operational state (task waiting status and network conditions) to determine when to switch replication modes. This feedback-driven approach enables the system to adapt to changing conditions while maintaining relatively simple control logic, as the switching decisions are based on straightforward monitoring of existing system parameters.

Inventive Principle:
Principle #23Feedback

Data Source

PatentUS10650026B2Automatic mode switching in a synchronous replication environment
Publication Date: 2020.05.12 SYBASE INC
  • US10650026B2 patent drawing
  • US10650026B2 patent drawing
  • US10650026B2 patent drawing

AI summary

Disclosed in some examples is a method of database replication, the method including at a Relational Database Management System (RDMS), determining a first replication mode; identifying a triggering event; determining that the triggering event indicates a change in the first replication mode; responsive to determining that the triggering event indicates a change in the first replication mode, determining a second replication mode, the second replication mode being a different replication mode than the first replication mode; identifying a database change made by one or more database tasks; and replicating the database change to an external replication component according to the second replication mode.