Hi Team,
We have a parameter “–binlog-ignore-db” to disable logging for a particular database. Here, if the parameter is not existing in my.cnf file we have to add in the configuration file and restart mysql to have the changes affective. Below are the variables that are currently enabled as per the DB:
±----------------------------------------±------+
| Variable_name | Value |
±----------------------------------------±------+
| binlog_cache_size | 32768 |
| binlog_direct_non_transactional_updates | OFF |
| binlog_format | ROW |
| binlog_stmt_cache_size | 32768 |
±----------------------------------------±------+
Is there a way where I can add the parameter dynamically as we will not be able to restart the mysql instance as there are other DB’s running which cannot be down for a second. Please suggest…!
Best Regards,
Krishna