MySQL Forums
Forum List  »  Replication

programmatically ignore binlog databases
Posted by: Joaquin Jimenez
Date: February 22, 2016 05:27PM

Hi!

I have a database replication that consists of a slave and a master, both running on Ubuntu machines. The master have a number of memory databases that are exposed to a heavy traffic and I would like the master not to log this activity, basically because they are huge files and to protect the disk drive.
The problem is that the number of these memory databases is dynamic and some users can create new ones. The only way I know to ignore these databases is by editing binlog_ignore_db in my.cnf. Is there any way to programmatically configure which databases I want to ignore on the master side? Any command, variable...?

Thanks in advance.

Options: ReplyQuote


Subject
Views
Written By
Posted
programmatically ignore binlog databases
1584
February 22, 2016 05:27PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.