head.daveops.net

Snippets for yer computer needs

replication

Set the replica binlog coordinates

CHANGE MASTER TO
  MASTER_HOST='example.com',
  MASTER_LOG_FILE='mysqld-bin.123456',
  MASTER_LOG_POS=123456;

Check the binlog in a human readable way

mysqlbinlog

https://dev.mysql.com/doc/refman/5.6/en/replication-gtids-concepts.html