High Availability with Patroni and Etcd Quiz

Home › PostgreSQL DBA › High Availability with Patroni and Etcd

🛡️ Postgres Database Administration – High Availability with Patroni and Etcd

20 questions · 15 min timer · Explanations included · Free

What is the recommended method for ensuring data consistency during a failover in a Patroni cluster?

Relying on asynchronous replication for all replicas.

Disabling replication during failover events.

Using synchronous replication between the leader and at least one replica.

Manually copying data files from the leader to replicas.

None

Synchronous replication ensures that data is written to at least one replica before committing, maintaining consistency during failover.

What is the purpose of the 'standby_cluster' feature in Patroni?

To allow for read scaling by adding more replicas.

To improve write performance by distributing load.

To enable a secondary cluster for disaster recovery.

To facilitate automatic schema migrations.

None

The 'standby_cluster' feature in Patroni allows for the configuration of a secondary cluster, which can be used for disaster recovery purposes.

Loading questions...

Click Submit to see your final score!

Time's up

Scroll to Top