PostgreSQL Replication Solutions - Momjian
PostgreSQLReplication SolutionsBRUCEMOMJIANReplication is a complex feature. PostgreSQL supports a varietyof Replication Commons Attribution updated: July, 20181/18Uses for Over 3/18Data Warehousing 4/18Load Balancing 5/18Remote Servers 6/18Mobile Servers 7/18Replication StorageNAS or SAN No overhead No data loss on fail-over Slave cannot executequeries9/18Storage MirroringDRBD No overhead on master Synchronous orasynchronous Possible data loss onfail-over when usingasynchronous Slave cannot executequeries10/18Streaming ReplicationWriteAheadLog(WAL) No overhead on master Slaves can execute queries Possible data loss onfail-over when usingasynchronous mode Synchronous optionavailable (Postgres )
Storage Mirroring DRBD Slave cannot execute No overhead on master Synchronous or asynchronous Possible data loss on fail-over when using asynchronous queries 10/18
Download PostgreSQL Replication Solutions - Momjian
Information
Domain:
Source:
Link to this page:
Please notify us if you found a problem with this document: