Immutable Database Deployment via Generation Value Switching

Resolve Bottlenecks,
Find Innovative Solutions
Generate Solutions

Solution Overview

Problem

Database systems face challenges with configuration drift, where updates are made in place, leading to a unique and difficult-to-replicate environment, and existing methods struggle to deploy immutable instances without causing user slowdowns.

Innovation Solution

The deployment system manages the deployment of immutable database system instances by determining whether the request is for an initial or update deployment, instantiating or updating database configurations, and transitioning between instances while ensuring minimal user impact.

Engineering Contradictions & Design Principles

VSEngineering Contradiction Analysis

1Adaptability or versatility

If database systems are updated in place to improve functionality, then the system can be updated, but configuration drift occurs making the environment unique and difficult to replicate

Engineering Contradiction:
Improvesystem update capabilityVSAvoidconfiguration consistency
Core Design Contradiction:
Adaptability or versatilityVSManufacturing precision

Solution Approach 1:

The patent creates a template-based system where database configurations are copied from approved templates rather than modified in place. Each database instance is initialized from a standardized template that defines the exact configuration, ensuring reproducibility and eliminating configuration drift while still allowing functional updates through template versioning.

Inventive Principle:
Principle #26Copying

Solution Approach 2:

The system performs preliminary actions by pre-defining all configuration parameters in templates before deployment. This ensures that all necessary configurations are established in advance according to approved specifications, preventing drift during operation and enabling consistent replication of the exact same configuration across multiple instances.

Inventive Principle:
Principle #10Preliminary action

2Manufacturing precision

If immutable database instances are deployed to eliminate configuration drift, then configuration consistency is improved, but deployment complexity increases

Engineering Contradiction:
Improveconfiguration consistencyVSAvoiddeployment system complexity
Core Design Contradiction:
Manufacturing precisionVSDevice complexity

Solution Approach 1:

The patent introduces a template as an intermediary between the desired configuration state and the actual database instance. The template serves as a mediator that translates high-level configuration requirements into concrete instance settings, simplifying the deployment process while ensuring consistency. The template management system acts as another intermediary layer that handles versioning and deployment coordination.

Inventive Principle:
Principle #24Intermediary (Mediator)

3Adaptability or versatility

If database instances transition between versions to enable updates, then system functionality can be improved, but user disruption may occur

Engineering Contradiction:
Improveversion update capabilityVSAvoiduser service continuity
Core Design Contradiction:
Adaptability or versatilityVSReliability

Solution Approach 1:

The system implements dynamic version management where multiple database instance versions can coexist. The active version is dynamically switched between instances based on deployment status, allowing updates to be applied without disrupting ongoing operations. This dynamic approach enables flexible version transitions that maintain service continuity while supporting functional improvements.

Inventive Principle:
Principle #15Dynamics

Data Source

PatentUS12321338B2Mechanisms for deploying database clusters
Publication Date: 2025.06.03 SALESFORCE INC
  • US12321338B2 patent drawing
  • US12321338B2 patent drawing
  • US12321338B2 patent drawing

AI summary

Techniques are disclosed that pertain to deploying immutable instances of a system. A computer system may maintain an active generation value that indicates an immutable instance of a database system that is permitted to write data to a database. The computer system may deploy a first immutable instance of the database system and update the active generation value to permit the first immutable instance to write data to the database. The computer system may receive a request to deploy a second immutable instance of the database system that includes an update not found in the first immutable instance. The computer system may deploy the second immutable instance and update the active generation value to cause the first immutable instance to cease writing data to the database and to permit the second immutable instance to write data to the database.