programmatically ignore binlog databases
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.
Subject
Views
Written By
Posted
programmatically ignore binlog databases
1583
February 22, 2016 05:27PM
768
February 23, 2016 11:22PM
705
February 24, 2016 03:20AM
723
February 26, 2016 09:07PM
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.