Description
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 the SQL standards. It also provides NoSQL capabilities and very rich data types and extensions. All this makes PostgreSQL a very attractive solution in software systems. In this course, we discussed the problem of creating scalable solutions based on PostgreSQL using the resources of multiple servers. There is a natural limitation to such systems – basically, there is always a trade-off between performance, reliability and stability. Improving one aspect is possible, but others will suffer. In this course, we will look at how to find the best match for our use cases so that we know which aspects need scaling, and avoid the common trade-offs of distributed systems. Scaling PostgreSQL is a journey. You should come away from this course more prepared to assess your scaling needs and understand how to scale reads and how to scale writes. Each of the solutions presented in this course will improve some aspect of the scalability topic, but each of them will add some complexity and perhaps some limitation or constraint.
What you will learn
- Assess your scaling needs
- How to scale reading 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 use multiple PostgreSQL instances in the cloud (Google Cloud)
- How to achieve high availability
- How to do automatic failover using pgpool II
- How to scale writes using partitioning and sharing
Who is this course for
- Software engineers interested in designing scalable and HA solutions on top of PostgreSQL
- database administrator
- Everyone is interested in building better PostgreSQL applications
Specificity of PostgreSQL replication, high availability HA and scalability
- Publisher: Udemy
- Teacher: Lucian Oprea
- language English
- Level: Intermediate
- No. of Courses: 80
- Duration: 3 hours 8 minutes
The content of PostgreSQL replication, high availability HA and scalability
Requirements
- You need access to a Windows/Mac/Linux PC with 10 GB of free disk space
- Basic familiarity with database objects such as tables and indexes is expected
- Some familiarity with Linux would be helpful
Pictures
Sample clip
installation Guide
Extract files and watch with your favorite player
Subtitles: English
Quality: 720p
Download links
Password File(s): free download software
file size
909MB