Need method to upgrade safely when using GTID
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
MySQL Server |
Unknown
|
Unknown
|
|||
Percona Server moved to https://jira.percona.com/projects/PS |
Won't Fix
|
Undecided
|
Unassigned |
Bug Description
There are neither instructions nor guidance provided how to upgrade from MySQL 5.6 to MySQL 5.7 when using GTID.
It is necessary to run mysql_upgrade as part of the upgrade to MySQL 5.7 from MySQL 5.6 but it is not possible to turn off GTID on MySQL 5.6 without shutting down the complete cluster and the documentation states that mysql_upgrade should not be used with GTID.
How to repeat:
The documentation states
https:/
Note
mysql_upgrade should not be used when the server is running with --gtid-mode=ON. See GTID mode and mysql_upgrade for more information.
and states
https:/
GTID mode and mysql_upgrade. It is possible but is not recommended to use mysql_upgrade on a MySQL Server running with --gtid-mode=ON, since mysql_upgrade can make changes to system tables that use the MyISAM storage engine, which is nontransactional.
tags: | added: upstream |
I created upstream https:/ /bugs.mysql. com/bug. php?id= 81206