Question
Binary-log positions versus GTIDs: how do failover coordinates differ?
Answer
Positions identify an event location in a particular binary log; GTIDs identify committed transactions across participating servers. Use positions for conventional replication; use GTIDs to simplify provisioning and failover transaction selection. Applies to MySQL and MariaDB.