Problem: A production PostgreSQL 15.17 cluster managed by Patroni 3.3.2, with PgBouncer 1.25.1 in front of it, showed intermittent application failures during night operations. The application logged ODBC connection errors with SQLSTATE 08P01: “server login has been failing, cached error: connect failed (server_login_retry)”. The customer suspected PostgreSQL connection exhaustion. Metrics showed otherwise: max_connections was 4,000 […]
Knowledge Base Data Management and Analytics Database Case Studies Data Management and Analytics Database 1 Oct 2026 Recovering Cassandra nodes blocked by corrupted system_traces SSTables and oversized trace partitionsProblem: An on-prem Apache Cassandra 2.2.5 cluster had two of five nodes in its DR datacenter reporting DOWN in nodetool status, while the primary datacenter remained UP. The cluster had recently gone through a storage migration in which data was moved to larger disks by taking nodes offline and copying files. The failing nodes logged […]
Knowledge Base Data Management and Analytics Database Case Studies 28 Sep 2026 Infrastructure and Network RustFS: Open-Source S3-Compatible Object Storage Built in RustObject storage has quietly become the backbone of modern infrastructure, holding everything from application backups and media libraries to the training datasets behind AI models. For years, teams that wanted an S3-compatible system they could run themselves reached for MinIO, but a shift in that project’s licensing left many of them looking for a new […]
Storage RUS 25 Sep 2026 Removing manual DR rebuilds after primary-site failover for a Patroni PostgreSQL deploymentProblem: A two-site PostgreSQL 13.4 deployment managed by Patroni experienced replication breakage at the DR site after any failover inside the primary site. The DR standby leader’s primary_conninfo was hardcoded to the former primary node’s address, so when the primary role moved to the other primary-site node the standby kept attempting to connect to the […]
Knowledge Base Data Management and Analytics Database Case Studies 17 Sep 2026 PostgreSQL 15.17 (Patroni) — investigating high RAM usage with 4,000 connectionsProblem: A production Patroni-managed PostgreSQL 15.17 cluster (Patroni 3.3.2) reported persistent high memory consumption on database VMs, frequently exceeding 80% of allocated RAM and once reaching ~95% on a previous 300GB node. The deployment uses max_connections=4000 (cannot be reduced by the application), huge_pages configured as on with approximately 60,000 pages reserved, and vm.overcommit_memory=2 set per […]
Knowledge Base Data Management and Analytics Database Case Studies 1 Sep 2026 Communication and Collaboration CryptPad: End-to-End Encrypted Collaboration for the Privacy-ConsciousIn a web landscape crowded with single-purpose platforms, teams building community-driven websites often juggle a CMS for pages, a forum for discussions, and a handful of plugins for galleries, blogs, and chat. Composr CMS takes a different approach, delivering all of these capabilities as a single, tightly integrated open-source system. Trusted by organizations ranging from […]
Utility CRY 31 Aug 2026 Business and Enterprise Solutions Composr: Where Content Management Meets Social NetworkingIn a web landscape crowded with single-purpose platforms, teams building community-driven websites often juggle a CMS for pages, a forum for discussions, and a handful of plugins for galleries, blogs, and chat. Composr CMS takes a different approach, delivering all of these capabilities as a single, tightly integrated open-source system. Trusted by organizations ranging from […]
CMS COM 20 Aug 2026 Communication and Collaboration Chatto: The Fast, Secure, and Lightweight Chat ServerIn a world where modern communication tools are often bogged down by heavy resource usage and unnecessary bloat, finding a streamlined, highly performant alternative can be a challenge. Teams and communities need reliable chat platforms that protect their privacy without requiring an entire IT department to maintain. Chatto steps in as a refreshingly lightweight, ultra-fast […]
Communication CHA 4 Aug 2026 Troubleshooting high swap usage on an OpenSearch 2.9 nodeProblem: An OpenSearch 2.9 cluster (3 nodes) generated a critical alert: one node reported swap utilization at ~80%, with the OpenSearch process identified as the primary swap consumer. The node’s runtime Java command line showed -Xms10g -Xmx10g and -XX:MaxDirectMemorySize=5368709120 (5GB). The environment reported ~23 GB total RAM. The customer asked how to reduce swap use […]
Knowledge Base Data Management and Analytics Data Analytics