It’s synchronous much of the time but can become asynchronous at any moment? I would still call that asynchronous. The availability story isn’t incredible eith

It’s synchronous much of the time but can become asynchronous at any moment? I would still call that asynchronous. The availability story isn’t incredible either. Once the secondary is behind an outage of the primary means the system is no longer operational until that primary can be restored. Three-way replication with raft and 2/3 or 3/5 acks is what modern distributed databases use. It’s for both availability and durability.