How does MySQL replication (binary log based) typically work, and what is a common consistency tradeoff with asynchronous replication?