Bug #79517 if gtid-mode=on , set gtid-enforce-consistency=on by default if not specified
Submitted: 4 Dec 2015 7:07 Modified: 14 Dec 2015 12:31
Reporter: Shane Bester (Platinum Quality Contributor) Email Updates:
Status: Verified Impact on me:
None 
Category:MySQL Server: Options Severity:S4 (Feature request)
Version:8.0.0 OS:Any
Assigned to: CPU Architecture:Any

[4 Dec 2015 7:07] Shane Bester
Description:
I start my server with command line options:

--log-bin --server-id=1 --gtid-mode=on

it fails.

[ERROR] GTID_MODE = ON requires ENFORCE_GTID_CONSISTENCY = ON.
[ERROR] Aborting

How to repeat:
mysqld --log-bin --server-id=1 --gtid-mode=on

Suggested fix:
i cant remember all the options to type.  please just enable ENFORCE_GTID_CONSISTENCY by default if it wasn't specified and is required ;)
[14 Dec 2015 12:31] MySQL Verification Team
Hello Shane,

Thank you for the feature request!

Regards,
Umesh
[18 Jun 2016 21:35] Omer Barnir
Posted by developer:
 
Reported version value updated to reflect release name change from 5.8 to 8.0
[20 Jul 2018 11:25] Jean-François Gagné
This also affects 5.7.22.
Please consider also doing this in MySQL 5.7.
Thanks,
JFG
[20 Jul 2018 11:50] Jean-François Gagné
I got bitten by this today in 5.7.22.
Could you please consider implementing this for making MySQL more user-friendly ?
And maybe back-porting to 5.7...
Many thanks,

JFG