Skip to main content

MariaDB

Install

https://computingforgeeks.com/how-to-install-mariadb-on-centos-rhel-7/

Binlog

https://smarttechways.com/2021/05/27/enable-disable-the-binary-log-in-mysql/

Check bin log is enabled (ON) or disabled (OFF)

mysql> show variables like 'log_bin';

Show the list of binary file created.

mysql> SHOW BINARY LOGS;

Enable the Binary Log in MySQL

--For enable, edit the my.ini file and enter following parameter
log-bin="RAC1-bin"

Disable the Binary log in MySQL

-- For disable the binary log, Edit the my.ini file
#log-bin="RAC1-bin"  --Comment the log-bin parameter
skip-log-bin   -- enter this in my.ini file and save and restart the mysql