Home  >  Article  >  Database  >  How can mysql's binlog record operations other than a certain table?

How can mysql's binlog record operations other than a certain table?

WBOY
WBOYOriginal
2016-07-06 13:28:331913browse

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.

Reply content:

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

Statement:
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn