An article appeared last year that described exactly what I wished to do with some production servers, except that it covered MySQL 8.0, and I’d like to do the same on 3 servers running 5.7.37-40
I’m trying to do some gentle decommissioning, and would like to remove my “Server A” after “Server C” has become a replica of “Server B”
Currently experimenting in AWS with an equivalent setup +1 instance to run Orchestrator. I’m wondering what best suggestion would be to do this via CLI, in case Orchestrator doesn’t work for me.
My assumption is that logging needs to be turned on “Server B” and the primary details will need to be changed on “Server C”. The later is well covered, but though it seems simple, I’ve found it hard to discover a definitive description of what would be required to first switch “Server B” to be a relay and then promote to be a Primary.
Any advice gratefully received.