The context information saved in the MySQL binary log

1. The reason for the context to be saved in the binary log

The binary log is to be replayed on the slave side, and the context information is recorded to ensure the consistency of the master bundle database. such as Rand a random number, the Lord returned can be 100, the return from the top may be 1000.

For the consistency of the data MySQL will have to save the value of the return, to the slave side of the direct use.

2. The context information to be saved in the binary log.

01, the current database.

02. The seed of the RAND function.

03, the current time.

04. The value inserted by the Auto_increment column

05, last_insert_id.

06. Thread ID

The context information saved in the MySQL binary log