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


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

No comments:

Post a Comment