I am studying master-slave replication with MySQL and I may get it to work and likewise use the Percona backup software to revive a slave. I learnt from this challenge https://github.com/vbabak/docker-mysql-master-slave
Now I ponder if the master-slave replication should be two separate mysql cases of whether it is doable to configure master-slave replication between two databases solely as a substitute of needing two separate mysql cases. I feel it isn’t doable.
The rationale I wish to know is that I wish to automate failover and restore state of affairs and in my surroundings a brand new mysql occasion at all times runs on the default port due to infrastructure automation, and subsequently it isn’t doable in the present day to start out two mysql cases on the identical host machine server, subsequently it appears like I have to create two VMs with one grasp and one slave simply to carry out the check which is kind of overkill for a check state of affairs and can be gradual.