[UDM] PostgreSQL Replication, High Availability HA and Scalability Course (Jan 2025) + Resources

Construct a fault-tolerant PostgreSQL System
During the PostgreSQL Replication, High Availability HA and Scalability Course, you will have a practical experience on the configuration of a highly available PostgreSQL database system. You will find out how to set up streaming replication (synchronous and asynchronous, read-only operations through hot standby servers). What is more important is that you will learn to use an auto-failover through virtual IPs, enabling your applications to transfer to a backup server in case the first one fails. This arrangement confirms that it runs 24/7 without the intervention of a person.

Load Balancing and Scaling Load Balancing and scaling will help improve performance.
After having set up your replication setup, you will shift to techniques of performance tuning and large-scale application management. The PostgreSQL Replication, High Availability HA and Scalability Course discusses the critical applications such as PgBouncer, PgPool-II, and HAProxy, to provide connection pooling, smart query routing, and effective load balancing, respectively. When you spread read requests over a pool of replicas, your system will be more responsive and easier to scale as opposed to the derivative of primary-only and only a single replica mill.

Discover Advanced Replication Architectures
They do not train on the basics. You will delve into higher-level use cases such as cascading replication, logical replication to selectively synchronize a subset of data, processes of cloning, and managing standby servers. You will even know how to implement these ideas in a cloud setting with Google Cloud and HA proxy, so that you will be confident to develop distributed and scalable designs of PostgreSQL to deploy in a real application.

When it comes to Developers, DBAs, and System Engineers
The PostgreSQL Replication, High Availability HA and Scalability Course will suit somebody who has a fundamental knowledge of PostgreSQL and Linux, but he or she want to carry his or her knowledge a notch higher. The tutorials and demonstrative examples will be helpful even in case you are a database administrator, system engineer, or backend developer. And by the course conclusion, you will be capable of designing, deploying, and managing a powerful, high-availability PostgreSQL architecture established to survive failure and to scale as demanded.