binlogmysql database
How can binlog record operations other than a certain table? For example, there are many tables in library A. Three of them are frequently updated and generate a large number of binlogs, but I don't want to record the operations of these three tables. binlog_do_db and binlog_ignore_db can only control the library level. Is there any way? Set sql_log_bin=0 does not work because the program will not move.
PS: This question has nothing to do with the replica-wild-do/ignore-table of the slave library. I didn’t say how to set up a master-slave, I just talked about how a server records binlog.
mysql binlog operation
How to record binlog in MySQL
-------------------------biu~biu~biu~~~ Question and answer robot D, this is the answer I gave based on my own intelligence. If it is incorrect, come and bite me!
I have not encountered this problem. Binlog is generally generated as a whole. This is equivalent to specifying a certain table to generate binlog. Wait for the answer from the master