Running PostgreSQL in Kubernetes with CloudNativePG
Jonathan, Danish
In this hands-on, 3-hour workshop, participants will learn how to deploy and manage PostgreSQL in Kubernetes using CloudNativePG (CNPG), the open source operator in the CNCF sandbox. The workshop will walk through the main features to manage a PostgreSQL cluster, from deploying the first CNPG cluster to managing configuration, databases, and roles in a declarative way, to enabling continuous backups for recovery from a disaster.
Attendees will manage the PostgreSQL cluster by applying the changes from the YAML manifest definition, demonstrating the declarative nature of the Operator. We will cover basic DBA managements, from DB initialization, to declarative SQL execution and DB import from other PG source, to reading the aggregated logs for investigation. Moreover we will show the benefits of using the CNPG operator for taking and restoring backups, and for its self-healing capabilities in case of incidents. This session is ideal for DevOps engineers, DBAs, and developers looking to operationalize PostgreSQL in Kubernetes.
Following the instructions from the CNPG Playground project, anyone will create Kubernetes clusters on their own laptop using “kind”.
While the kind clusters will be created on each laptop, we will introduce the CNPG operator and basic concepts. We will walk the attendees to understand a bit of the Kubernetes world and the problems we are trying to solve with this PostgreSQL operator.
The course will cover the following points:
- Introduction to CloudNativePG (CNPG)
- Installation of the kubectl plugin for CNPG
- First deployment of a CNPG cluster
- PostgreSQL configuration, databases, and roles management
- Initial custom SQL execution
- Database import
- Setup and execution of the first backup
- Incident simulation (failover showcase)
- Log reading
- Upgrade of the Operator and the PostgreSQL version (minor, and major)
- Restore from a backup.
To speed up the process, we will provide a link to download all the commands to actually follow the workshop in real time, without wasting precious minutes writing them or looking for typos in case of issues.