Details
-
Task
-
Status: Open (View Workflow)
-
Major
-
Resolution: Unresolved
-
None
-
None
Description
This task would be to re enabling dynamic global binlog setting in MariaDB ?
set global log_bin=OFF;
Variable 'log_bin' is a read only variable;
Most common scenario are
- production server that simply can't be restarted and need to become master
- Spider, Galera can control binlog to resync node (removing gcache)
- Dynamic auto configuration scripts
- Fail over scripts can promote a slave that as no binlog
SQL_LOG_BIN can be use for SESSIONS and LOG_BIN=0N for GLOBAL
We get the best of all world and no risk of confusion.
Other solution would be to introduce new GRANTS
GLOBAL BINARY LOG
Thanks