You can choose which databases should be written to the binary log by specifying the --binlog-do-db=db_name option in my.cnf. To specify multiple databases you must use multiple instances of this option. Because database names can contain commas, the list will be treated as the name of a single database if you supply a comma-separated list. You need to restart the MySQL server to effect changes.
Ignoring databases to write to a binary log
Get MySQL 8 Cookbook now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
