|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/how-to-configure-a-high-availability-system-in-postgresql/
课程评论：没有评论
**课程名称：** PostgreSQL 高可用系统配置 **课程概述：** 数据库系统的可用性至关重要，尤其是在大型企业、紧急服务、银行等关键业务场景。为了实现接近 100% 的可用性，需要部署一个复制系统。该系统能够在主数据库服务器进行维护或扩展时，确保客户端能够连接到另一个服务器继续工作。此外，在发生非计划性服务中断时，客户端也能及时切换到备用服务器，以便问题得到解决。 本课程将一步步指导您安装、配置和监控一个复制系统，帮助您轻松实现 PostgreSQL 数据库的高可用性备份。您可以获得一个拥有全部数据的备用服务器（也称为 standby 或 slave），当主服务器崩溃时，它能够接管。更重要的是，您还可以利用备用服务器处理读取操作，例如报表、统计、模式分析等，从而减轻主服务器的负担，提升整个系统的性能。 本课程配置的复制系统将实现自动故障转移（failover）。这意味着，在数据库服务发生意外崩溃时，备用服务器将自动接管作为新的主服务器，无需 DBA 干预，无论何时何地，服务都能持续运行。 为了进一步增强客户端的可用性体验，我们将使用两个虚拟 IP 地址：一个用于连接主数据库，另一个用于连接备用数据库。这样，客户端无需了解复制系统的服务器数量、当前运行状态或各服务器的角色，即可无缝访问数据库。
A database system must be available when it is needed, and even more so in specific business cases such as large companies, emergency services, banks, etc.To guarantee an availability close to 100% it is necessary to implement a replica system that allows us to ensure that clients can work with another server when the main database server has to be disconnected to carry out maintenance tasks or expansion tasks. Anothre feature this replica system enables is that in the event of an uncontrolled drop in service, clients have another server to work with while the problem is resolved.The availability of 99.99% is possible and in this course I install, configure and monitor a replica system to teach you how to do it, step by step, so that you do not have any difficulties when backing up your PostgreSQL databases with this system..Not only will you have a secondary server (also called standby or slave) with which to work, with all the data, in the event of a main server crash, but also you will be able to use that secondary server for reading operations. In so doing, customers who access the system to perform reports, statistics, pattern analysis, etc., will be able to do it through the standby server, reducing the workload on the main server, for the benefit of the entire system.The replication system that we will configure in this course will have a failover system implemented. This means that, in the event of an unexpected crash of the database service, the standby server will become the new master without intervention from the DBA, automatically, whatever time it is, whatever day it is, and the service can continue without problems.Finally, and to further assure the clients of this availability, we will use two virtual IPs, one to connect to the main database, and another to connect to the replica, so that clients do not have the need to know how many servers form part of the replica system, if they are active or down, nor the role that each one of them has.
