When will the log position change in MySQL master and slave

March 11, 2018 1.3k views
CentOS MySQL

At MySQL prompt > show master status;
It will show :
File : MySQL-bin.000001
Position : 107
BinlogDoDB : mydatabase

The question is what will cause the Position to change ?
Is it at every restart of the MySQL ?
Is it at every backup of the database ?

Thanks
Seah.dominic@gmail.com

2 Answers

The position will change every time an IUD operation is done on database.

Have another answer? Share your knowledge.

You can type !ref in this text area to quickly search our full set of tutorials, documentation & marketplace offerings and insert the link!