Join 1M+ other developers and:
- Get help and share knowledge in Q&A
- Subscribe to topics of interest
- Get courses & tools that help you grow as a developer or small business owner
When will the log position change in MySQL master and slave
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 ?
These answers are provided by our Community. If you find them useful, show some love by clicking the heart. If you run into issues leave a comment, or add your own answer to help others.×