Comprehensive Guide to PostgreSQL v12 Database Replication : Walk-in a Beginner, Walk-Out an Expert
What you'll learn
- Replication & It’s Terminologies
- Log Based Shipping Standby
- Streaming Replication & Fail over
- Repmgr – Replication Manager
- Automatic Failover using Repmgr
- Node Rejoin
- Cascading Streaming Replication
- Logical Replication
- Cascading Logical Replication
- Tune PostgreSQL Server parameters
Requirements
- Basic Knowledge of Database Concepts
- PostgreSQL v12 Foundation
- Internet access is required to download PostgreSQL Server
- Working Knowledge on Windows and Linux
Description
PostgreSQL is an advanced, enterprise class open source Object-Relational Database Management System (ORDBMS). Its is a relational database that supports both SQL (relational) and JSON (non-relational) querying.
PostgreSQL possesses robust feature sets including Multi-Version Concurrency Control (MVCC), point in time recovery, granular access controls, tablespaces, asynchronous replication, nested transactions, online/hot backups, a refined query planner/optimizer, and write ahead logging. It supports international character sets, multi-byte character encodings, Unicode, and it is locale-aware for sorting, case-sensitivity, and formatting. PostgreSQL is highly scalable both in the quantity of data it can manage and in the number of concurrent users it can accommodate.
The course provides the learner with an extensive knowledge of PostgreSQL Database Administration with real time examples.
Topics covered are:
- Introduction to Replication & It's Terminalogies
- Master and Slave Configuration
- Warm & Hot Standby
- Types of Replication
- Modes of Replication
- Models of Replication
- Log Based Shipping Standby Initial Setup
- Log Based Shipping Standby on Windows and Linux
- Log Based Shipping Standby Failover
- Streaming Replication Setup
- Monitoring Streaming Replication
- Synchronous Streaming Replication
- Configure Physical Replication Slots
- Failover Streaming Replication
- Repmgr – Replication Manager
- Automatic Failover using Repmgr
- Node Rejoin of Failed Primary
- Add New Node and Standby Follow
- Switch Over From Primary to Standby
- Cascading Streaming Replication
- Witness Server
- Uninstall Replication Manager
- Logical Replication Setup
- Publication and Subscription
- Logical Replication Slots
- Add Table to Publication
- Refresh Subscription
- Cascading Logical Replication
- Uninstall Publication and Subscription.
- Tune PostgreSQL Server parameters
- Shared Buffers
- Work_Mem
- Maintenance_Work_Mem
- Database Administrators
- Developers
- Students
- Anyone who is curious about PostgreSQL