What is Binary Logging and How to enable in MariaDB - MariaDB DBA / DEV Tutorial

Binary Log File:

The binary log file stored the data in binary fomrat. That makes it quicker for writting log information. The binary log file only capture Data Changing information, it is also used for replication.

How to Enable Binary Log : 

In case of Stand alone MariaDB, Make changes to /etc/my.cnf file

[mysqld]
log-bin=bin.log
log-bin-index=bin-log.index
max_binlog_size=100M
binlog_format=row

In case of Galera Cluster, make changes to /etc/my.cnf.d/server.cnf


How to read binary log files:

sudo mysqlbinlog binary-log-file-name


How to Enable Binary Log in MySQL or MairaDB