Udemy – PostgreSQL Replication, High Availability HA and Scalability 2022-5

PostgreSQL Replication, High Availability HA and Scalability, PostgreSQL is one of the most powerful and easy-to-use database management systems. It has strong support from the community and is being actively developed with a new release every year. PostgreSQL supports the most advanced features included in SQL standards. It also provides NoSQL capabilities and very rich data types and extensions. All of this makes PostgreSQL a very attractive solution in software systems.  In this course, we discussed the problem of building scalable solutions based on PostgreSQL utilizing the resources of several servers. There is a natural limitation for such systems—basically, there is always a compromise between performance, reliability, and consistency. It’s possible to improve one aspect, but others will suffer. In this course, we’ll see how to find the best match for our use-cases so that we know eactly which aspects need scaling, and avoid the common trade-offs of distributed systems. Scaling PostgreSQL is a journey. You should come out of this course more prepared to assess your scaling needs and understand how to scale reads and how to scale writes. Each of this solution presented in this course will improve some aspect of the scalability topic, but each of them will add some complexity, and maybe some limitation or constraint.

What you’ll learn

• Assess your scaling needs
• How to scale reads using Replication and Load-Balancing
• Which is the best Replication solution for a certain use case
• How to manage database connections with PgBouncer connection pooler
• How to make use of multiple PostgreSQL instances in the cloud (Google Cloud)
• How to achieve High-Availability
• How to perform Automatic Failover using PgPool II
• How to scale writes using Partitioning and Sharding

Who this course is for

• Software Engineers interested in designing Scalable and HA solutions on top of PostgreSQL
• Database Administrators
• Everyone interested in building better PostgreSQL applications

Specificatoin of PostgreSQL Replication, High Availability HA and Scalability

• Publisher : Udemy
• Teacher : Lucian Oprea
• Language : English
• Level : Intermediate
• Number of Course : 80
• Duration : 3 hours and 8 minutes

Content of PostgreSQL Replication, High Availability HA and Scalability

Requirements

• You need access to a Windows/Mac/Linux PC with 10GB of free disk space
• Basic familiarity with database objects such as tables and indexes is expected
• Some familiarity with Linux will be helpful

Pictures

Sample Clip

Installation Guide

Extract the files and watch with your favorite player

Subtitle : English

Quality: 720p

Download Links

Download – 909 MB

File size

909 MB