Proactive Insights and Support For Open-Source Applications
  • Applications
  • Platform
  • Support
  • Resources
    • OSS Research
    • FAQ
    • Newsflash
    • OSSpedia
    • How-to Guides
    • Case Studies
    • Articles
  • Company
    • About Us
    • The OSS in Hossted
  • Contact
Book a demo
  • Applications
  • Platform
  • Support
  • Resources
    • OSS Research
    • FAQ
    • Newsflash
    • OSSpedia
    • How-to Guides
    • Case Studies
    • Articles
  • Company
    • About Us
    • The OSS in Hossted
  • Contact
  • Home
  • Knowledge Base
  • Case Studies
  • Data Management and Analytics
  • Database

Database

All OSSpediaArticlesHow ToNewsflashCase Studies
Don't Miss out!
Join our newsletter for exclusive updates on open source innovations.

    Selected category
    • Communication and Collaboration
      • Communication
    • Project and Agile Management
      • IT Business Management
    • Data Management and Analytics
      • Data Management and Analytics
      • Data Analytics
      • Database
    • DevOps
      • Virtualization
      • Monitoring
      • Data Management and Analytics
      • Developer Tools
      • Application Development
    • Infrastructure and Network
      • Storage
      • Security
    10 Nov 2026 Resolving slow Patroni PostgreSQL replication caused by OpenZFS synchronous writes

    Problem: A production Patroni cluster (Patroni 3.3.2, PostgreSQL 15.17 on VMs) exhibited very slow replication between nodes, producing significant replication lag and impacting services. Replication throughput on the standby was measured in single MB/s ranges, nightly replay lag reached hours, and a recent switchover required a full base backup because the replica was unable to […]

    Knowledge Base Case Studies Data Management and Analytics Database
    29 Oct 2026 Resolving severe Patroni PostgreSQL replication slowdown and switchover failure caused by OpenZFS settings

    Problem: A client running a production Patroni PostgreSQL cluster on OpenZFS reported a critical incident. Replication between nodes had become extremely slow, a switchover had failed, and the cluster was running on a single node with no working standby, so a failure of that node would have caused total data loss. The client asked us […]

    Knowledge Base Case Studies Data Management and Analytics Database
    27 Oct 2026 Optimizing PgBouncer placement and configuration for Patroni PostgreSQL clusters

    Problem: A client running multiple Patroni-managed PostgreSQL high-availability clusters in production added PgBouncer on the database VMs. During load tests, they saw no CPU or RAM savings compared with direct application connections. They asked for the correct PgBouncer configuration approach, whether the pooler should run locally or on separate servers, and how it should fit […]

    Knowledge Base Case Studies Data Management and Analytics Database
    26 Oct 2026 Recovering a MariaDB Galera Cluster on Kubernetes Stuck in CrashLoopBackOff

    Problem The database went completely offline after the Kubernetes worker nodes restarted at the same time. A three-node MariaDB 10.5 Galera cluster, deployed with the Bitnami mariadb-galera Helm chart, did not come back. The first pod, mariadb-galera-0, entered CrashLoopBackOff and logged It may not be safe to bootstrap the cluster from this node. It was […]

    Database
    12 Oct 2026 Reducing JVM heap to stop Cassandra write timeouts caused by long GC pauses

    Problem: Clients reported write queries failing with timeout errors against an Apache Cassandra DC despite all production nodes appearing UP. Application and database logs showed request failures with “Unexpected exception during request” and quorum-level write timeouts. System logs contained FailureDetector warnings about not marking nodes down due to large local pauses and MessagingService warnings about […]

    Knowledge Base Case Studies Data Management and Analytics Database
    5 Oct 2026 Intermittent PgBouncer login rejections caused by IPv6 localhost resolution

    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
    18 Sep 2026 PostgreSQL WAL archive failures caused by incomplete copies and full filesystems

    Problem: A production PostgreSQL 15 instance experienced a Severity‑1 outage after the filesystem containing WAL files reached 100% usage. The customer observed failed Commvault log-backup jobs and that WAL segments were not being archived: SHOW archive_command returned an external script invocation (/path/to/archive_wal.sh %p %f). The shipped copy script used a “test ! -f … && […]

    Knowledge Base Case Studies Data Management and Analytics Database
    16 Sep 2026 PostgreSQL replication slot repeatedly went inactive; replica walreceiver stopped and did not reconnect

    Problem: A Patroni-managed PostgreSQL cluster showed recurring replication interruptions: the replica repeatedly reported a large streaming lag (initially ~565 MB, later observed ~5.5 GB) and the cluster’s physical replication slot on the leader appeared inactive (active = false, wal_status = reserved). Patroni logs on the primary had not recorded recent cluster events and appeared to […]

    Knowledge Base Case Studies Data Management and Analytics Database
    9 Sep 2026 PostgreSQL SSL handshake failures causing intermittent connection errors in a Patroni cluster

    Problem: A production PostgreSQL 15.8 deployment running inside a Patroni-managed HA cluster (Patroni 2.1.4) reported transient application failures where processes could not connect and surfaced the message “PostgreSQL connection error, Cannot connect to FX DB”. Database logs showed repeated messages indicating SSL accept-stage failures with the text “could not accept SSL connection: EOF detected”. The […]

    Knowledge Base Case Studies Data Management and Analytics Database
    Proactive Insights and Support For Open-Source Applications
    Company
    • About Hossted
    • Data Processing Addendum
    Solutions
    • Applications
    • Support Plans
    • About Solution
    Resources
    • FAQ
    • Knowledge Base

    © HOSSTED 2026 All rights reserved

    • Privacy Policy
    • Terms and Conditions
    • Cookies Policy
    Cookie Settings

    We use cookies to measure marketing efforts and improve our services. Please review the cookie settings and confirm your choice.

    Functional Always active
    The technical storage or access is strictly necessary for the legitimate purpose of enabling the use of a specific service explicitly requested by the subscriber or user, or for the sole purpose of carrying out the transmission of a communication over an electronic communications network.
    Preferences
    The technical storage or access is necessary for the legitimate purpose of storing preferences that are not requested by the subscriber or user.
    Statistics
    The technical storage or access that is used exclusively for statistical purposes. The technical storage or access that is used exclusively for anonymous statistical purposes. Without a subpoena, voluntary compliance on the part of your Internet Service Provider, or additional records from a third party, information stored or retrieved for this purpose alone cannot usually be used to identify you.
    Marketing
    The technical storage or access is required to create user profiles to send advertising, or to track the user on a website or across several websites for similar marketing purposes.
    • Manage options
    • Manage services
    • Manage {vendor_count} vendors
    • Read more about these purposes
    View preferences
    • {title}
    • {title}
    • {title}