Awesome GitHub RepositoriesDistributed Extensions

Citus is a PostgreSQL extension that transforms a standard database into a distributed system. It functions as a sharding framework and distributed SQL engine, enabling horizontal scaling by partitioning tables across a cluster of nodes. By utilizing a coordinator-worker topology, the system manages metadata and routes queries to the appropriate nodes, allowing for parallel execution of complex operations across distributed data shards. The platform distinguishes itself through its specialized support for multi-tenant architectures and real-time analytical processing. It enables tenant-based

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 asynchrono

该项目是一个数据库扩展，支持跨多个 PostgreSQL 节点的水平扩展和分布式数据分区。它作为一个中间件解决方案，将大型数据库表分布在集群中，以增加总存储容量并提高不断增长的数据集的写入性能。 该系统采用基于哈希的分区将表记录分布在物理节点上，并使用中央元数据目录来跟踪分片位置。它提供透明的查询路由，将标准 SQL 命令从协调节点引导至适当的工作节点，而无需修改现有的应用逻辑。 该框架包含通过分片复制和自动一致性修复过程来维护数据冗余和集群完整性的工具。它还支持高吞吐量数据摄入，利用并发处理将海量数据集导入分布式表中。