You might find something interesting here ^_^
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.
The article explains how Citus lets you manually propagate SQL statements to workers, shards, or placements using functions like run_command_on_workers, run_command_on_shards, and run_command_on_placements, provides concrete examples, and outlines important limitations and safety considerations.
The article explains how a Citus cluster—comprising a coordinator and multiple workers—splits and routes SQL queries, detailing the distributed planner, executor, push‑pull handling of subqueries/CTEs, and a step‑by‑step EXPLAIN walkthrough of a top‑20 page‑views query.
This article explains how Citus extends PostgreSQL for distributed execution, detailing supported aggregation functions, count‑distinct handling, HyperLogLog columns, Top‑N estimation, percentile sketches with t‑digest, limit push‑down, view support, and various join strategies, while providing concrete SQL examples and configuration tips.
