2 个仓库
Awesome GitHub RepositoriesPostgreSQL Database Sharding
Splitting data across multiple PostgreSQL servers to scale storage and processing by routing queries via sharding keys.
Distinct from Shard Routing Logic: Existing candidates focus on routing logic or platform management rather than the core sharding architecture for PostgreSQL.
Explore 2 awesome GitHub repositories matching data & databases · PostgreSQL Database Sharding. Refine with filters or upvote what's useful.
Awesome PostgreSQL Database Sharding GitHub Repositories
用 AI 发现最棒的仓库。我们将通过 AI 为您搜索最匹配的仓库。
- postgresml/pgcat
postgresml/pgcat
3,966在 GitHub 上查看Pgcat 是一个 PostgreSQL 中间件解决方案，提供连接池、分片、负载均衡和故障转移管理。它作为一个代理，通过管理数据库会话并将查询分发到多个实例来优化资源使用和可扩展性。 该系统通过流量镜像脱颖而出，它将实时生产查询复制到测试数据库以进行验证。它还实现了分片代理，根据分片键将数据和查询分发到多个数据库实例。 该项目通过自动故障转移和服务器健康监控涵盖了高可用性。它包括用于分离读写操作的流量路由、用于加密通信的传输层安全 (TLS)，以及用于系统管理和性能指标导出的虚拟管理数据库。 该服务打包为 Docker 容器，以确保在不同环境中的一致部署。
Splits data across multiple PostgreSQL servers to scale storage and processing by routing queries via sharding keys.
Rustpoolerpoolingpostgresql - pgdogdev/pgdog
pgdogdev/pgdog
3,361在 GitHub 上查看pgdog is a PostgreSQL sharding proxy, distributed SQL router, and connection pooler. It is designed to enable horizontal data distribution by splitting tables and indices across multiple independent servers to scale storage and processing capacity. The project distinguishes itself through online resharding capabilities, using logical replication to move data between shards without application downtime. It supports multiple routing strategies, including hash, list, and range-based query routing, and manages distributed atomic transactions using a two-phase commit process to ensure consistency
Enables horizontal data distribution by splitting tables and indices across multiple independent PostgreSQL servers.
Rustload-balancerpoolerpostgresql
