Bug #100577 Manual is wrong when explaining about enabling GTID transactions online.
Submitted: 19 Aug 2020 13:41 Modified: 19 Aug 2020 13:47
Reporter: Eunbin Baek Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server: Documentation Severity:S3 (Non-critical)
Version:5.7 and 8.0 OS:Any
Assigned to: CPU Architecture:Any
Tags: enable gtid, wrong manual

[19 Aug 2020 13:41] Eunbin Baek
Description:
Hi, I found something wrong in this manual page. (https://dev.mysql.com/doc/refman/8.0/en/replication-mode-change-online-enable-gtids.html)

The fourth step of the steps to activate GTID on the page is described as follows.

On each server, execute:
  SET @@GLOBAL.GTID_MODE = ON_PERMISSIVE;
It does not matter which server executes this statement first.

It said there is no issue with which server to change first.
But according to the table for valid combinations of source and replica gtid_mode on the following manual page, https://dev.mysql.com/doc/refman/8.0/en/replication-mode-change-online-concepts.html, we must change the replica server first.
If the source server is changed to ON_PERMISSIVE first, it will not be compatible with the replica server.

How to repeat:
Don't need to repeat, just see the manual.

Suggested fix:
Please fix the manual If what I said is correct.