EDB Postgres Distributed (BDR): Multi-Master Replication Quiz

Home › PostgreSQL DBA › EDB Postgres Distributed (BDR): Multi-Master Replication

🌐 Postgres Database Administration – EDB Postgres Distributed (BDR): Multi-Master Replication

20 questions · 15 min timer · Explanations included · Free

What is a potential downside of using asynchronous replication in EDB Postgres Distributed (BDR)?

Reduced read performance due to delayed data propagation.

Higher resource consumption due to constant data synchronization.

Increased risk of data loss during a node failure.

Inability to scale the number of nodes beyond a certain limit.

None

Asynchronous replication can lead to data loss if a node fails before its changes are propagated to other nodes, as there is no guarantee of immediate consistency.

What is the recommended approach for monitoring the health of an EDB Postgres Distributed (BDR) cluster?

Implementing custom scripts to periodically check node status.

Relying solely on built-in PostgreSQL logs for monitoring.

Using a dedicated monitoring tool that supports distributed databases.

Monitoring only the primary node, as it reflects the overall cluster health.

None

Using a dedicated monitoring tool that supports distributed databases is recommended for effectively monitoring the health and performance of a BDR cluster.

Loading questions...

Click Submit to see your final score!

Start Quiz Next

Time's up

Scroll to Top