The difference between MySQL Binlog and redo log

Binlog and redo Log differences

1, the first 2 are recorded data changes, the difference is that Binlog is to record all the data change information, and InnoDB redo log only records all InnoDB table data changes.

2. Binlog is a DML and DDL SQL statement after the record has been committed, while InnoDB redo log is the DML in progress and the DDL statement

3, Binlog can be used as recovery data using redo log can be used as abnormal down or media failure after the data recovery use

4, in the DB file directory, also belong to the log file is not through.

This article is from the "Crazy_sir" blog, make sure to keep this source http://douya.blog.51cto.com/6173221/1651286

The difference between MySQL Binlog and redo log