When compraing failover read replicas between Amazon Aurora and other options, it seems like the Amazon Aurora has only eventual consistency option [1], while other options have ability to create a standby replica that has synchronous replication with the master [2].
Is it true? Why isn’t Amazon Aurora doesn’t have an option for sync replication? In case my master DB fails I will loose some data with Amazon Aurora, while with other options, seems like all data will be preserved.