MySQL / MariaDB DBA

Replication

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.

This is 5 of 23 free samples for MySQL / MariaDB DBA.

More MySQL / MariaDB DBA topic samples