Difference between revisions of "MariaDB binary log"

From wikieduonline
Jump to navigation Jump to search
 
(10 intermediate revisions by 2 users not shown)
Line 1: Line 1:
 
* https://mariadb.com/kb/en/activating-the-binary-log/
 
* https://mariadb.com/kb/en/activating-the-binary-log/
  
  --log-bin=your-log-binname
+
  --[[log-bin]]=your-log-binname
 +
--[[log-bin]]=mariadb-bin
 +
--[[log-bin]]=[[/your/path/]]mariadb-bin
 
  [[--log_bin_compress]]
 
  [[--log_bin_compress]]
 +
 +
== Steps ==
 +
* Define file name for your binary logs or full path including the name in <code>[[log_bin]]</code> option,[[/etc/mysql/mariadb.conf.d/50-server.cnf]]</code>
 +
 +
* Make sure path to your file is owned by <code>[[mysql.adm]]</code>: <code>[[chown]] [[mysql.adm]] [[/your/path/]]</code>
 +
 +
* Restart your db: <code>[[service mariadb restart]]</code>
 +
 +
* 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 ==
 
== 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
 
  cat [[/etc/mysql/mariadb.conf.d/50-server.cnf]] | grep binlog
 
  [[max_binlog_size]]  = 100M
 
  [[max_binlog_size]]  = 100M
Line 11: Line 28:
  
 
== Format ==
 
== Format ==
* <coe>[[SET GLOBAL]] binlog_format='ROW';</code>
+
* <code>[[SET GLOBAL]] binlog_format='ROW';</code>
  
 
== [[Slave]] ==
 
== [[Slave]] ==

Latest revision as of 15:28, 8 April 2023

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

Steps[edit]

  • 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[edit]

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[edit]

Slave[edit]

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

Related[edit]

Activities[edit]

See also[edit]

Advertising: