Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Not a Bug
-
10.5.6
-
None
-
Centos 7
Description
Default configuration is set to run with binary logs as MIXED (which is pretty typical)
To perform gh-ost operations you must switch to ROW based, entering mysql cli and performing this change does not result in the binary logs being switched in that session (and I believe for existing connections).
As connections can be long lasting this results in the binary logging continuing as MIXED for the greater part of time - gh-ost ignores these binary logs resulting in definitive loss of data