awesome-repositories.com
Blog
MCP
awesome-repositories.com

Discover the best open-source repositories with AI-powered search.

ExploreCurated searchesOpen-source alternativesSelf-hosted softwareBlogSitemap
ProjectMCP serverAboutHow we rankPress
LegalPrivacyTerms
© 2026 Bringes Technology SRL·VAT RO45896025·hello@awesome-repositories.com
patroni avatar

patroni/patroni

0
View on GitHub↗
8,182 stars·986 forks·Python·mit·27 views

Patroni

Patroni is a high availability manager and cluster orchestrator for PostgreSQL. It functions as an automatic failover controller and replication manager that ensures continuous database availability by automating leader election and promoting standby nodes during failures.

The system maintains a consistent cluster state by acting as a distributed consensus coordinator. It synchronizes configuration and manages leader elections through integration with distributed configuration stores such as etcd, ZooKeeper, or Consul.

Its broader capabilities include managing both synchronous and asynchronous replication modes to balance data durability with system latency. It also provides support for distributed database extensions and orchestration within container environments, utilizing native objects and labels to manage cluster state and route traffic.

Features

  • High Availability Configurations - Provides the core tools and mechanisms for ensuring data redundancy and service continuity across distributed PostgreSQL clusters.
  • Database Cluster Orchestration - Provides automated deployment, scaling, and high-availability management for PostgreSQL clusters.
  • Automatic Failover Controllers - Monitors database health and automatically promotes standby nodes to primary roles to minimize downtime.
  • Replication Control and Policy - Manages the configuration of synchronous and asynchronous replication modes to balance data durability and latency.
  • Database Replication - Manages synchronous and asynchronous replication modes to balance data durability and system latency.
  • Distributed Configuration Store Integrations - Integrates with etcd to maintain consistent cluster state and coordinate leader elections across nodes.
  • Distributed Consensus Stores - Integrates with distributed consensus stores like etcd and ZooKeeper to maintain cluster state and leader election.
  • Database Managers - Manages PostgreSQL database instances, including binary files, data directories, and user settings.
  • Cluster Configuration Management - Manages centralized cluster settings and high-availability configurations via distributed stores.
  • Distributed Leader Election - Implements heartbeat-based leader election to ensure a single primary node is active within the cluster.
  • Database High Availability - Automates leader election and failover to ensure continuous availability for PostgreSQL clusters.
  • High Availability Clusters - Organizes database clusters across environments to ensure service continuity and fault tolerance.
  • Leader Election - Implements distributed locking and leader election mechanisms to ensure single-writer exclusivity in high-availability setups.
  • Automated Master Failovers - Automates the process of electing a new master and reconfiguring the cluster during a failure.
  • Cluster State Coordinators - Maintains a consistent view of cluster topology and metadata by integrating with distributed configuration stores.
  • Database Sidecar Processes - Runs as a sidecar process wrapper around PostgreSQL to monitor health and manage instance lifecycles.
  • Failover State Machines - Utilizes state-machine logic to promote standbys to primary based on data durability thresholds during failures.
  • Synchronous Replication Management - Ensures data consistency by requiring a secondary node to confirm writes before returning success.
  • Synchronous Commit Coordination - Coordinates synchronous replication by requiring standby acknowledgments before confirming transaction success to clients.
  • Distributed Extensions - Coordinates high availability for distributed database extensions that transform standard relational systems into clusters.
  • Asynchronous Replication Management - Supports asynchronous replication to prioritize service availability during failover.
  • Traffic Routing - Assigns dynamic role labels to nodes to enable external orchestrators to route traffic to the current primary.
  • Replication Mode Configurators - Provides the ability to toggle between synchronous and asynchronous replication modes to balance durability and latency.
  • Strong Consistency Guarantees - Prevents data loss by ensuring only standbys with all confirmed transactions are promoted to primary.
  • Cluster Orchestration APIs - Provides a REST API for external tools to monitor cluster health and trigger manual switchovers.
  • Distributed Database Clusters - Manages the operational deployment and coordination of distributed database clusters across multiple nodes.
  • Kubernetes Deployments - Provides tools and configurations for deploying high-availability database clusters to Kubernetes.
  • Kubernetes Deployment Management - Provides automated management of containerized database deployments on Kubernetes using specialized labels and environment variables.
  • Native Orchestration State Stores - Stores configuration and leader keys directly within Kubernetes objects to remove the need for external configuration stores.
  • Quorum-Based Commit Coordination - Implements quorum-based commits to balance write latency with data safety across synchronous standbys.
  • Label-Based - Assigns customizable role labels to pods so orchestration services can route traffic to the current leader.
  • Cluster Health Monitoring - Exposes a REST API for querying the health status and operational metrics of the distributed cluster.

Star history

Star history chart for patroni/patroniStar history chart for patroni/patroni

How this analysis was created: This summary and feature list are AI-generated from collected project material and can contain mistakes. Stars, license and language are imported from GitHub. Inclusion does not mean that we have tested or audited this project. Check the source documentation for any feature you depend on. Learn more on our About page.

AI search

Explore more awesome repositories

Describe what you need in plain English — the AI ranks thousands of curated open-source projects by relevance.

Start searching with AI

Projects sharing features with Patroni

These projects share indexed features with Patroni. Shared tags can include platform or build tooling; verify the primary use case before treating a result as a replacement.
  • pgsty/pigstypgsty avatar

    pgsty/pigsty

    4,703View on GitHub↗

    Pigsty is a full-stack orchestration suite for deploying, monitoring, and managing high-availability PostgreSQL clusters and their supporting infrastructure. It functions as a cluster management platform and high-availability suite that automates failover, manages virtual IPs, and ensures data consistency through distributed consensus. The project distinguishes itself by providing a comprehensive database infrastructure-as-code framework and a dedicated observability stack. It incorporates a backup and recovery manager supporting point-in-time recovery via S3-compatible object storage, alongs

    Shellgraphicsinfrapostgres
    View on GitHub↗4,703
  • cloudnative-pg/cloudnative-pgcloudnative-pg avatar

    cloudnative-pg/cloudnative-pg

    8,051View on GitHub↗

    CloudNativePG is a Kubernetes operator designed for the administration, lifecycle management, and high availability of PostgreSQL database clusters. It functions as a declarative orchestrator that manages database instances through custom resources and manifests. The project distinguishes itself by automating complex operational tasks, including primary election and failover management via streaming physical replication. It provides specialized tools for database version migrations, supporting both offline in-place upgrades and online migrations through logical replication. The operator cove

    Goautomated-failoverbusiness-continuitydatabase
    View on GitHub↗8,051
  • alibaba/alisqlalibaba avatar

    alibaba/AliSQL

    5,706View on GitHub↗

    AliSQL is a fork of MySQL by Alibaba that extends the relational database management system with enhancements for high performance, scalability, and enterprise-grade availability. It retains the core MySQL identity as a SQL-based database for storing, organizing, and retrieving structured data, while adding optimizations for large-scale transactional and analytical workloads. The project differentiates itself through a set of Alibaba-specific improvements, including a columnar engine for accelerating analytical queries directly on MySQL tables, and a distributed, shared-nothing NDB Cluster en

    C++alisqldatabaseduckdb
    View on GitHub↗5,706
  • vonng/pigstyVonng avatar

    Vonng/pigsty

    5,172View on GitHub↗

    Pigsty is a comprehensive database infrastructure orchestration platform designed to automate the full lifecycle of high-availability PostgreSQL clusters. It functions as an infrastructure-as-code framework that manages cluster coordination, node provisioning, and service discovery through idempotent playbooks. By integrating distributed consensus mechanisms, the platform ensures automated failover and consistent state enforcement across diverse environments, including bare metal and virtualized infrastructure. The platform distinguishes itself through a robust suite of operational capabiliti

    Shell
    View on GitHub↗5,172
Compare all 30 related projects→

Frequently asked questions

What does patroni/patroni do?

Patroni is a high availability manager and cluster orchestrator for PostgreSQL. It functions as an automatic failover controller and replication manager that ensures continuous database availability by automating leader election and promoting standby nodes during failures.

What are the main features of patroni/patroni?

The main features of patroni/patroni are: High Availability Configurations, Database Cluster Orchestration, Automatic Failover Controllers, Replication Control and Policy, Database Replication, Distributed Configuration Store Integrations, Distributed Consensus Stores, Database Managers.

Which projects share features with patroni/patroni?

Projects with overlapping indexed features include: pgsty/pigsty — Pigsty is a full-stack orchestration suite for deploying, monitoring, and managing high-availability PostgreSQL… cloudnative-pg/cloudnative-pg — CloudNativePG is a Kubernetes operator designed for the administration, lifecycle management, and high availability of… alibaba/alisql — AliSQL is a fork of MySQL by Alibaba that extends the relational database management system with enhancements for high… vonng/pigsty — Pigsty is a comprehensive database infrastructure orchestration platform designed to automate the full lifecycle of… hazelcast/hazelcast — Hazelcast is a distributed data platform that combines an in-memory data grid with a stream processing engine to… zalando/patroni — Patroni is a high availability manager and cluster orchestrator for PostgreSQL. It functions as a failover controller…