What are the differences between binlog and redo log in mysql

This article mainly explains "what is the difference between binlog and redo log in mysql". The content in the article is simple and clear, and it is easy to learn and understand. Please follow the editor's train of thought to study and learn "what is the difference between binlog and redo log in mysql".

1. Binlog is a logical log implemented in the MySQL Server layer, which can be used by all engines.

Redo log is a physical log unique to the InoDB engine.

2. Binlog is a logical log and redo log is a physical log.

Binlog records the raw logic of all DDL and DML statements.

Edo log records changes to a data page.

3. Binlog is unlimited, while redo log limits the size of space.

Binlog can add writes.

Redo log can only be replicated in a loop.

Example

Mysql > show variables like 'innodb%log%' +-- +-+ | Variable_name | Value | +-- +-+. | Innodb_log_file_size | 2147483648 | innodb_log_files_in_group | 2 | | innodb_log_group_home_dir |. / |. +-- +-+ 15 rows in set (0.00 sec) Thank you for your reading The above is the content of "what is the difference between binlog and redo log in mysql". After the study of this article, I believe you have a deeper understanding of the difference between binlog and redo log in mysql, and the specific use needs to be verified in practice. Here is, the editor will push for you more related knowledge points of the article, welcome to follow!