Transcription of PostgreSQL Replication Solutions - Momjian
{{id}} {{{paragraph}}}
Example: air traffic controller
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 )11/18 SlonyAsynchronous Triggers add overhead tothe master Possible data loss onfail-over Replication possible evenover slow links Slave can executeread-only queries Table-level granularityallows complex datapartitioning configurations12/18 Slony InternalsSubscribersOther Slonik.
PostgreSQL Replication Solutions BRUCE MOMJIAN Replication is a complex feature. POSTGRESQL supports a variety of replication options. Creative Commons Attribution License http://momjian.us/presentations
Loading..
Tags:
Information
Domain:
Source:
Link to this page:
Please notify us if you found a problem with this document: