9 open-source projects similar to ankane/pgslice, ranked by how many features they have in common. Compare stars, activity and what each one does to find the best Pgslice alternative.
ShardingSphere is a distributed SQL database middleware that provides sharding, read-write splitting, and distributed transaction management for relational databases. It functions as a layer that intercepts SQL queries to distribute data across multiple physical database instances for horizontal scaling. The project is distinguished by its ability to operate as either a standalone transparent database proxy or via direct integration as a JDBC driver. It features a SQL dialect translator that parses queries into abstract syntax trees to convert syntax between different database engines, enabli
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
PostgreSQL Automatic Failover: High-Availibility for Postgres, based on Pacemaker and Corosync.
A High Scalability Solution for MySQL Clustering and High Availability
Stolon is a cloud native database manager and orchestrator for PostgreSQL. It functions as a high availability manager designed to automate failover, replication, and cluster management in distributed environments. The system coordinates synchronous and asynchronous data mirroring and uses a service discovery mechanism to dynamically detect database node addresses. It routes client traffic to the current primary instance through a proxy to maintain application access during role switches. The project covers disaster recovery through point-in-time recovery and the maintenance of multi-site st
Autobase is a self-hosted PostgreSQL database management platform and orchestrator designed to provide database-as-a-service capabilities. It automates the full lifecycle of PostgreSQL clusters, from initial provisioning and deployment to ongoing administration and decommissioning. The system distinguishes itself by treating database infrastructure as code, allowing clusters to be deployed and updated through version control and continuous integration pipelines. It provides both a centralized web console for visual management and programmatic interfaces for automating infrastructure orchestra
Vitess is a database clustering system for horizontal scaling of MySQL. It functions as a middleware layer that abstracts complex sharding and physical topology, allowing applications to interact with a distributed database environment through a unified interface. By intercepting and routing SQL queries across multiple shards, it enables large-scale data management while maintaining the appearance of a single database instance. The platform distinguishes itself through its ability to perform online schema migrations and distributed transaction coordination without requiring application downti
Patroni is a high availability manager and cluster orchestrator for PostgreSQL. It functions as a failover controller that monitors database health and manages leader transitions to ensure continuous availability and consistency across multiple nodes. The system relies on a distributed configuration store client to synchronize cluster state and perform leader election. It supports integration with external consensus services such as Etcd, Consul, and ZooKeeper, and provides specific orchestration capabilities for deploying clusters within Kubernetes environments. The project covers the manag