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.