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

PostgreSQL is one of the most popular databases in the world, supporting the most advanced features of SQL and also some Nosql capabilities. It is a great solution for any software system; PostgreSQL Replication, High Availability HA and Scalability Course is designed to teach you how to create scalable solutions based on PostgreSQL.

You will learn to choose the best match for your use cases, providing scalability, reliability, and consistency. We will discuss replication, balancing performance and flexibility, utilising replication as a backup or to improve performance, and the conditions under which we allow multiple computers to access the same data.

You will create a mechanism for distributing requests, utilise a connection pooler, and make your traffic growth predictable. In the other sections, we will also discuss partitioning and sharding to scale writers. And finally, you will learn about the multi-master solution concept, a new and promising concept in the field. This course is ideal for database administrators and engineers seeking to learn how to design scalable solutions.