MariaDB binary log
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
- 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
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
Related
- Point-in-time recovery (PITR)
SET sql_log_bin = 0;
mysqlbinlog
mariabackup
--delete-master-logs
/etc/mysql/mariadb.conf.d/50-server.cnf
Activities
See also
mariabackup, mariabackup --help, mysqlbinlog
, MariaDB binary log,max_binlog_size
, PITR- Database backups:
mariabackup, mysqldump
,mongodump
,mariabackup, pg_dump
- MariaDB:
mariadbcheck
,mariabackup
,mysqldump
, MyRocks,show (MariaDB)
MariaDB Changelog,50-server.cnf
, MariaDB engines, .ibd, .myd, .myi,/var/log/mysql/error.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/
Advertising: