2 repository-uri
Grouping database schemas as relocatable units across a cluster to enable automated resource rebalancing.
Distinct from Distributed Relational Databases: Distinct from Distributed Relational Databases: focuses on schema-level distribution for multi-tenancy rather than row-level sharding.
Explore 2 awesome GitHub repositories matching data & databases · Schema-Based Sharding. Refine with filters or upvote what's useful.
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
Distributed database systems distribute data by assigning individual database schemas to specific nodes, allowing multi-tenant applications to scale without modifying existing query logic.
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
Routes queries to different shards based on the fully qualified schema name of the tables.