For MySQL/PostgreSQL, either make sure DB layer replication is strong consistent, or try not to use it. Temporal depends on DB being strong consistent. The replication strategy you chose needs to be sync. Async DB replication will cause data loss and inconsistencies.
Temporal includes the multi-cluster replication feature because it cannot always rely on DB replication for some of the supported DBs (nature of DB, not Temporal).