Transcription of PostgreSQL Replication Solutions - Momjian
{{id}} {{{paragraph}}}
Example: biology
PostgreSQL Replication Solutions - Momjian
PostgreSQLR eplication SolutionsBRUCEMOMJIANR eplication is a complex feature. PostgreSQL supports a varietyof Replication Commons Attribution updated: July, 20181/18 Uses for Over 3/18 Data Warehousing 4/18 Load Balancing 5/18 Remote Servers 6/18 Mobile Servers 7/18 Replication StorageNAS or SAN No overhead No data loss on fail-over Slave cannot executequeries9/18 Storage MirroringDRBD No overhead on master Synchronous orasynchronous Possible data loss onfail-over when usingasynchronous Slave cannot executequeries10/18 Streaming 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
Loading..
Tags:
Information
Domain:
Source:
Link to this page:
Please notify us if you found a problem with this document: