citus
stolon
Our great sponsors
| citus | stolon | |
|---|---|---|
| 61 | 8 | |
| 9,801 | 4,525 | |
| 3.3% | 1.1% | |
| 9.5 | 2.2 | |
| 7 days ago | 5 months ago | |
| C | Go | |
| GNU Affero General Public License v3.0 | Apache License 2.0 |
Stars - the number of stars that a project has on GitHub. Growth - month over month growth in stars.
Activity is a relative number indicating how actively a project is being developed. Recent commits have higher weight than older ones.
For example, an activity of 9.0 indicates that a project is amongst the top 10% of the most actively developed projects that we are tracking.
citus
- SPQR 1.3.0: a production-ready system for horizontal scaling of PostgreSQL
- Citus: PostgreSQL extension that transforms Postgres into a distributed database
-
Figma's Databases team lived to tell the scale
I see they don't mention Citus (https://github.com/citusdata/citus), which is already a fairly mature native Postgres extension. From the details given in the article, in sounds like they just reimplemented it.
I wonder if they were unaware of it or disregarded it for a reason —I currently am in a similar situation as the one described in the blog, trying to shard a massive Postgres DB.
-
PostgreSQL Is Enough
It is possible, if you pay for it. You can do Multi-AZ Clustered Instances in RDS, where you get the benefits of Multi-AZ failover with traffic sharing.
If you can run your own infra – at least on an EC2 level – you can do things like Citus [0] for Postgres, which is about as close to "just add database nodes" as you'll get.
[0]: https://www.citusdata.com/
-
Vitess 18
So while searching for something like this for postgres I came across citus. Any one know how that stacks up?
https://github.com/citusdata/citus
- In-Depth Guide: Citus Technical Readme
-
Revolutionizing Database Scaling with CitusDB
References: CitusDB
- Squeeze the hell out of the system you have
- Show HN: Hydra 1.0 – open-source column-oriented Postgres
- Schema-based sharding comes to PostgreSQL with Citus
stolon
-
How to create postgres cluster in docker swarm?
There's one in the stolon repo.
- Falling for Kubernetes
-
Stackgres - postgresql operator
I personally use stolon: https://github.com/sorintlab/stolon and it works great.
- Stolon: PostgreSQL cloud native High Availability and more
-
PostgreSQL: Kubegres is available as open source
I wonder how is this compared to Stolon https://github.com/sorintlab/stolon?
- PostgreSQL 14 Released
- Ask HN: What could a modern database do that PostgreSQL and MySQL can't
What are some alternatives?
Greenplum - Greenplum Database - Massively Parallel PostgreSQL for Analytics. An open-source massively parallel data platform for analytics, machine learning and AI.
patroni - A template for PostgreSQL High Availability with Etcd, Consul, ZooKeeper, or Kubernetes
yugabyte-db - YugabyteDB - the cloud native distributed SQL database for mission-critical applications.
postgres - 🐘 Run PostgreSQL in Kubernetes
vitess - Vitess is a database clustering system for horizontal scaling of MySQL.
remco - remco is a lightweight configuration management tool
TimescaleDB - An open-source time-series SQL database optimized for fast ingest and complex queries. Packaged as a PostgreSQL extension.
zombodb - Making Postgres and Elasticsearch work together like it's 2023
dbt-core - dbt enables data analysts and engineers to transform their data using the same practices that software engineers use to build applications.
crunchy-proxy - PostgreSQL Connection Proxy by Crunchy Data (beta)
pg_auto_failover - Postgres extension and service for automated failover and high-availability
mysql-live-select - NPM Package to provide events on updated MySQL SELECT result sets