When will the log position change in MySQL master and slave

March 11, 2018 607

MySQL CentOS

By:

domseah

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 ?

2 Answers

AshleyKennedy145 March 12, 2018

AshishSingh69 September 25, 2018

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

Have another answer? Share your knowledge.

Share