MariaDB binary log

From wikieduonline
Revision as of 15:28, 8 April 2023 by Welcome (talk | contribs) (→‎Steps)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to navigation Jump to search
--log-bin=your-log-binname
--log-bin=mariadb-bin
--log-bin=/your/path/mariadb-bin
--log_bin_compress

Steps

  • 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

Format

Slave

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

Related

Activities

See also

Advertising: