Hope someone out there can help me. I’m in the middle of an upgrade to Percona 5.7 by using the replication method (see further background below if needed). Everything worked fine until I started replication and I got the following error:
Last_IO_Error: Fatal error: The slave I/O thread stops because a fatal error is encountered when it tries to get the value of SERVER_UUID variable from master.
The Master in question is a mysql Community 5.5.45 Server.
Does anyone know if what I am trying to do is impossible or whether there is something I can do to get this replicated?
Things I have checked already are checking the repl_user credentials by accessing mysql command line remotely from the slave to the master - that was ok.
And the iptables logs show that nothing is being blocked either way.
It is a big database and took over 12 hours to import so I hope I don’t have to do this again!
Any suggestions would be greatly appreciated.
The first replication migration I did was loosely based on this process: http://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/MySQL.Procedural.Importing.NonRDSRepl.html because I was moving to RDS.
That worked fine.
Later I upgraded a Percona 5.6 server to Percona 5.7 by using a modified version of this process, obviously to use mysql commands instead of RDS commands, but still essentially the same process: full sqldump, scp to new server, source the file to import it, replicate to bring back in sync then switch DNS to the new server.
Again, that went well.