Patroni for PostgreSQL (High Availability with automatic failover management)

Patroni for PostgreSQL (High Availability with automatic failover management) - Expert

Patroni for PostgreSQL ( HA with automatic failover management) Tentative release in Feb 2024

Buy $299.00 Free Preview

Course curriculum

1. What can you expect from this course?
  FREE PREVIEW
2. Who would benefit from attending a Patroni course ?
  FREE PREVIEW
3. Patroni course Overview
  FREE PREVIEW
4. 3 nodes streaming replication setup for Pg16 on Ubuntu22.04
5. Manually promote a standby to primary in 3 node streaming replication
6. Patroni vs 3 Node Streaming Replication
7. Use Case and Special Criteria for Using Patroni
8. When not to use Patroni?
9. Patroni vs repmgr
10. Patroni course content
1. Introduction of Patroni
1. Components of Patroni
1. Basics of Replication in PostgreSQL 16
2. What is streaming replication in PostgreSQL?
3. Replication Modes in Patroni
1. What is haproxy in context of patroni
2. How HAProxy is Used in Patroni and Its Benefits
3. What happens if haproxy is not deployed in a Patroni cluster for PostgreSQL?
4. How to Deploy and Configure HAProxy on Ubuntu 22.04
1. What is etcd ?
2. What Happens If etcd is not used in a Patroni Cluster for PostgreSQL ?
3. Alternatives of etcd in Patroni and Why They Are Used or Not Used ?
4. 3 node etcd cluster deployment on ubuntu 22.04
5. What Happens When One etcd Node Goes Down in a Three-Node etcd in a Patroni Cluster
6. Basic etcd commands
1. Setting up a Patroni cluster ( 5 Node : 3 Node Pg+Patroni+ 1Node etcd +1 Node haproxy)
1. What is Patroni config file and location details
2. Sample Patroni configuration file
3. Understanding Global/Universal Configuration Options in Patroni
4. Understanding Logging Configuration in Patroni
5. Understanding the Bootstrap Configuration in Patroni
6. Understanding the Parameters for Connecting to an etcd Cluster in Patroni
7. Configuration options for authentication, replication, rewind, callbacks, and other parameters
8. Patroni rest API
9. Significance of DCS in the context of Patroni
1. patronictl dsn command
2. patronictl edit-config command
3. patronictl version command
4. patronictl topology command
5. patronictl switchover command in patroni
6. patronictl show-config
7. patronictl list command
8. patronictl query command
9. patronictl history command
10. patronictl pause command
11. patronictl resume command
12. patronicl restart command
13. patronictl reload command
14. patronictl reinit command
15. patronictl flush command
16. patronictl remove command
17. Lecture- patronictl failover command
18. Demo- patronictl failover command
19. How to check Patroni logs
1. Setting up a HA with 3 node Pg-16(node1,node2,node3) +1 Node ectd (node4) + 1 Node haproxy(node5) on Patroni cluster
2. One of the standby goes down in patroni-Failure events
3. What happens when one of standby postgresql cluster is rebooted?
4. Standby database services are brought down due shutdown of patroni on one standby
5. Demo-Standby database services are brought down due to shutdown of patroni on one standby
6. Primary (PostgreSQL+Patroni) host failure scenarios- Terminating PostgreSQL primary cluster ?
7. Demo- Primary (PostgreSQL+Patroni) host failure scenarios- Terminating PostgreSQL primary cluster ?
8. Demo- Primary PostgreSQL+Patroni host failure scenarios-Stop the PostgreSQL &start immediately
9. Lecture -Reboot the Primary PostgreSQL cluster
10. Demo -Reboot the Primary PostgreSQL cluster
11. Lecture- Stop or Kill the Patroni on primary Postgresql Cluster
12. Demo- Stop or Kill the Patroni on primary PostgreSQL Cluster
13. Network Isolation Tests on Patroni cluster -The Network disconnect between master and rest of the standby servers
14. Network-isolation test of the standby server disconnetion from other servers in patroni cluster
1. How to connect to primary or stanby separately through haproxy
2. Demo- How to connect to primary or standby separately through haproxy
3. Demo- Haproxy behaviour in case of a failed primary/Leader postgresql cluster
4. Haproxy behaviour in case of a failed primary/Leader postgresql cluster
1. Replica Imaging and Bootstrap in Patroni
1. What is DCS Failsafe Mode
1. Q&A : Streaming replication
2. Q&A : Use Case and Special Criteria for Using Patroni
3. Q & A : Patroni vs. Repmgr
4. Q & A : When not to use Patroni for PostgreSQL
5. Q & A :Introduction to Patroni
6. Patroni's Components
7. Q & A :Patroni Replication Mode
8. Q & A : What is haproxy in context of patroni

About this course

$299.00
82 lessons
9.5 hours of video content

Learn before others grab this course !!!

Expert High Availability via Patroni on multinode postgreSQL cluster

00 Days
00 Hours
00 Minutes
00 Seconds

Patroni for PostgreSQL (High Availability with automatic failover management) - Expert

Course curriculum

Section-1 : What can you expect from this course ?

Section-2 Introduction of Patroni

Section-3: Components of Patroni

Section-4 : Fundamnetals of Replication in PostgreSQL 16

Section-5 :HaProxy

Section-6: What is etcd ?

Section-7: 5 Node Patroni : Setting up a Patroni cluster (3 Node Pg+Patroni+ 1Node etcd +1 Node haproxy)

Section-8:Configuration file in patroni

Section-9: patronictl commands

Section-10: Critical Events on cluster components and Patroni Counter Action

Section-11: How to connecting to primary and stanby separately through haproxy

Section-12: Replica Imaging and Bootstrap in Patroni

Section-13: What is DCS Failsafe Mode

Section-14: Q & A on Patroni

About this course

Learn before others grab this course !!!