In this article, we are going to learn about the concept of MySQL Binary Logs and their architecture. I am covering the following details in this article.

1. An overview of MySQL binary logs and their architecture
2. How to enable and disable binary logging
3. View and change the location of the binary logs

An overview of MySQL binary logs

The concept of MySQL binary logs and SQL Server transaction logs are the same. The binary logs contain information about the data changes that occurred on the MySQL instance. The binary logs contain all SQL statements, which update the data (INSERT, UPDATE DELETE) and the DDL statements (Create database object, drop database objects, truncate table) within the database. It contains the time taken to execute a statement that creates and updates the data. The SQL statement that is used to update the data are stored in the EVENT form. The EVENTs describe the global changes that occurred on the MySQL Server during any operations. It helps us to reproduce the change of the global state that had happened on the MySQL Server.

#mysql #mysql binary logs