Difference between revisions of "MariaDB binary log"
Jump to navigation
Jump to search
(→Config) |
|||
| Line 5: | Line 5: | ||
== Config == | == Config == | ||
| − | 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 | ||
#binlog_do_db = include_database_name | #binlog_do_db = include_database_name | ||
Revision as of 13:13, 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:
