• This log is not transactional log as we know it on other databases
  • Contains info about all operations with impact on database content
  • is independent on engines, stores all operations modifying data, also for engines without transactions
  • is optional, must be turned on
  • Is the main tool for replication – is send to slaves to make the same changes as on master
  • You must have it for database recovery (and base backup also!)
  • is crash-safe – only completed operations are written
  • passwords are hidden so they cannot be seen as plain text in log
  • size is defined by setting “max_binlog_size“, default is 1GB
  • there are differences in format between versions of the database !