You might find something interesting here ^_^
This guide walks through creating a multi‑tenant ad‑analytics SaaS using Citus, covering schema design, sharding by company_id, data ingestion, reference tables, online schema changes, tenant‑specific JSONB fields, hardware scaling, large‑tenant isolation, and migration steps with concrete SQL examples and commands.
Citus extends PostgreSQL into a shared‑nothing distributed system where a coordinator node routes queries to worker nodes, supporting distributed, reference, and local tables, shard placement, replication modes, co‑location, parallel execution, and configurable connection‑pool settings to scale storage and CPU across a cluster.
This guide explains how to combine a PostgreSQL Operator with Pgpool-II on Kubernetes to create a PostgreSQL cluster that supports query read‑load balancing and connection pooling, covering prerequisites, deployment steps, environment‑variable and ConfigMap configuration, backend settings, failover handling, password registration, streaming replication checks, SSL setup, and Prometheus monitoring.
Citus is an open‑source PostgreSQL extension that adds sharding, distributed tables and parallel query execution, enabling horizontal and vertical scaling for multi‑tenant SaaS, real‑time analytics, and massive workloads, while outlining acquisition options, practical use cases, and scenarios where it is unsuitable.
This tutorial walks through installing the CrunchyData Postgres Operator, creating a PostgreSQL cluster named hippo with kustomize, inspecting its resources, configuring services, secrets, and TLS for secure connections, modifying service types, deploying a Keycloak application using the generated credentials, and finally deleting the cluster while handling PVC retention.
The Crunchy Data Postgres Operator (PGO) extends Kubernetes to provide a cloud‑native, highly available PostgreSQL platform with features such as automated provisioning, disaster recovery, TLS encryption, monitoring, user management, upgrade handling, advanced replication, cloning, connection pooling, affinity, scheduled backups to S3/GCS, multi‑namespace support, and extensive customizability across major Kubernetes distributions.
This guide shows how to build Undermoon, run a master and replica Memory Broker, verify data replication, and manually switch to the replica via the coordinator API when the master fails, ensuring continued service operation.
Undermoon migrates Redis Cluster slots quickly and simply by orchestrating SCAN, DUMP, PTTL, RESTORE and DEL commands through migrating and importing proxies, balancing CPU load, handling delete‑prone keys, and achieving sub‑minute migration of 1 GB with throughput recovery.
This article provides a concise reference of the most frequently used Linkerd CLI commands and their associated flags, detailing how each command interacts with the control plane, injects proxies, and offers diagnostic and management capabilities for Kubernetes service meshes.
This step‑by‑step tutorial shows how to build Undermoon from source, deploy a memory broker, coordinator, two server proxies and four Redis nodes on a single machine, register them via JSON APIs, create a named cluster, and verify its operation with redis‑cli.
