Bug #79669 Provide configuration procedure for adjusting sys_config
Submitted: 16 Dec 2015 14:48
Reporter: Simon Mudd (OCA) Email Updates:
Status: Open Impact on me:
Category:MySQL Server: SYS Schema Severity:S4 (Feature request)
Version:5.6, 5.7 OS:Any
Assigned to: CPU Architecture:Any
Tags: sys, sys_config

[16 Dec 2015 14:48] Simon Mudd
sys 1.5 has a configuration table.

In a replicated environment you don't want to push down changes to this "it's supposed to be a local table" to any slaves under you. If you're a slave you don't want to generate any GTIDs (if GTID is enabled and that's the recommended default by Oracle).

So potentially changing any sys configuration setting means remembering to disable writes to the binlog and then changing the table, as otherwise I may "break stuff"

How to repeat:
see above.

Suggested fix:
A suggestion might simply be to have a stored procedure sys_config (which takes the configuration parameter and value and sets this for the user, adjusting sql_log_bin as needed.

Then all users can use this single procedure without having to think whether they need to do something special in their environment or not.