# SeveralNines

Get expert, in-depth ops articles on MySQL, MariaDB, MongoDB, Elasticsearch and more plus Severalnines' product and Sovereign DBaaS updates.

This is one page of public article previews, not the complete archive. Follow Next page to continue. Summaries are not the original full articles.

## ClickHouse Security, Compliance and Governance in Polyglot Environments

DevFeed: [ClickHouse Security, Compliance and Governance in Polyglot Environments](<https://devfeed.tech/articles/clickhouse-security-compliance-and-governance-in-polyglot-environments-146542.md>)

Original publisher: [Read original article](<https://severalnines.com/blog/clickhouse-security-compliance-and-governance-in-polyglot-environments/>)

Author: Paul Namuag

Published: 2026-11-19T22:47:51Z

Content type: article

Language: en

Sources: [SeveralNines](<https://devfeed.tech/sources/severalnines.md>)

Topics: [Security](<https://devfeed.tech/topics/security.md>), [audit](<https://devfeed.tech/topics/audit.md>), [observability](<https://devfeed.tech/topics/observability.md>)

Tags: [access-control](<https://devfeed.tech/tags/access-control.md>), [access-controls](<https://devfeed.tech/tags/access-controls.md>), [analytics](<https://devfeed.tech/tags/analytics.md>), [architecture](<https://devfeed.tech/tags/architecture.md>), [audit](<https://devfeed.tech/tags/audit.md>), [audit-log](<https://devfeed.tech/tags/audit-log.md>), [audit-logging](<https://devfeed.tech/tags/audit-logging.md>), [audit-logs](<https://devfeed.tech/tags/audit-logs.md>), [authentication](<https://devfeed.tech/tags/authentication.md>), [authorization](<https://devfeed.tech/tags/authorization.md>), [clickhouse](<https://devfeed.tech/tags/clickhouse.md>), [compliance](<https://devfeed.tech/tags/compliance.md>), [data-governance](<https://devfeed.tech/tags/data-governance.md>), [database-security](<https://devfeed.tech/tags/database-security.md>), [environments](<https://devfeed.tech/tags/environments.md>), [governance](<https://devfeed.tech/tags/governance.md>), [hybrid](<https://devfeed.tech/tags/hybrid.md>), [hybrid-cloud](<https://devfeed.tech/tags/hybrid-cloud.md>), [hybrid-operations](<https://devfeed.tech/tags/hybrid-operations.md>), [mysql](<https://devfeed.tech/tags/mysql.md>), [oltp](<https://devfeed.tech/tags/oltp.md>), [rbac](<https://devfeed.tech/tags/rbac.md>), [security](<https://devfeed.tech/tags/security.md>), [security-compliance](<https://devfeed.tech/tags/security-compliance.md>)

### AI overview

For production ClickHouse, lock down the default account, use SQL-driven RBAC with least-privilege roles, configure TLS for client and interserver traffic, and retain and centralize audit logs. The article contrasts RBAC, available since version 20.1, with legacy XML user configuration, which lacks true roles and is harder to audit and maintain. It recommends a canonical identity source, automated access updates across database engines, periodic drift checks, and lineage tracking for ingested data. Hybrid deployments also need private network access, a consistent key-management strategy, and explicit log forwarding. A support-engineer checklist covers deployment and ongoing reviews, credential rotation, monitoring, and patching. ClusterControl is described as providing multi-engine visibility and ClickHouse cluster operations; identity policy reconciliation and audit collection still require complementary controls and procedures.

### Source excerpt

In our previous blog, we tackled monitoring with observability for ClickHouse. We also addressed hybrid OLTP/analytics database architecture, where data originates from MySQL and flows into ClickHouse. However, running ClickHouse in a hybrid environment also means you need to think about security and compliance. This blog covers the key practices you should have in place, [...] The post ClickHouse Security, Compliance and Governance in Polyglot Environments appeared first on Severalnines.

## PostgreSQL + ClickHouse Recovery: Test the Whole Data Service

DevFeed: [PostgreSQL + ClickHouse Recovery: Test the Whole Data Service](<https://devfeed.tech/articles/postgresql-clickhouse-recovery-test-the-whole-data-service-132583.md>)

Original publisher: [Read original article](<https://severalnines.com/blog/postgresql-clickhouse-recovery-test-the-whole-data-service/>)

Author: Jessie Baynas

Published: 2026-11-13T11:47:17Z

Content type: tutorial

Language: en

Sources: [SeveralNines](<https://devfeed.tech/sources/severalnines.md>)

Topics: [Disaster Recovery](<https://devfeed.tech/topics/disaster-recovery.md>), [DataOps](<https://devfeed.tech/topics/dataops.md>), [Apache Kafka](<https://devfeed.tech/topics/apache-kafka.md>), [Synthetic Data Generation](<https://devfeed.tech/topics/synthetic-data-generation.md>)

Tags: [acceptance](<https://devfeed.tech/tags/acceptance.md>), [analytics](<https://devfeed.tech/tags/analytics.md>), [application](<https://devfeed.tech/tags/application.md>), [backup](<https://devfeed.tech/tags/backup.md>), [backup-management](<https://devfeed.tech/tags/backup-management.md>), [change-data-capture](<https://devfeed.tech/tags/change-data-capture.md>), [clickhouse](<https://devfeed.tech/tags/clickhouse.md>), [clustercontrol](<https://devfeed.tech/tags/clustercontrol.md>), [data](<https://devfeed.tech/tags/data.md>), [debezium](<https://devfeed.tech/tags/debezium.md>), [kafka](<https://devfeed.tech/tags/kafka.md>), [modern-data-stack-operations](<https://devfeed.tech/tags/modern-data-stack-operations.md>), [offset](<https://devfeed.tech/tags/offset.md>), [postgresql](<https://devfeed.tech/tags/postgresql.md>), [reconciliation](<https://devfeed.tech/tags/reconciliation.md>), [recovery](<https://devfeed.tech/tags/recovery.md>), [restoration](<https://devfeed.tech/tags/restoration.md>), [restore](<https://devfeed.tech/tags/restore.md>), [service](<https://devfeed.tech/tags/service.md>), [test](<https://devfeed.tech/tags/test.md>), [updates](<https://devfeed.tech/tags/updates.md>)

### AI overview

A green restore and zero Kafka lag do not prove that ClickHouse analytics are correct. In this PostgreSQL-Debezium-Kafka-ClickHouse exercise, the team records the backup's last applied Kafka offset, rewinds the consumer group before restoring, then waits for a source-backed, stable recovery boundary. It reconciles PostgreSQL and ClickHouse against independently generated expected results, checking keys, values, updates, deletes, outage-window inserts, and the dashboard query. ReplacingMergeTree checks use FINAL or version-based selection and filter delete markers; LSN versions make replayed events idempotent. The walkthrough's negative test skips the rewind: ingestion resumes and lag reaches zero, yet pre-outage updates and a delete are missing. PostgreSQL can rebuild ClickHouse only while it retains all needed rows; purged history depends on ClickHouse backups and retained Kafka events. The lab timings are not production targets, and PostgreSQL loss, Kafka loss, node loss with on-node backups, and retained-history recovery are outside the tested sequence.

### Source excerpt

A successful restore does not prove that an analytics service is delivering correct data. This PostgreSQL + ClickHouse walkthrough uses Debezium and Kafka to test backup restoration, offset replay, updates, deletes, and application-level reconciliation--including a negative test that catches a seemingly healthy but incomplete recovery. The post PostgreSQL + ClickHouse Recovery: Test the Whole Data Service appeared first on Severalnines.

## Safe database change at fleet scale: canaries, maintenance waves, and recovery gates

DevFeed: [Safe database change at fleet scale: canaries, maintenance waves, and recovery gates](<https://devfeed.tech/articles/safe-database-change-at-fleet-scale-canaries-maintenance-waves-and-recovery-gates-121139.md>)

Original publisher: [Read original article](<https://severalnines.com/blog/safe-database-change-at-fleet-scale-canaries-maintenance-waves-and-recovery-gates/>)

Author: Sebastian Insausti

Published: 2026-11-06T11:37:15Z

Content type: tutorial

Language: en

Sources: [SeveralNines](<https://devfeed.tech/sources/severalnines.md>)

Topics: [Insight for DBAs](<https://devfeed.tech/topics/insight-for-dbas.md>), [ClusterControl](<https://devfeed.tech/topics/clustercontrol.md>), [canary release](<https://devfeed.tech/topics/canary-release.md>), [Disaster Recovery](<https://devfeed.tech/topics/disaster-recovery.md>), [Database](<https://devfeed.tech/topics/database.md>), [read-replica](<https://devfeed.tech/topics/read-replica.md>)

Tags: [canary](<https://devfeed.tech/tags/canary.md>), [change](<https://devfeed.tech/tags/change.md>), [clustercontrol](<https://devfeed.tech/tags/clustercontrol.md>), [configuration-management](<https://devfeed.tech/tags/configuration-management.md>), [custom](<https://devfeed.tech/tags/custom.md>), [database](<https://devfeed.tech/tags/database.md>), [fleet](<https://devfeed.tech/tags/fleet.md>), [maintenance](<https://devfeed.tech/tags/maintenance.md>), [modern-data-stack-operations](<https://devfeed.tech/tags/modern-data-stack-operations.md>), [postgresql](<https://devfeed.tech/tags/postgresql.md>), [recovery](<https://devfeed.tech/tags/recovery.md>), [scale](<https://devfeed.tech/tags/scale.md>), [scripts](<https://devfeed.tech/tags/scripts.md>)

### AI overview

For a PostgreSQL minor update across a fleet, the article uses preflight checks on every target, one representative canary, and sequential waves that stop at the first failed gate. In its three-cluster lab, a missing package in the approved mirror caused preflight to fail while all databases stayed on the old version; after the mirror was fixed, the canary and both wave targets passed acceptance. The tested canary had a brief write interruption, measured by one-second probe timestamps. ClusterControl runs upgrade jobs, while preflight, sequencing, validation, and go/no-go decisions rely on custom scripts or people; its upgrade job has no rollback operation and may leave a failed node for manual recovery. The lab also tested reinstalling the prior minor build, subject to release-note review and acceptance checks. Results are a method demonstration, not evidence of fleet-scale capacity or major-upgrade safety.

### Source excerpt

How do you change a database fleet without creating a fleet-wide incident? This PostgreSQL walkthrough demonstrates preflight checks, a representative canary, sequential maintenance waves, and a tested recovery path--with clear boundaries between ClusterControl jobs, custom scripts, and manual decisions. The post Safe database change at fleet scale: canaries, maintenance waves, and recovery gates appeared first on Severalnines.

## PostgreSQL Infrastructure as Code: Consistent Deployment and Operations

DevFeed: [PostgreSQL Infrastructure as Code: Consistent Deployment and Operations](<https://devfeed.tech/articles/postgresql-infrastructure-as-code-consistent-deployment-and-operations-88442.md>)

Original publisher: [Read original article](<https://severalnines.com/blog/postgresql-infrastructure-as-code-consistent-deployment-and-operations/>)

Author: Jessie Baynas

Published: 2026-10-16T06:00:00Z

Content type: tutorial

Language: en

Sources: [SeveralNines](<https://devfeed.tech/sources/severalnines.md>)

Topics: [iac-security](<https://devfeed.tech/topics/iac-security.md>), [PostgreSQL](<https://devfeed.tech/topics/postgresql.md>), [Terraform](<https://devfeed.tech/topics/terraform.md>)

Tags: [ansible](<https://devfeed.tech/tags/ansible.md>), [configuration-management](<https://devfeed.tech/tags/configuration-management.md>), [database-automation](<https://devfeed.tech/tags/database-automation.md>), [deployment](<https://devfeed.tech/tags/deployment.md>), [deployment-scaling](<https://devfeed.tech/tags/deployment-scaling.md>), [infrastructure](<https://devfeed.tech/tags/infrastructure.md>), [infrastructure-as-code](<https://devfeed.tech/tags/infrastructure-as-code.md>), [operations](<https://devfeed.tech/tags/operations.md>), [postgresql](<https://devfeed.tech/tags/postgresql.md>), [puppet](<https://devfeed.tech/tags/puppet.md>), [terraform](<https://devfeed.tech/tags/terraform.md>)

### AI overview

This tutorial explains how infrastructure as code can make PostgreSQL environments more consistent through versioned provisioning and configuration. It distinguishes infrastructure management from persistent data and schema migrations, describes how Terraform, Ansible, Puppet, Helm, and Chef can fit into a toolchain, and shows ways to automate PostgreSQL operations with ClusterControl. It also covers testing schema migrations in CI and keeping database tasks from being managed by conflicting systems.

### Source excerpt

Every team running PostgreSQL eventually runs into the same problem: someone tunes a database by hand on a Tuesday afternoon, and six months later nobody can reproduce it. A new environment gets spun up "close enough" to production, a config setting drifts, a role never gets created, and a five minute incident turns into a [...] The post PostgreSQL Infrastructure as Code: Consistent Deployment and Operations appeared first on Severalnines.

## Automated Database Failover: Why Homegrown High Availability Struggles At Scale

DevFeed: [Automated Database Failover: Why Homegrown High Availability Struggles At Scale](<https://devfeed.tech/articles/automated-database-failover-why-homegrown-high-availability-struggles-at-scale-63795.md>)

Original publisher: [Read original article](<https://severalnines.com/blog/automated-database-failover-why-homegrown-high-availability-struggles-at-scale/>)

Author: Paul Namuag

Published: 2026-10-02T07:49:19Z

Content type: article

Language: en

Sources: [SeveralNines](<https://devfeed.tech/sources/severalnines.md>)

Topics: [Availability](<https://devfeed.tech/topics/availability.md>), [patroni](<https://devfeed.tech/topics/patroni.md>), [ClusterControl](<https://devfeed.tech/topics/clustercontrol.md>), [read-replica](<https://devfeed.tech/topics/read-replica.md>)

Tags: [automation](<https://devfeed.tech/tags/automation.md>), [clustercontrol](<https://devfeed.tech/tags/clustercontrol.md>), [database](<https://devfeed.tech/tags/database.md>), [database-automation](<https://devfeed.tech/tags/database-automation.md>), [failover](<https://devfeed.tech/tags/failover.md>), [high-availability](<https://devfeed.tech/tags/high-availability.md>), [mariadb](<https://devfeed.tech/tags/mariadb.md>), [mysql](<https://devfeed.tech/tags/mysql.md>), [postgresql](<https://devfeed.tech/tags/postgresql.md>), [recovery-repair](<https://devfeed.tech/tags/recovery-repair.md>), [replication](<https://devfeed.tech/tags/replication.md>), [scale](<https://devfeed.tech/tags/scale.md>)

### AI overview

The article explains why homegrown database failover systems become difficult to maintain as database engines, topologies, and environments multiply. It describes failure detection, replica selection, fencing, traffic routing, and recovery challenges, then presents ClusterControl's automated recovery workflows and their limits, including that cross-cluster failover requires a deliberate decision. It recommends testing recovery in staging and revisiting tests after topology changes.

### Source excerpt

I've encountered DBAs and ops engineers who shared war stories of running production long before automation and modern tooling went mainstream. Experiencing sudden primary faults during sleeping hours, getting paged, logging in to squint over trace logs that show replication lag on all replicas and working out which one is furthest ahead, promoting it, editing [...] The post Automated Database Failover: Why Homegrown High Availability Struggles At Scale appeared first on Severalnines.

## How to Build a PostgreSQL CI/CD Pipeline with GitOps and Kubernetes

DevFeed: [How to Build a PostgreSQL CI/CD Pipeline with GitOps and Kubernetes](<https://devfeed.tech/articles/how-to-build-a-postgresql-ci-cd-pipeline-with-gitops-and-kubernetes-59792.md>)

Original publisher: [Read original article](<https://severalnines.com/blog/how-to-build-a-postgresql-ci-cd-pipeline-with-gitops-and-kubernetes/>)

Author: Kyle Buzzell

Published: 2026-09-25T07:00:00Z

Content type: tutorial

Language: en

Sources: [SeveralNines](<https://devfeed.tech/sources/severalnines.md>)

Topics: [CI/CD](<https://devfeed.tech/topics/cicd.md>), [PostgreSQL](<https://devfeed.tech/topics/postgresql.md>), [GitOps](<https://devfeed.tech/topics/gitops.md>), [Kubernetes](<https://devfeed.tech/topics/kubernetes.md>), [ClusterControl](<https://devfeed.tech/topics/clustercontrol.md>), [Deployment](<https://devfeed.tech/topics/deployment.md>), [Replication](<https://devfeed.tech/topics/replication.md>), [container](<https://devfeed.tech/topics/container.md>), [Docker](<https://devfeed.tech/topics/docker.md>)

Tags: [application](<https://devfeed.tech/tags/application.md>), [argocd](<https://devfeed.tech/tags/argocd.md>), [ci-cd](<https://devfeed.tech/tags/ci-cd.md>), [cloudnativepg](<https://devfeed.tech/tags/cloudnativepg.md>), [clustercontrol](<https://devfeed.tech/tags/clustercontrol.md>), [containers](<https://devfeed.tech/tags/containers.md>), [databases](<https://devfeed.tech/tags/databases.md>), [deployment](<https://devfeed.tech/tags/deployment.md>), [deployment-scaling](<https://devfeed.tech/tags/deployment-scaling.md>), [gitops](<https://devfeed.tech/tags/gitops.md>), [infrastructure](<https://devfeed.tech/tags/infrastructure.md>), [kubernetes](<https://devfeed.tech/tags/kubernetes.md>), [postgresql](<https://devfeed.tech/tags/postgresql.md>), [replication](<https://devfeed.tech/tags/replication.md>)

### AI overview

A tutorial on building a PostgreSQL CI/CD pipeline using GitOps and Kubernetes. It explains declarative database deployments, immutable containers, replication, failover, storage, backups, drift detection, credential rotation, and operational tooling such as ClusterControl.

### Source excerpt

Application teams have been living in Git-driven, immutable-deployment land for years. Databases lagged for good reason: That gap has closed considerably now that Kubernetes operators understand PostgreSQL well enough to manage replication, failover, and storage declaratively. What's still missing in a lot of pipelines is the operational layer that sits on top of "it deployed", [...] The post How to Build a PostgreSQL CI/CD Pipeline with GitOps and Kubernetes appeared first on Severalnines.

## Implementing GitOps from Infrastructure to DB Operators to Unify Ops for Kubernetes Databases

DevFeed: [Implementing GitOps from Infrastructure to DB Operators to Unify Ops for Kubernetes Databases](<https://devfeed.tech/articles/implementing-gitops-from-infrastructure-to-db-operators-to-unify-ops-for-kubernetes-databases-30848.md>)

Original publisher: [Read original article](<https://severalnines.com/blog/implementing-gitops-from-infrastructure-to-db-operators-to-unify-ops-for-kubernetes-databases/>)

Author: Sucahyo Ardy Prasetiyo

Published: 2026-09-16T08:57:10Z

Content type: tutorial

Language: en

Sources: [SeveralNines](<https://devfeed.tech/sources/severalnines.md>)

Topics: [GitOps](<https://devfeed.tech/topics/gitops.md>), [Kubernetes](<https://devfeed.tech/topics/kubernetes.md>), [Terraform](<https://devfeed.tech/topics/terraform.md>), [Argo CD](<https://devfeed.tech/topics/argo-cd.md>), [ClusterControl](<https://devfeed.tech/topics/clustercontrol.md>), [Database](<https://devfeed.tech/topics/database.md>), [opentofu](<https://devfeed.tech/topics/opentofu.md>)

Tags: [argo-cd](<https://devfeed.tech/tags/argo-cd.md>), [argocd](<https://devfeed.tech/tags/argocd.md>), [clustercontrol](<https://devfeed.tech/tags/clustercontrol.md>), [database-operators](<https://devfeed.tech/tags/database-operators.md>), [databases](<https://devfeed.tech/tags/databases.md>), [deployment-scaling](<https://devfeed.tech/tags/deployment-scaling.md>), [gitops](<https://devfeed.tech/tags/gitops.md>), [hybrid-operations](<https://devfeed.tech/tags/hybrid-operations.md>), [infrastructure](<https://devfeed.tech/tags/infrastructure.md>), [infrastructure-as-code](<https://devfeed.tech/tags/infrastructure-as-code.md>), [kubernetes](<https://devfeed.tech/tags/kubernetes.md>), [opentofu](<https://devfeed.tech/tags/opentofu.md>), [sovereign-dbaas](<https://devfeed.tech/tags/sovereign-dbaas.md>), [terraform](<https://devfeed.tech/tags/terraform.md>)

### AI overview

This article describes a layered GitOps approach for Kubernetes database platforms: manage infrastructure with Terraform or OpenTofu, manage Kubernetes deployments with Argo CD, and standardize operations for operator-managed databases with ClusterControl. It explains how declarative configuration and drift reconciliation differ between Terraform and Argo CD, and compares infrastructure automation options including Atlantis and Flux tf-controller.

### Source excerpt

Most platform teams already use GitOps for their Kubernetes apps. The config lives in Git, Argo CD applies it, and deployments are predictable. But look one layer down and things get messy. Infrastructure setup is often still done by hand, running Terraform locally or through scattered scripts. Database operations, especially for databases running through Kubernetes [...] The post Implementing GitOps from Infrastructure to DB Operators to Unify Ops for Kubernetes Databases appeared first on Severalnines.

## Postgres + ClickHouse Architectural Patterns

DevFeed: [Postgres + ClickHouse Architectural Patterns](<https://devfeed.tech/articles/postgres-clickhouse-architectural-patterns-19116.md>)

Original publisher: [Read original article](<https://severalnines.com/blog/postgres-clickhouse-architectural-patterns/>)

Author: Agus Syafaat

Published: 2026-08-26T08:08:43Z

Content type: article

Language: en

Sources: [SeveralNines](<https://devfeed.tech/sources/severalnines.md>)

Topics: [clickhouse](<https://devfeed.tech/topics/clickhouse.md>), [Database](<https://devfeed.tech/topics/database.md>), [software-architecture](<https://devfeed.tech/topics/software-architecture.md>), [rdbms](<https://devfeed.tech/topics/rdbms.md>), [streaming data analytics](<https://devfeed.tech/topics/streaming-data-analytics.md>), [Latency](<https://devfeed.tech/topics/latency.md>), [Data analysis](<https://devfeed.tech/topics/data-analysis.md>), [Data visualization](<https://devfeed.tech/topics/data-visualization.md>)

Tags: [acid](<https://devfeed.tech/tags/acid.md>), [analytics](<https://devfeed.tech/tags/analytics.md>), [clickhouse](<https://devfeed.tech/tags/clickhouse.md>), [clustercontrol](<https://devfeed.tech/tags/clustercontrol.md>), [concurrent](<https://devfeed.tech/tags/concurrent.md>), [continuous](<https://devfeed.tech/tags/continuous.md>), [cpu](<https://devfeed.tech/tags/cpu.md>), [dashboards](<https://devfeed.tech/tags/dashboards.md>), [data-platforms](<https://devfeed.tech/tags/data-platforms.md>), [database](<https://devfeed.tech/tags/database.md>), [database-general](<https://devfeed.tech/tags/database-general.md>), [databases](<https://devfeed.tech/tags/databases.md>), [hybrid-operations](<https://devfeed.tech/tags/hybrid-operations.md>), [latency](<https://devfeed.tech/tags/latency.md>), [learning](<https://devfeed.tech/tags/learning.md>), [low-latency](<https://devfeed.tech/tags/low-latency.md>), [machine-learning](<https://devfeed.tech/tags/machine-learning.md>), [patterns](<https://devfeed.tech/tags/patterns.md>), [postgres](<https://devfeed.tech/tags/postgres.md>), [real-time](<https://devfeed.tech/tags/real-time.md>), [real-time-analytics](<https://devfeed.tech/tags/real-time-analytics.md>), [transaction](<https://devfeed.tech/tags/transaction.md>), [volumes](<https://devfeed.tech/tags/volumes.md>)

### AI overview

The excerpt presents PostgreSQL and ClickHouse as complementary databases: PostgreSQL remains the authoritative system for low-latency transactions, while ClickHouse handles large analytical queries that could strain production transaction performance. It describes continuous change data capture (CDC) synchronization as the connection between them, separating transactional and analytical workloads without complex ETL pipelines. The excerpt begins a real-time analytics pattern but cuts off before its implementation details.

### Source excerpt

The role of databases has shifted significantly as modern applications must deliver real-time analytics, dashboards, and machine learning alongside low-latency transaction processing. Handling these diverse demands with a single relational database has become unsustainable under growing data volumes. Consequently, organizations are adopting specialized database architectures where multiple engines work together based on their strengths, allowing [...] The post Postgres + ClickHouse Architectural Patterns appeared first on Severalnines.

## ClusterControl 2.5.0 brings ClickHouse support to on-prem, cloud and hybrid environments

DevFeed: [ClusterControl 2.5.0 brings ClickHouse support to on-prem, cloud and hybrid environments](<https://devfeed.tech/articles/clustercontrol-2-5-0-brings-clickhouse-support-to-on-prem-cloud-and-hybrid-environments-19113.md>)

Original publisher: [Read original article](<https://severalnines.com/blog/clustercontrol-2-5-0-brings-clickhouse-support-to-on-prem-cloud-and-hybrid-environments/>)

Author: Kyle Buzzell

Published: 2026-08-05T08:38:18Z

Content type: release

Language: en

Sources: [SeveralNines](<https://devfeed.tech/sources/severalnines.md>)

Topics: [ClusterControl](<https://devfeed.tech/topics/clustercontrol.md>), [on-prem](<https://devfeed.tech/topics/on-prem.md>), [Database](<https://devfeed.tech/topics/database.md>)

Tags: [analytics](<https://devfeed.tech/tags/analytics.md>), [api](<https://devfeed.tech/tags/api.md>), [automation](<https://devfeed.tech/tags/automation.md>), [backup](<https://devfeed.tech/tags/backup.md>), [backups](<https://devfeed.tech/tags/backups.md>), [clickhouse](<https://devfeed.tech/tags/clickhouse.md>), [cloud](<https://devfeed.tech/tags/cloud.md>), [cluster](<https://devfeed.tech/tags/cluster.md>), [clustercontrol](<https://devfeed.tech/tags/clustercontrol.md>), [clustercontrol-releases](<https://devfeed.tech/tags/clustercontrol-releases.md>), [clustercontrol-v2-5-0](<https://devfeed.tech/tags/clustercontrol-v2-5-0.md>), [clusters](<https://devfeed.tech/tags/clusters.md>), [database](<https://devfeed.tech/tags/database.md>), [deploy](<https://devfeed.tech/tags/deploy.md>), [environments](<https://devfeed.tech/tags/environments.md>), [hybrid](<https://devfeed.tech/tags/hybrid.md>), [hybrid-environments](<https://devfeed.tech/tags/hybrid-environments.md>), [olap](<https://devfeed.tech/tags/olap.md>), [on-prem](<https://devfeed.tech/tags/on-prem.md>), [platform](<https://devfeed.tech/tags/platform.md>), [run](<https://devfeed.tech/tags/run.md>), [sovereign-dbaas](<https://devfeed.tech/tags/sovereign-dbaas.md>), [support](<https://devfeed.tech/tags/support.md>)

### AI overview

ClusterControl 2.5.0 adds lifecycle automation for ClickHouse on premises, in cloud, and in hybrid environments under the same control plane as supported transactional databases. The excerpt says users can deploy single-node instances or replicated clusters with embedded Keeper, monitor and alert through unified dashboards, back up and restore, scale, import existing clusters, and operate through the s9s CLI, API, or UI. It also describes SSL-encrypted inter-node communication with per-node certificates. ClickHouse can run standalone or alongside MySQL, PostgreSQL, MongoDB, and Redis as an OLAP tier. The excerpt also mentions PostgreSQL backup workflow improvements, usage metering, and the return of a ClusterControl v1 capability, but does not detail them.

### Source excerpt

ClusterControl 2.5.0 is here, and it marks a milestone for the platform: ClickHouse joins the family of supported database engines -- and with it, a capability no analytics vendor's cloud can offer you. Wherever you run ClusterControl -- on-premises, in any cloud, or hybrid -- you can now deploy ClickHouse either as a standalone OLAP [...] The post ClusterControl 2.5.0 brings ClickHouse support to on-prem, cloud and hybrid environments appeared first on Severalnines.

## ClickHouse Schema Design and Data Modeling

DevFeed: [ClickHouse Schema Design and Data Modeling](<https://devfeed.tech/articles/clickhouse-schema-design-and-data-modeling-19112.md>)

Original publisher: [Read original article](<https://severalnines.com/blog/clickhouse-schema-design-and-data-modeling/>)

Author: Agus Syafaat

Published: 2026-07-17T12:48:53Z

Content type: article

Language: en

Sources: [SeveralNines](<https://devfeed.tech/sources/severalnines.md>)

Topics: [schema design](<https://devfeed.tech/topics/schema-design.md>), [clickhouse](<https://devfeed.tech/topics/clickhouse.md>), [data-modeling](<https://devfeed.tech/topics/data-modeling.md>)

Tags: [announcement](<https://devfeed.tech/tags/announcement.md>), [article](<https://devfeed.tech/tags/article.md>), [clickhouse](<https://devfeed.tech/tags/clickhouse.md>), [cluster](<https://devfeed.tech/tags/cluster.md>), [concepts](<https://devfeed.tech/tags/concepts.md>), [core](<https://devfeed.tech/tags/core.md>), [cta](<https://devfeed.tech/tags/cta.md>), [data](<https://devfeed.tech/tags/data.md>), [data-modeling](<https://devfeed.tech/tags/data-modeling.md>), [database](<https://devfeed.tech/tags/database.md>), [database-general](<https://devfeed.tech/tags/database-general.md>), [deploy](<https://devfeed.tech/tags/deploy.md>), [design](<https://devfeed.tech/tags/design.md>), [distributed](<https://devfeed.tech/tags/distributed.md>), [distribution](<https://devfeed.tech/tags/distribution.md>), [engine](<https://devfeed.tech/tags/engine.md>), [hardware](<https://devfeed.tech/tags/hardware.md>), [modeling](<https://devfeed.tech/tags/modeling.md>), [queries](<https://devfeed.tech/tags/queries.md>), [query](<https://devfeed.tech/tags/query.md>), [schema](<https://devfeed.tech/tags/schema.md>), [schema-design](<https://devfeed.tech/tags/schema-design.md>)

### AI overview

The excerpt explains ClickHouse's cluster table model: shards hold different horizontal slices of data, while replicas within a shard hold identical copies for fault tolerance. Local tables store each node's shard data; distributed tables store no data and route queries across shards, then collect and merge results. Schema changes must be applied to local tables on every node, with the distributed table definition kept in sync. The article frames schema design as an ongoing operational concern: poor decisions can contribute to slow queries, oversized partitions, and long-running mutations. The excerpt begins to discuss shard-key selection but cuts off before giving guidance.

### Source excerpt

Sometimes, we see ClickHouse queries that should normally complete in milliseconds take several seconds to finish or worse, time out entirely. When that happens, there is a good chance that the schema is the real culprit. The problem is often not the query itself, nor is it a hardware bottleneck. Instead, it can stem from [...] The post ClickHouse Schema Design and Data Modeling appeared first on Severalnines.

## Building a Modern Analytics Stack Around ClickHouse

DevFeed: [Building a Modern Analytics Stack Around ClickHouse](<https://devfeed.tech/articles/building-a-modern-analytics-stack-around-clickhouse-19109.md>)

Original publisher: [Read original article](<https://severalnines.com/blog/building-a-modern-analytics-stack-around-clickhouse/>)

Author: Sebastian Insausti

Published: 2026-07-01T10:35:21Z

Content type: article

Language: en

Sources: [SeveralNines](<https://devfeed.tech/sources/severalnines.md>)

Topics: [analytics stack](<https://devfeed.tech/topics/analytics-stack.md>), [streaming data analytics](<https://devfeed.tech/topics/streaming-data-analytics.md>), [Database](<https://devfeed.tech/topics/database.md>)

Tags: [analytics](<https://devfeed.tech/tags/analytics.md>), [analytics-stack](<https://devfeed.tech/tags/analytics-stack.md>), [apache](<https://devfeed.tech/tags/apache.md>), [apache-zookeeper](<https://devfeed.tech/tags/apache-zookeeper.md>), [application](<https://devfeed.tech/tags/application.md>), [architecture](<https://devfeed.tech/tags/architecture.md>), [batch](<https://devfeed.tech/tags/batch.md>), [caching](<https://devfeed.tech/tags/caching.md>), [clickhouse](<https://devfeed.tech/tags/clickhouse.md>), [cluster](<https://devfeed.tech/tags/cluster.md>), [column](<https://devfeed.tech/tags/column.md>), [columnar](<https://devfeed.tech/tags/columnar.md>), [cta](<https://devfeed.tech/tags/cta.md>), [dashboards](<https://devfeed.tech/tags/dashboards.md>), [database-general](<https://devfeed.tech/tags/database-general.md>), [databases](<https://devfeed.tech/tags/databases.md>), [i-o](<https://devfeed.tech/tags/i-o.md>), [mysql](<https://devfeed.tech/tags/mysql.md>), [olap](<https://devfeed.tech/tags/olap.md>), [postgresql](<https://devfeed.tech/tags/postgresql.md>), [relational-databases](<https://devfeed.tech/tags/relational-databases.md>), [reports](<https://devfeed.tech/tags/reports.md>), [stack](<https://devfeed.tech/tags/stack.md>)

### AI overview

ClickHouse is presented as an open-source columnar database for analytics that can take large event scans off PostgreSQL or MySQL, which are described as better suited to transactional records and point lookups. It stores columns separately, allowing queries to read only the fields they need, and uses vectorized execution to process values in batches. It can scale through sharding and replication, with a distributed table engine routing queries across shards and ZooKeeper or ClickHouse Keeper coordinating replicas. The excerpt advises starting with a single node and adding shards when query latency or ingest volume calls for it. ClickHouse is also described as supporting high-rate ingestion with data queryable almost immediately; the provided text cuts off while introducing the MergeTree engine family.

### Source excerpt

Historically, relational databases did double duty. The same PostgreSQL / MySQL instance that handled your application's writes also answered your business questions. A well-indexed schema, a few GROUP BY reports, done. And that works, right up until it doesn't: the reports get slower, the dashboards start eating the same I/O budget as the application; or, [...] The post Building a Modern Analytics Stack Around ClickHouse appeared first on Severalnines.

## Managing ClickHouse Resources in Multi-Tenant Environments

DevFeed: [Managing ClickHouse Resources in Multi-Tenant Environments](<https://devfeed.tech/articles/managing-clickhouse-resources-in-multi-tenant-environments-19115.md>)

Original publisher: [Read original article](<https://severalnines.com/blog/managing-clickhouse-resources-in-multi-tenant-environments/>)

Author: Sucahyo Ardy Prasetiyo

Published: 2026-06-09T11:20:22Z

Content type: tutorial

Language: en

Sources: [SeveralNines](<https://devfeed.tech/sources/severalnines.md>)

Topics: [clickhouse](<https://devfeed.tech/topics/clickhouse.md>), [systems](<https://devfeed.tech/topics/systems.md>), [Database](<https://devfeed.tech/topics/database.md>)

Tags: [clickhouse](<https://devfeed.tech/tags/clickhouse.md>), [cta](<https://devfeed.tech/tags/cta.md>), [dashboards](<https://devfeed.tech/tags/dashboards.md>), [database-general](<https://devfeed.tech/tags/database-general.md>), [infrastructure](<https://devfeed.tech/tags/infrastructure.md>), [performance](<https://devfeed.tech/tags/performance.md>), [pipelines](<https://devfeed.tech/tags/pipelines.md>)

### AI overview

This tutorial explains how to manage ClickHouse resources in multi-tenant environments. It discusses contention caused by shared CPU, memory, and disk resources, and describes identifying contention, scheduling workloads, and validating cluster stability.

### Source excerpt

When people first deploy ClickHouse, their initial reaction is often surprise. Queries that used to take minutes now finish in seconds. Dashboards feel instant even when reading billions of rows. To see this in action, here is a simple aggregation query running against a 200 million row events table: ClickHouse delivers exceptional speed, scanning 200 [...] The post Managing ClickHouse Resources in Multi-Tenant Environments appeared first on Severalnines.

## Advanced Partitioning Strategies for PostgreSQL OLTP and Analytics Datasets at Scale

DevFeed: [Advanced Partitioning Strategies for PostgreSQL OLTP and Analytics Datasets at Scale](<https://devfeed.tech/articles/advanced-partitioning-strategies-for-postgresql-oltp-and-analytics-datasets-at-scale-19107.md>)

Original publisher: [Read original article](<https://severalnines.com/blog/advanced-partitioning-strategies-for-postgresql-oltp-and-analytics-datasets-at-scale/>)

Author: Sucahyo Ardy Prasetiyo

Published: 2026-06-04T09:15:00Z

Content type: article

Language: en

Sources: [SeveralNines](<https://devfeed.tech/sources/severalnines.md>)

Topics: [table-partitioning](<https://devfeed.tech/topics/table-partitioning.md>), [dataset](<https://devfeed.tech/topics/dataset.md>), [Insight for DBAs](<https://devfeed.tech/topics/insight-for-dbas.md>)

Tags: [analytics](<https://devfeed.tech/tags/analytics.md>), [analytics-workloads](<https://devfeed.tech/tags/analytics-workloads.md>), [data-retention](<https://devfeed.tech/tags/data-retention.md>), [datasets](<https://devfeed.tech/tags/datasets.md>), [declarative](<https://devfeed.tech/tags/declarative.md>), [delete](<https://devfeed.tech/tags/delete.md>), [deployment-scaling](<https://devfeed.tech/tags/deployment-scaling.md>), [indexes](<https://devfeed.tech/tags/indexes.md>), [large](<https://devfeed.tech/tags/large.md>), [large-datasets](<https://devfeed.tech/tags/large-datasets.md>), [maintenance](<https://devfeed.tech/tags/maintenance.md>), [operations](<https://devfeed.tech/tags/operations.md>), [partition](<https://devfeed.tech/tags/partition.md>), [partitioning](<https://devfeed.tech/tags/partitioning.md>), [partitions](<https://devfeed.tech/tags/partitions.md>), [performance](<https://devfeed.tech/tags/performance.md>), [postgresql](<https://devfeed.tech/tags/postgresql.md>), [retention](<https://devfeed.tech/tags/retention.md>), [scale](<https://devfeed.tech/tags/scale.md>), [strategies](<https://devfeed.tech/tags/strategies.md>), [vacuum](<https://devfeed.tech/tags/vacuum.md>)

### AI overview

At very large row counts, PostgreSQL partitioning can make data easier to operate by splitting a logical table into smaller physical segments using range, list, or hash strategies. Declarative partitioning routes rows to partitions and supports partition pruning, which can reduce scans; smaller segments can also ease vacuuming, retention, archival, and lifecycle management. It is not a standalone performance fix: poor query design or missing indexes remain problems. The excerpt introduces these benefits and cautions but does not provide the article's detailed strategy comparisons or operational lessons.

### Source excerpt

When PostgreSQL tables are still relatively small, most tasks seem straightforward. You can run queries without thinking too much about indexes, retention jobs are manageable, and even vacuum operations usually stay under control. But things change pretty quickly once tables start growing into hundreds of millions or billions of rows. At that scale, even simple [...] The post Advanced Partitioning Strategies for PostgreSQL OLTP and Analytics Datasets at Scale appeared first on Severalnines.

## How to Migrate from SQL Server to PostgreSQL HA for Dockerized Apps

DevFeed: [How to Migrate from SQL Server to PostgreSQL HA for Dockerized Apps](<https://devfeed.tech/articles/how-to-migrate-from-sql-server-to-postgresql-ha-for-dockerized-apps-19114.md>)

Original publisher: [Read original article](<https://severalnines.com/blog/how-to-migrate-from-sql-server-to-postgresql-ha-for-dockerized-apps/>)

Author: Jessie Baynas

Published: 2026-05-28T07:18:00Z

Content type: tutorial

Language: en

Sources: [SeveralNines](<https://devfeed.tech/sources/severalnines.md>)

Topics: [PostgreSQL](<https://devfeed.tech/topics/postgresql.md>), [sql-server](<https://devfeed.tech/topics/sql-server.md>), [software-architecture](<https://devfeed.tech/topics/software-architecture.md>), [SQL](<https://devfeed.tech/topics/sql.md>)

Tags: [cloud-native](<https://devfeed.tech/tags/cloud-native.md>), [clustercontrol](<https://devfeed.tech/tags/clustercontrol.md>), [compatibility](<https://devfeed.tech/tags/compatibility.md>), [containerized](<https://devfeed.tech/tags/containerized.md>), [control](<https://devfeed.tech/tags/control.md>), [costs](<https://devfeed.tech/tags/costs.md>), [data](<https://devfeed.tech/tags/data.md>), [database](<https://devfeed.tech/tags/database.md>), [database-general](<https://devfeed.tech/tags/database-general.md>), [efficiency](<https://devfeed.tech/tags/efficiency.md>), [flexibility](<https://devfeed.tech/tags/flexibility.md>), [ha](<https://devfeed.tech/tags/ha.md>), [microsoft](<https://devfeed.tech/tags/microsoft.md>), [microsoft-sql-server](<https://devfeed.tech/tags/microsoft-sql-server.md>), [migrate](<https://devfeed.tech/tags/migrate.md>), [modernization](<https://devfeed.tech/tags/modernization.md>), [open-source](<https://devfeed.tech/tags/open-source.md>), [operational-efficiency](<https://devfeed.tech/tags/operational-efficiency.md>), [postgresql](<https://devfeed.tech/tags/postgresql.md>), [scalability](<https://devfeed.tech/tags/scalability.md>), [sql-server](<https://devfeed.tech/tags/sql-server.md>)

### AI overview

The excerpt recommends separating schema conversion from bulk data movement when migrating SQL Server to PostgreSQL: use pgloader for schema conversion, BCP to export table data as CSV, and PostgreSQL COPY to import it. The article says this provides more control for troubleshooting and validation, particularly with large databases. The proposed environment uses Dockerized application services, PostgreSQL Streaming Replication, and ClusterControl for deployment, monitoring, and failover management. The excerpt does not provide the full migration procedure or discuss detailed limitations.

### Source excerpt

For many organizations, migrating from Microsoft SQL Server to PostgreSQL is no longer only about reducing licensing costs. The transition is often part of a broader modernization initiative focused on improving flexibility, scalability, and operational efficiency. PostgreSQL has evolved into one of the most mature open-source database platforms available today. It is widely adopted across [...] The post How to Migrate from SQL Server to PostgreSQL HA for Dockerized Apps appeared first on Severalnines.

## AI-Assisted Production Database Ops with ClusterControl MCP and CCX MCP

DevFeed: [AI-Assisted Production Database Ops with ClusterControl MCP and CCX MCP](<https://devfeed.tech/articles/ai-assisted-production-database-ops-with-clustercontrol-mcp-and-ccx-mcp-19108.md>)

Original publisher: [Read original article](<https://severalnines.com/blog/ai-assisted-production-database-ops-with-clustercontrol-mcp-and-ccx-mcp/>)

Author: Kyle Buzzell

Published: 2026-05-21T10:22:01Z

Content type: release

Language: en

Sources: [SeveralNines](<https://devfeed.tech/sources/severalnines.md>)

Topics: [Model Context Protocol](<https://devfeed.tech/topics/model-context-protocol.md>), [ClusterControl](<https://devfeed.tech/topics/clustercontrol.md>), [Production Engineering](<https://devfeed.tech/topics/production-engineering.md>), [Database](<https://devfeed.tech/topics/database.md>), [AI Chat](<https://devfeed.tech/topics/ai-chat.md>), [control-plane](<https://devfeed.tech/topics/control-plane.md>)

Tags: [ai](<https://devfeed.tech/tags/ai.md>), [ai-assistants](<https://devfeed.tech/tags/ai-assistants.md>), [ai-assisted](<https://devfeed.tech/tags/ai-assisted.md>), [ai-assisted-workflows](<https://devfeed.tech/tags/ai-assisted-workflows.md>), [backup](<https://devfeed.tech/tags/backup.md>), [ccx](<https://devfeed.tech/tags/ccx.md>), [claude](<https://devfeed.tech/tags/claude.md>), [claude-code](<https://devfeed.tech/tags/claude-code.md>), [cloud-database](<https://devfeed.tech/tags/cloud-database.md>), [cluster](<https://devfeed.tech/tags/cluster.md>), [clustercontrol](<https://devfeed.tech/tags/clustercontrol.md>), [clusters](<https://devfeed.tech/tags/clusters.md>), [codex](<https://devfeed.tech/tags/codex.md>), [database](<https://devfeed.tech/tags/database.md>), [mcp](<https://devfeed.tech/tags/mcp.md>), [model-context-protocol](<https://devfeed.tech/tags/model-context-protocol.md>), [operations](<https://devfeed.tech/tags/operations.md>), [ops](<https://devfeed.tech/tags/ops.md>), [platforms](<https://devfeed.tech/tags/platforms.md>), [production](<https://devfeed.tech/tags/production.md>), [sovereign-dbaas](<https://devfeed.tech/tags/sovereign-dbaas.md>)

### AI overview

ClusterControl MCP 1.0 provides 69 tools and 20 MCP resources/templates for production database operations in ClusterControl-managed environments; companion CCX MCP supports managed cloud database workflows. From MCP-compatible clients, users can inspect clusters, alarms, backups, queries, logs, and configuration, and prepare actions such as backups, maintenance windows, user creation, parameter changes, and restores. Write operations follow a dry-run-first model: the assistant explains the proposed action before execution, with extra warnings for high-risk operations. The excerpt illustrates drilling from cross-cluster alarms into a cluster's alarms and logs, but cuts off before completing its explanation of that workflow.

### Source excerpt

In December, we introduced how Model Context Protocol could make ClusterControl easier to work with from AI assistants. Since then, Severalnines has expanded that MCP direction across its database operations platforms with ClusterControl MCP and CCX MCP. The latest ClusterControl MCP is the major update, providing a more robust implementation with 69 tools and 20 [...] The post AI-Assisted Production Database Ops with ClusterControl MCP and CCX MCP appeared first on Severalnines.

## Building High Availability PostgreSQL Clusters with Patroni and Other Integrated Approaches

DevFeed: [Building High Availability PostgreSQL Clusters with Patroni and Other Integrated Approaches](<https://devfeed.tech/articles/building-high-availability-postgresql-clusters-with-patroni-and-other-integrated-approaches-19110.md>)

Original publisher: [Read original article](<https://severalnines.com/blog/building-high-availability-postgresql-clusters-with-patroni-and-other-integrated-approaches/>)

Author: Agus Syafaat

Published: 2026-05-21T07:20:00Z

Content type: article

Language: en

Sources: [SeveralNines](<https://devfeed.tech/sources/severalnines.md>)

Topics: [patroni](<https://devfeed.tech/topics/patroni.md>), [PostgreSQL](<https://devfeed.tech/topics/postgresql.md>), [Availability](<https://devfeed.tech/topics/availability.md>), [ClusterControl](<https://devfeed.tech/topics/clustercontrol.md>)

Tags: [architecture](<https://devfeed.tech/tags/architecture.md>), [automatic](<https://devfeed.tech/tags/automatic.md>), [automation](<https://devfeed.tech/tags/automation.md>), [availability](<https://devfeed.tech/tags/availability.md>), [challenges](<https://devfeed.tech/tags/challenges.md>), [clustercontrol](<https://devfeed.tech/tags/clustercontrol.md>), [clusters](<https://devfeed.tech/tags/clusters.md>), [consensus](<https://devfeed.tech/tags/consensus.md>), [consul](<https://devfeed.tech/tags/consul.md>), [database](<https://devfeed.tech/tags/database.md>), [dcs](<https://devfeed.tech/tags/dcs.md>), [distributed](<https://devfeed.tech/tags/distributed.md>), [distributed-consensus](<https://devfeed.tech/tags/distributed-consensus.md>), [election](<https://devfeed.tech/tags/election.md>), [failover](<https://devfeed.tech/tags/failover.md>), [ha](<https://devfeed.tech/tags/ha.md>), [high-availability](<https://devfeed.tech/tags/high-availability.md>), [patroni](<https://devfeed.tech/tags/patroni.md>), [postgresql](<https://devfeed.tech/tags/postgresql.md>), [postgresql-clusters](<https://devfeed.tech/tags/postgresql-clusters.md>), [recovery-repair](<https://devfeed.tech/tags/recovery-repair.md>)

### AI overview

The excerpt describes Patroni as an open-source PostgreSQL HA tool that coordinates replication and automatic failover through a distributed configuration store such as etcd, Consul, or ZooKeeper. The primary maintains a lease; standby nodes monitor it, and if the primary stops responding, a new leader is elected using criteria including replication lag and node health. YAML configuration defines Patroni's behavior. The article says it will examine Patroni's operational challenges and how ClusterControl might complement or replace it, but the excerpt provides no details on those approaches or comparisons with repmgr and PgAutoFailover.

### Source excerpt

In modern application stacks, downtime is a direct threat to business continuity, customer trust, and revenue. Regardless of whether it is an e-commerce platform, a fintech application, or a critical internal system, the expectation is 24/7 availability, underscoring the critical importance of High Availability (HA) and automated failover mechanisms within PostgreSQL clusters. HA ensures that [...] The post Building High Availability PostgreSQL Clusters with Patroni and Other Integrated Approaches appeared first on Severalnines.

## ClickHouse Monitoring and Observability Decision Points

DevFeed: [ClickHouse Monitoring and Observability Decision Points](<https://devfeed.tech/articles/clickhouse-monitoring-and-observability-decision-points-19111.md>)

Original publisher: [Read original article](<https://severalnines.com/blog/clickhouse-monitoring-and-observability-decision-points/>)

Author: Paul Namuag

Published: 2026-04-17T07:00:00Z

Content type: article

Language: en

Sources: [SeveralNines](<https://devfeed.tech/sources/severalnines.md>)

Topics: [observability](<https://devfeed.tech/topics/observability.md>), [clickhouse](<https://devfeed.tech/topics/clickhouse.md>), [database monitoring](<https://devfeed.tech/topics/database-monitoring.md>), [Monitoring](<https://devfeed.tech/topics/monitoring.md>), [infrastructure monitoring](<https://devfeed.tech/topics/infrastructure-monitoring.md>), [Monitoring & Alerting](<https://devfeed.tech/topics/monitoring-alerting.md>), [data observability](<https://devfeed.tech/topics/data-observability.md>), [consistency](<https://devfeed.tech/topics/consistency.md>)

Tags: [alerting](<https://devfeed.tech/tags/alerting.md>), [analytics](<https://devfeed.tech/tags/analytics.md>), [architecture](<https://devfeed.tech/tags/architecture.md>), [availability](<https://devfeed.tech/tags/availability.md>), [bottlenecks](<https://devfeed.tech/tags/bottlenecks.md>), [capacity-planning](<https://devfeed.tech/tags/capacity-planning.md>), [clickhouse](<https://devfeed.tech/tags/clickhouse.md>), [clusters](<https://devfeed.tech/tags/clusters.md>), [complexity](<https://devfeed.tech/tags/complexity.md>), [cpu](<https://devfeed.tech/tags/cpu.md>), [data-consistency](<https://devfeed.tech/tags/data-consistency.md>), [data-freshness](<https://devfeed.tech/tags/data-freshness.md>), [data-ingestion](<https://devfeed.tech/tags/data-ingestion.md>), [data-pipeline](<https://devfeed.tech/tags/data-pipeline.md>), [distributed](<https://devfeed.tech/tags/distributed.md>), [etl](<https://devfeed.tech/tags/etl.md>), [monitoring](<https://devfeed.tech/tags/monitoring.md>), [monitoring-alerting](<https://devfeed.tech/tags/monitoring-alerting.md>), [monitoring-and-observability](<https://devfeed.tech/tags/monitoring-and-observability.md>), [observability](<https://devfeed.tech/tags/observability.md>), [scalability](<https://devfeed.tech/tags/scalability.md>)

### AI overview

ClickHouse's distributed clusters and sub-second analytics expectations call for proactive observability, not metrics-only monitoring. The excerpt defines observability as combining metrics, logs, and traces with smart alerting to surface issues early. It lists practical areas to track: slow queries and resource contention; CPU, memory, disk, and network use; ingestion, ETL, replication lag, and merges; and multi-node query behavior, replica synchronization, and failover. Usage trends can also guide capacity planning and horizontal versus vertical scaling. The excerpt does not provide specific tools or cover the full strategies and techniques promised.

### Source excerpt

Given ClickHouse's ability to execute complex analytical queries across terabytes of data in a single operation, proper monitoring and observability is critical. Its distributed architecture and scalability add layers of complexity, as multi-node clusters require careful coordination monitoring across shards and replicas to ensure data consistency and availability. Adding to the operational pressure is users' [...] The post ClickHouse Monitoring and Observability Decision Points appeared first on Severalnines.

## PostgreSQL 18 Upgrades for AI-Era Workloads and Operations

DevFeed: [PostgreSQL 18 Upgrades for AI-Era Workloads and Operations](<https://devfeed.tech/articles/postgresql-18-upgrades-for-ai-era-workloads-and-operations-19117.md>)

Original publisher: [Read original article](<https://severalnines.com/blog/postgresql-18-upgrades-for-ai-era-workloads-and-operations/>)

Author: Sebastian Insausti

Published: 2026-03-20T08:00:00Z

Content type: article

Language: en

Sources: [SeveralNines](<https://devfeed.tech/sources/severalnines.md>)

Topics: [Insight for DBAs](<https://devfeed.tech/topics/insight-for-dbas.md>), [Production Engineering](<https://devfeed.tech/topics/production-engineering.md>), [aio](<https://devfeed.tech/topics/aio.md>), [Transactions](<https://devfeed.tech/topics/transactions.md>)

Tags: [ai](<https://devfeed.tech/tags/ai.md>), [aio](<https://devfeed.tech/tags/aio.md>), [analytics](<https://devfeed.tech/tags/analytics.md>), [async](<https://devfeed.tech/tags/async.md>), [asynchronous](<https://devfeed.tech/tags/asynchronous.md>), [b-tree](<https://devfeed.tech/tags/b-tree.md>), [clustercontrol](<https://devfeed.tech/tags/clustercontrol.md>), [i-o](<https://devfeed.tech/tags/i-o.md>), [operations](<https://devfeed.tech/tags/operations.md>), [postgresql](<https://devfeed.tech/tags/postgresql.md>), [postgresql-18](<https://devfeed.tech/tags/postgresql-18.md>), [saas](<https://devfeed.tech/tags/saas.md>), [transactions](<https://devfeed.tech/tags/transactions.md>), [upgrades](<https://devfeed.tech/tags/upgrades.md>), [upgrades-patches](<https://devfeed.tech/tags/upgrades-patches.md>), [vector](<https://devfeed.tech/tags/vector.md>), [vector-search](<https://devfeed.tech/tags/vector-search.md>)

### AI overview

PostgreSQL 18 targets operational pressure in mixed workloads with practical changes, including asynchronous I/O (AIO) and B-tree skip-scan. AIO can issue multiple storage requests without waiting for each one, potentially improving read-heavy scans and some maintenance operations when I/O is the bottleneck. The excerpt recommends evaluating it under realistic concurrent load, comparing P95/P99 latency with and without AIO, including while background VACUUM runs. For multi-column B-tree indexes, skip-scan addresses queries that filter without specifying the index's first column. The excerpt ends mid-explanation, so it provides no further detail on skip-scan behavior or results.

### Source excerpt

Today, we're asking PostgreSQL to do more and more, like handling both transactions and analytics, powering huge SaaS platforms, managing event data, and even dipping into AI-related tasks like vector search. This intense pressure highlights some pain points: slow, unpredictable reads, rigid indexing, complex setups, and risky major upgrades. PostgreSQL 18 directly addresses these real-world [...] The post PostgreSQL 18 Upgrades for AI-Era Workloads and Operations appeared first on Severalnines.

## Active-Active MySQL Group Replication Best Practices

DevFeed: [Active-Active MySQL Group Replication Best Practices](<https://devfeed.tech/articles/active-active-mysql-group-replication-best-practices-19106.md>)

Original publisher: [Read original article](<https://severalnines.com/blog/active-active-mysql-group-replication-best-practices/>)

Author: Paul Namuag

Published: 2026-03-11T12:54:52Z

Content type: article

Language: en

Sources: [SeveralNines](<https://devfeed.tech/sources/severalnines.md>)

Topics: [mysql group replication](<https://devfeed.tech/topics/mysql-group-replication.md>), [Transactions](<https://devfeed.tech/topics/transactions.md>), [consistency](<https://devfeed.tech/topics/consistency.md>)

Tags: [best-practices](<https://devfeed.tech/tags/best-practices.md>), [certification](<https://devfeed.tech/tags/certification.md>), [cluster](<https://devfeed.tech/tags/cluster.md>), [consensus](<https://devfeed.tech/tags/consensus.md>), [consistency](<https://devfeed.tech/tags/consistency.md>), [deployment-scaling](<https://devfeed.tech/tags/deployment-scaling.md>), [engine](<https://devfeed.tech/tags/engine.md>), [gcs](<https://devfeed.tech/tags/gcs.md>), [ha](<https://devfeed.tech/tags/ha.md>), [high-availability](<https://devfeed.tech/tags/high-availability.md>), [mgr](<https://devfeed.tech/tags/mgr.md>), [mysql](<https://devfeed.tech/tags/mysql.md>), [mysql-group-replication](<https://devfeed.tech/tags/mysql-group-replication.md>), [operational](<https://devfeed.tech/tags/operational.md>), [paxos](<https://devfeed.tech/tags/paxos.md>), [production](<https://devfeed.tech/tags/production.md>), [replication](<https://devfeed.tech/tags/replication.md>), [scalability](<https://devfeed.tech/tags/scalability.md>)

### AI overview

Active-active MySQL Group Replication lets every member in PRIMARY state accept reads and writes, with transactions replicated synchronously across the cluster. The Group Communication System manages membership and ordered delivery; its XCom engine uses Paxos-based consensus, while write-set certification detects conflicting transactions and resolves them automatically. This can support write scalability and high availability, but scalability depends partly on keeping write conflicts low: high contention can cause rollbacks or saturation and temporary unavailability. Active-active does not eliminate coordination overhead or internal single-writer behavior, and it does not provide unlimited or lock-free writes. The excerpt begins identifying critical applications with little tolerance for downtime as a use case, but ends before giving further detail or operational best practices.

### Source excerpt

In MySQL Group Replication (MGR) or Group Replication, an active-active configuration allows multiple group members to accept concurrent write transactions. These writes are coordinated through a consensus-based group communication system (GCS) and validated via write-set certification to preserve global transactional consistency as defined by the Group Replication protocol. active-active mode is designed for write scalability. [...] The post Active-Active MySQL Group Replication Best Practices appeared first on Severalnines.