Comment 0 for bug 1357003

Revision history for this message
Morgan Tocker (morgo) wrote : Upstream SET GLOBAL sql_log_bin incompatible change

Per:
http://www.tocker.ca/2014/08/14/set-global-sql_log_bin-we-need-your-feedback.html

Upstream MySQL is proposing to change the following syntax to produce an error in current GA releases (5.5 and 5.6):

mysql> SET GLOBAL sql_log_bin = x;

The rationale for this is:

- The syntax will cause slaves to drift out of sync from masters.
- The syntax has no known "correct" use.
- The syntax is too close to SET sql_log_bin=x - which does have a correct use.
- Since this command is often run interactively, it is too easy to incorrectly type the incorrect command (and destroy data).
- Producing a warning instead of an error does not prevent accidental command typing.

Upstream has a MicroReleaseException agreement in place with Ubuntu, and is requesting feedback before proceeding with making the change.