Binlog formats
Statement: replay SQL. Row: replay row changes. Mixed: pick per statement. Row is default modern.
Advertisement
Semi-sync
Master waits for at least one replica ack. Bounds data loss on failover. Standard for production.
Advertisement
GTID
Global Transaction ID. Unique per transaction. Enables automatic failover: replica knows exactly what's applied.