What is Binary Logging and How to enable in MariaDB – MariaDB Admin / Dev Tutorial



What is Binary Logging and How to enable in MariaDB – MariaDB Admin / Dev Tutorial

What is Binary Logging and How to enable in MariaDB - MariaDB Admin / 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

Check out below link to follow step by step tutorial for MariaDB for beginner to Advance
http://www.techbrothersit.com/2018/06/mariadb-admin-dev-tutorial.html

This video can be used by people who want to get training as
MySQL Developer Tutorial
MySQL DBA Tutorial
MariaDB Tutorial / MariaDB Training free
MariaDB DBA Training step by step
Real time MySQL / MariaDB training

Comments are closed.