Difference between revisions of "MariaDB binary log"
Jump to navigation
Jump to search
| Line 17: | Line 17: | ||
* <code>[[mariabackup]]</code> | * <code>[[mariabackup]]</code> | ||
* <code>[[--delete-master-logs]]</code> | * <code>[[--delete-master-logs]]</code> | ||
| + | * <code>[[/etc/mysql/mariadb.conf.d/50-server.cnf]]</code> | ||
== Activities == | == Activities == | ||
Revision as of 13:11, 19 February 2023
--log-bin=your-log-binname --log_bin_compress
Contents
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:
