Skip to content

Latest commit

 

History

History
99 lines (63 loc) · 2.5 KB

README.md

File metadata and controls

99 lines (63 loc) · 2.5 KB

Zero-Downtime PostgreSQL Migration 🚀

This project demonstrates how to migrate a high-transaction PostgreSQL database from a self-hosted environment to a cloud-based solution without any downtime or data loss.

Overview 📝

We leverage DevCycle's feature flags and Drizzle ORM to:

  • Dual Write Operations: Write to both old and new databases simultaneously.
  • Conditional Read Operations: Gradually switch reads from the old database to the new one for specific user groups.
  • Zero Downtime: Maintain uninterrupted service during the migration.

Features 🌟

  • Flexibility: Toggle database operations without redeploying.
  • Control: Direct specific user groups to the new database.
  • Safety: Quickly revert to the old database if needed.
  • Performance: Ensure data consistency and reliability.

Getting Started 🛠️

Prerequisites

  • Node.js
  • PostgreSQL
  • DevCycle Account
  • Drizzle ORM

Installation

  1. Clone the repository:

    git clone https://github.com/jacksonkasi0/geo-feature-flag-db-migration.git

  2. Navigate to the server app:

    cd geo-feature-flag-db-migration/apps/server

  3. Install dependencies:

    deno install

Configuration

  1. Set up DevCycle feature flags:

    • Create write and read boolean flags.
    • Define user groups and conditions based on your requirements.

  2. Update environment variables:

    • Add your DevCycle SDK key.
    • Configure database connection strings for both old and new databases.

Running the Application

Start the server:

deno task dev

Usage 🚴

  • The application evaluates feature flags to determine database operations.
  • Write Operations:
    • If writeToNewDB is true, writes go to both databases.
    • Otherwise, writes go only to the old database.
  • Read Operations:
    • If readFromNewDB is true, reads come from the new database.
    • Otherwise, reads come from the old database.

Roadmap 🛣️

  • Under Development:
    • Automating data synchronization with PostgreSQL's Publish-Subscribe feature.
    • Building Docker containers and scripts for automation.

Contributing 🤝

Contributions are welcome! Please open an issue or submit a pull request.

License 📄

This project is licensed under the MIT License.

Feel free to explore the GitHub repository for more details.

Happy coding! 😊🚀