You might find something interesting here ^_^
In early 2021 Notion transformed its monolithic PostgreSQL into a horizontally partitioned fleet by sharding the block table and related data, using workspace IDs as the partition key, migrating through double‑write, backfill, and verification steps, and learning hard lessons about timing, zero‑downtime, and schema design.
This guide explains how Citus shards data across machines to horizontally scale SQL queries for workloads over 100 GB, then walks through cloning the Citus 11 docs repository, setting up a pyenv‑based Python environment, installing Sphinx requirements, and launching the documentation in watch mode for local browsing.
This guide shows how to use the Bitnami postgresql‑repmgr Docker image, which includes the Replication Manager tool, to create a high‑availability PostgreSQL cluster with streaming replication, failover, persistent storage, Docker networking, optional TLS, and upgrade procedures.
This guide shows how to use the Bitnami PostgreSQL Docker image to create a master‑slave streaming replication cluster, configure required environment variables, launch containers with Docker run or Docker Compose, scale slaves, enable synchronous commit, and handle failover with a trigger file.
Stolon is an open‑source, cloud‑native manager that provides high‑availability for PostgreSQL by leveraging streaming replication, supporting any topology, integrating with Kubernetes, and using etcd, Consul, or the Kubernetes API for leader election and cluster storage.
This guide walks through using the Postgres Operator UI to create, start, update, and delete PostgreSQL clusters on Kubernetes, covering UI navigation, configuration options, troubleshooting steps, and limitations, with links to detailed documentation.
The Zalando Postgres Operator enables easy deployment of high‑availability PostgreSQL clusters on Kubernetes using Patroni, managed entirely through CRDs, supporting rolling updates, sidecar monitoring, and seamless CI/CD integration without direct API calls.
This guide walks you through prerequisites, configuration, and deployment options (manual, Kustomize, Helm) for the Zalando Postgres Operator on a local Kubernetes environment, then shows how to verify the operator, deploy its UI, create and connect to a Postgres cluster, and safely delete it.
Rb (Redis Blaster) is a Python library built on python‑redis that provides a custom routing system for non‑replicated sharding, allowing automatic key‑based routing, parallel execution, fan‑out and mapping across multiple Redis nodes without manual request distribution.
The article explains how Citus extends PostgreSQL to provide distributed tables with full single‑node SQL coverage, enumerates the cross‑node SQL features it cannot handle, and demonstrates concrete workarounds using CTEs and temporary tables with detailed code examples.
