Introduction to Mysql Binlog logs

MySQL's replication capability is the basis for large-scale, high-performance applications. Share the read load. Horizontal expansion

is copied through the binary log and is asynchronous.

Only the modified events that were successfully executed are logged, and the errors and rollbacks are not recorded.

　　

Log path

View Logs

Row format, the way MySQL is officially recommended

Row format is not directly viewable, you need to add the-VV parameter

If you delete, update, the segment format only records the ID of the deleted record, but row format row also records information about the other fields of this piece of data.

Introduction to Mysql Binlog logs