MariaDB Binary Log Formats

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

• Mixed Logging: MIXED(default)
• Statement-Based Logging: STATEMENT (Default until MariaDB 10.2.3, 2016)
• Row-Based Logging: ROW SET GLOBAL binlog_format='ROW'; or binlog_format=ROW in config file

Configuration:

• /etc/mysql/mariadb.conf.d/50-server.cnf

Related

• MariaDB binary log
• binlog_format
• mysql -e "SHOW VARIABLES;" | grep binlog_format
• (Warning) Unsafe statement written to the binary log using statement format since BINLOG FORMAT = STATEMENT
• mariadb --version

See also

• 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/