# cnpg for large-scale deployments

Published articles for cnpg for large-scale deployments.

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

## Optimizing Databases on Kubernetes Ep.2: Automating Database Maintenance with Kubernetes and CNPG

DevFeed: [Optimizing Databases on Kubernetes Ep.2: Automating Database Maintenance with Kubernetes and CNPG](<https://devfeed.tech/articles/optimizing-databases-on-kubernetes-ep-2-automating-database-maintenance-with-kubernetes-and-cnpg-22274.md>)

Original publisher: [Read original article](<https://www.ardanlabs.com/blog/2024/12/optimizing-databases-on-kubernetes-ep2-automating-database-maintenance-with-Kubernetes-and-cnpg.html>)

Published: 2024-12-12T00:00:00Z

Content type: tutorial

Language: en

Sources: [William Kennedy](<https://devfeed.tech/sources/william-kennedy.md>)

Topics: [Databases](<https://devfeed.tech/topics/databases.md>), [Kubernetes](<https://devfeed.tech/topics/kubernetes.md>), [PostgreSQL](<https://devfeed.tech/topics/postgresql.md>), [Automation](<https://devfeed.tech/topics/automation.md>)

Tags: [application-performance-during-failovers](<https://devfeed.tech/tags/application-performance-during-failovers.md>), [automated-failover-with-cnpg](<https://devfeed.tech/tags/automated-failover-with-cnpg.md>), [automation](<https://devfeed.tech/tags/automation.md>), [cloud-native-postgresql-automation](<https://devfeed.tech/tags/cloud-native-postgresql-automation.md>), [cnpg-for-large-scale-deployments](<https://devfeed.tech/tags/cnpg-for-large-scale-deployments.md>), [cnpg-node-maintenance](<https://devfeed.tech/tags/cnpg-node-maintenance.md>), [cnpg-secondary-promotion](<https://devfeed.tech/tags/cnpg-secondary-promotion.md>), [connection-pooling-for-failovers](<https://devfeed.tech/tags/connection-pooling-for-failovers.md>), [connection-resets-during-failover](<https://devfeed.tech/tags/connection-resets-during-failover.md>), [consistency](<https://devfeed.tech/tags/consistency.md>), [database](<https://devfeed.tech/tags/database.md>), [database-reliability-with-kubernetes](<https://devfeed.tech/tags/database-reliability-with-kubernetes.md>), [database-synchronization-kubernetes](<https://devfeed.tech/tags/database-synchronization-kubernetes.md>), [failover](<https://devfeed.tech/tags/failover.md>), [kubernetes](<https://devfeed.tech/tags/kubernetes.md>), [kubernetes-cordoning-and-pdb](<https://devfeed.tech/tags/kubernetes-cordoning-and-pdb.md>), [kubernetes-database-failover](<https://devfeed.tech/tags/kubernetes-database-failover.md>), [kubernetes-failover-strategies](<https://devfeed.tech/tags/kubernetes-failover-strategies.md>), [kubernetes-primary-database-failover](<https://devfeed.tech/tags/kubernetes-primary-database-failover.md>), [maintaining-data-consistency-k8s](<https://devfeed.tech/tags/maintaining-data-consistency-k8s.md>), [minimizing-downtime-kubernetes](<https://devfeed.tech/tags/minimizing-downtime-kubernetes.md>), [pdb-for-database-maintenance](<https://devfeed.tech/tags/pdb-for-database-maintenance.md>), [performance](<https://devfeed.tech/tags/performance.md>), [pod-disruption-budgets-kubernetes](<https://devfeed.tech/tags/pod-disruption-budgets-kubernetes.md>), [postgresql](<https://devfeed.tech/tags/postgresql.md>), [process](<https://devfeed.tech/tags/process.md>), [scalable-database-management-k8s](<https://devfeed.tech/tags/scalable-database-management-k8s.md>), [seamless-database-maintenance-kubernetes](<https://devfeed.tech/tags/seamless-database-maintenance-kubernetes.md>)

### AI overview

This video explains how Kubernetes and Cloud Native PostgreSQL (CNPG) automate database maintenance during node drains. It covers failover to a secondary node, pod disruption budgets, connection resets, connection pooling, and synchronization to preserve data consistency and limit application disruption.

### Source excerpt

Introduction: In this episode, Jérôme Petazzoni explores how Kubernetes and CNPG (Cloud Native PostgreSQL) work seamlessly to manage database operations during node maintenance. With real-world demonstrations, Jérôme highlights the power of Kubernetes' automation features, such as failover mechanisms and pod disruption budgets, ensuring minimal downtime and maximum reliability for database applications. Automated Failover with CNPG: How Kubernetes handles database switchover during node drains. Pod Disruption Budgets (PDBs): Ensuring critical pods remain unaffected during maintenance.