Difference between revisions of "MariaDB binary log"
Jump to navigation
Jump to search
(→Format) |
|||
| Line 6: | Line 6: | ||
== Format == | == Format == | ||
SET GLOBAL binlog_format='ROW'; | 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 == | == Related == | ||
Revision as of 12:45, 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
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:
