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 )11/18SlonyAsynchronous 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/18Slony 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
Download PostgreSQL Replication Solutions - Momjian
Information
Domain:
Source:
Link to this page:
Please notify us if you found a problem with this document: