MySQL Bugs: #101519: Document about 'enforce_gtid

Bug #101519	Document about 'enforce_gtid_consistency' is inaccurate.
Submitted:	9 Nov 2020 7:28	Modified:	8 Apr 2021 14:42
Reporter:	Zhou Shu	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Server: Documentation	Severity:	S3 (Non-critical)
Version:	5.7, 8.0	OS:	Any
Assigned to:		CPU Architecture:	Any

Description:
The expression about the relationship between 'enforce_gtid_consistency' and 'gtid_mode' is inaccurate

How to repeat:
The system variable 'enforce_gtid_consistency' could be 'OFF', 'ON', and 'WARN'. If a user want to set 'gtid_mode=ON', the value of 'enforce_gtid_consistency' must be 'ON'. However, in description of 'gtid_mode'(https://dev.mysql.com/doc/refman/5.7/en/replication-options-gtids.html#sysvar_gtid_mode), it says that:

"MySQL 5.7.6 enables this variable to be set dynamically. You must have privileges sufficient to set global system variables. See Section 5.1.8.1, \“System Variable Privileges\”. enforce_gtid_consistency must be true before you can set gtid_mode=ON."

The "enforce_gtid_consistency must be true before you can set gtid_mode=ON" is not accurate, since there is also an alternative value 'WARN". So I recommend to adjust this expression to "enforce_gtid_consistency must be 'ON' before you can set gtid_mode=ON".

Hello Zhou Shu,

Thank you for the report and feedback.

regards,
Umesh

Posted by developer:
 
Thanks for spotting this! It must have been missed when WARN was added. I've updated to say that the variable must be set to ON.