PostgreSQL Replication, High Availability HA and Scalability

Partner: Udemy
Affiliate Name:
Area:
Description: 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.We have to ask the right questions to get the system requirements, and this why we dedicated an entire lecture, so that we examine what questions we have to put ourself, before starting the Scaling Journey.After this course, we should come out more prepared and understand how to scale reads.We have several options for replication, depending on wether we favor performance or flexibility.Replication can be used as a backup or a standby solution that would take over in case the main server crashes. Replication can also be used to improve the performance of a softwar
Category: Development > Database Design & Development > PostgreSQL
Partner ID:
Price: 59.99
Commission:
Source: Impact
Go to Course