Description
PostgreSQL Replication, High Availability HA and Scalability, the training course on high availability and scalability in PostgreSQL has been published by Udemy Academy. PostgreSQL is one of the most powerful and easy to use database management systems. The program has strong community support and is actively developed with new releases every year. PostgreSQL supports the most advanced features available in SQL standards. It also provides NoSQL capabilities and very rich data types and extensions. All these things make PostgreSQL a very attractive solution in software systems. In this course, we discuss the issues of building 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 compatibility. One aspect can be improved but other aspects will suffer. In this lesson, we will see how to find the best match for our use cases to know exactly which aspects need to be scaled and avoid the common trade-offs of distributed systems.
Scaling PostgreSQL is a journey. You should come away from this course better prepared to assess your scaling needs and understand how to scale reads and how to scale writes. Each of these solutions presented in this course will improve aspects of the scalability issue, but each of them will bring some complexity and perhaps limitations. We need to ask the right questions to get the system requirements right, which is why we’ve devoted an entire lecture to exploring the questions we need to ask ourselves before we begin our scaling journey.
What you will learn
- Assess your scalability needs
- How to increase reading speed by using replication and normalization of load
- The best Replication solution for a specific use case
- How to manage database connections with the PgBuncer connection plugin
- How to use multiple instances of PostgreSQL in the cloud (Google Cloud).
- How to achieve high availability
- How to perform automatic delete operations using PgPool II
- How to grow writes using partitioning and sharding
Who is this course suitable for?
- Software engineers interested in designing scalable and HA solutions with PostgreSQL
Database administrators - All interested in building better PostgreSQL applications
PostgreSQL Replication, High Availability HA and Scalability course specifications
- Publisher: Udemy
- teacher : Lucian Oprea
- English language
- Education level: Intermediate
- Number of courses: 80
- Training duration: 3 hours and 8 minutes
Chapters of PostgreSQL Replication, High Availability HA and Scalability course
Course prerequisites
- 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 video
Installation guide
After Extract, view with your favorite Player.
English subtitle
Quality: 720p
download link
File(s) password: www.downloadly.ir
Size
909 MB
Be the first to comment