![]() The bandwidth required for this technique varies according to the transaction rate of the primary server. WAL files (16MB) can be shipped easily and cheaply over any distance, whether it be to an adjacent system, another system at the same site, or another system on the far side of the globe. PostgreSQL implements file-based log shipping by transferring WAL records one file (WAL segment) at a time. This configuration also has relatively low performance impact on the primary server.Äirectly moving WAL records from one database server to another is typically described as log shipping. No changes to the database tables are required to enable this capability, so it offers low administration overhead compared to some other replication solutions. The primary server operates in continuous archiving mode, while each standby server operates in continuous recovery mode, reading the WAL files from the primary. ![]() The primary and standby server work together to provide this capability, though the servers are only loosely coupled. This capability is widely referred to as warm standby or log shipping. Continuous Archiving in StandbyĬontinuous archiving can be used to create a high availability (HA) cluster configuration with one or more standby servers ready to take over operations if the primary server fails. Preparing the Primary for Standby Servers 27.2.4.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |