Bug #79669 Provide configuration procedure for adjusting sys_config

• Submitted: 16 Dec 2015 14:48
• Reporter: Simon Mudd (OCA)
• Status: Open
• Category: MySQL Server: SYS Schema
• Severity: S4 (Feature request)
• Version: 5.6, 5.7
• OS: Any
• CPU Architecture: Any
• Tags: sys, sys_config

[16 Dec 2015 14:48] Simon Mudd

Description:
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.