What is the difference between synchronous and asynchronous replication in postgresql
In this session we are going to about key differences between synchronous and asynchronous replication in PostgreSQL.
i) The concept of replication is changed Happening in one database are replicated into other databases
ii) It can be made in two ways
1) synchronous replication
2) Asynchronous replication
Asynchronous replication:
- It’s a standard way To replicate data in PostgreSQL
- Advantages of this replication are low overhead, simplicity & robustness.
- As a result of async replication is the ideal solution of automatic failover
And enterprise-grade pregnancies
synchronous replication:
If you are not ready to take the risk of losing a cothe mmit sync replication is best solution
- It ensures the highest possible security of our transactions
subscribe to our channel:
-----------------------------------------
https://rebrand.ly/8z3l1y1
For doubts and queries kindly contact us on
-----------------------------------------------------------------------
[email protected]
Follow us:
www.facebook.com/MyNotesOracleDba
#synchronousvsasynchronousreplication
#syncvsasync #differencebetweensynchronousandasynchronousreplication
Watch video What is the difference between synchronous and asynchronous replication in postgresql online without registration, duration hours minute second in high quality. This video was added by user mynotesoracledba 07 July 2020, don't forget to share it with your friends and acquaintances, it has been viewed on our site 2,40 once and liked it 3 people.