What is the difference between synchronous and asynchronous replication in postgresql

Опубликовано: 07 Июль 2020
на канале: mynotesoracledba
2,409
33

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


Смотрите видео What is the difference between synchronous and asynchronous replication in postgresql онлайн без регистрации, длительностью часов минут секунд в хорошем качестве. Это видео добавил пользователь mynotesoracledba 07 Июль 2020, не забудьте поделиться им ссылкой с друзьями и знакомыми, на нашем сайте его посмотрели 2,409 раз и оно понравилось 33 людям.