[MDEV-6555] sql_log_bin should be SESSION_ONLY Created: 2014-08-08  Updated: 2015-04-22  Resolved: 2014-12-19

Status: Closed
Project: MariaDB Server
Component/s: Replication
Affects Version/s: 5.5.39, 10.0.13
Fix Version/s: 5.5.41, 10.0.16

Type: Bug Priority: Major
Reporter: Nirbhay Choubey (Inactive) Assignee: Sergei Golubchik
Resolution: Fixed Votes: 0
Labels: upstream-fixed

Issue Links:
PartOf
is part of MDEV-7344 5.5.41 merge Closed

 Description   

Rationale explained in the blog:
http://blog.jcole.us/2014/08/08/stupid-and-dangerous-set-global-sql_log_bin/

 Comments   
Comment by Elena Stepanova [ 2014-11-16 ] 

5.5.41/5.6.22 version:
 
 
 
    The global scope for the sql_log_bin system variable has been
 
    deprecated, and this variable can now be set with session scope
 
    only. The statement SET GLOBAL SQL_LOG_BIN now produces an
 
    error. It remains possible to read the global value of
 
    sql_log_bin, but you should act now to remove any dependencies
 
    on reading this value from your applications, as the ability to
 
    do so will be removed in a future MySQL release.

Comment by Daniel Black [ 2015-04-22 ]

updated documentation. This should be done as part of the commit process.

Generated at Thu Feb 08 07:12:49 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.