3 ms·
My assumption here is that the replication model described is one leader, multiple replicas - so all writes are applied to the leader and the followers are only
by simonw 4y ago
My assumption here is that the replication model described is one leader, multiple replicas - so all writes are applied to the leader and the followers are only used for reads.
This is a pattern commonly used with other databases such as PostgreSQL and MySQL which avoids a huge amount of complexity involved in multi-leader setups.
- hot_gril 4y agoThere's also the hot standby leader configuration that the higher Heroku Postgres tiers do. The standby leader receives writes asynchronously, so during failover you can actually suffer a little permanent data loss. Really should have a bigger warning label. I only ever do single leader, multi follower like you describe.