Difference between revisions of "MariaDB binary log"
Jump to navigation
Jump to search
(→Format) |
|||
| 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_compress]] | [[--log_bin_compress]] | ||
Revision as of 13:31, 19 February 2023
--log-bin=your-log-binname --log_bin_compress
Contents
Config
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;mysqlbinlogmariabackup--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, /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/
Advertising:
