MariaDB binary log

• https://mariadb.com/kb/en/activating-the-binary-log/

--log-bin=your-log-binname
--log-bin=mariadb-bin
--log-bin=/your/path/mariadb-bin
--log_bin_compress

Steps

• Define file name for your binary logs or full path including the name in log_bin option,/etc/mysql/mariadb.conf.d/50-server.cnf

• Make sure path to your file is owned by mysql.adm: chown mysql.adm /your/path/

• Restart your db: service mariadb restart

• Review files are created acording to your configuration:

-rw-rw---- 1 mysql mysql   330 Feb 19 14:03 mariadb-bin.000001
-rw-rw---- 1 mysql mysql    35 Feb 19 14:03 mariadb-bin.index

Config

cat /etc/mysql/mariadb.conf.d/50-server.cnf | grep log_bin
#log_bin                = /var/log/mysql/mysql-bin.log

cat /etc/mysql/mariadb.conf.d/50-server.cnf | grep binlog
max_binlog_size   = 100M
#binlog_do_db		= include_database_name
#binlog_ignore_db	= exclude_database_name

binlog_format=ROW

Format

• SET GLOBAL binlog_format='ROW';

Slave

STOP SLAVE;
SET GLOBAL slave_parallel_threads=0;
SET GLOBAL binlog_format='ROW';
SET GLOBAL slave_parallel_threads=4;
START SLAVE

Binary logs

file mariadb-bin.index
mariadb-bin.index: ASCII text

file mariadb-bin.000003
mariadb-bin.000003: MySQL replication log, server id 1 MySQL V5+, server version 10.4.21-MariaDB-1:10.4.21+maria~bionic-log

Related

• Point-in-time recovery (PITR)
• SET sql_log_bin = 0;
• mysqlbinlog
• mariabackup
• --delete-master-logs
• /etc/mysql/mariadb.conf.d/50-server.cnf
• MariaDB Binary Log Formats
• /var/log/mysql/error.log

Activities

• Read https://mariadb.com/kb/en/binary-log-formats/

See also

• MariaDB binary log, binlog format
• mariabackup, mariabackup --help, mysqlbinlog, MariaDB binary log, max_binlog_size, PITR
• MariaDB: mariadbcheck, mariabackup, mysqldump, MyRocks, show (MariaDB) MariaDB Changelog, 50-server.cnf, MariaDB engines, .ibd, .myd, .myi, /var/log/mysql/error.log, /var/log/mysql/mariadb-slow.log, MariaDB files: .frm, .ibd, /etc/mysql/mariadb.conf.d/50-server.cnf, replication, MariaDB slow queries, show databases;, Aria, MyISAM, MariaDB SkySQL, binary log, 3306, /etc/mysql/, --memlock, MariaDB ColumnStore