The binary log contains a record of all changes to the databases, both data and structure. It consists of a set of binary log files and an index.
It is necessary for replication, and can also be used to restore data after a backup.
| Title | Description |
|---|---|
| Overview of the Binary Log | The binary log contains a record of all changes to the databases |
| Activating the Binary Log | Activating the Binary Log. |
| Using and Maintaining the Binary Log | Using and maintaining the binary log. |
| Binary Log Formats | The three binary logging formats. |
| Binary Logging of Stored Routines | Stored routines require extra consideration when binary logging. |
| SHOW BINARY LOGS | SHOW BINARY LOGS lists all binary logs on the server. |
| PURGE BINARY LOGS | PURGE BINARY LOGS removes all binary logs from the server, prior to the provided date or log file. |
| SHOW BINLOG EVENTS | Show events in the binary log |
| SHOW MASTER STATUS | Status information about the binary log. |
| Binlog Event Checksums | Including a checksum in binlog events |
| Binlog Event Checksum Interoperability | Replicating between servers with differing binlog checksum availability |
| Group Commit for the Binary Log | Optimization when the server is run with innodb_flush_logs_at_trx_commit or sync_binlog. |
| mysqlbinlog | mysqlbinlog utility for processing binary log files |
| Transaction Coordinator Log | The transaction coordinator log (tc_log) is used to coordinate transactions... |
| Encrypting Binary Logs | Data-at-rest encryption for binary logs and relay logs. |
| Flashback | Rollback instances/databases/tables to an old snapshot |
| Relay Log | Event log created by the slave from the master binary log |
| Replication and Binary Log System Variables | Replication and binary log system variables. |
© 2019 MariaDB
Licensed under the Creative Commons Attribution 3.0 Unported License and the GNU Free Documentation License.
https://mariadb.com/kb/en/binary-log/