...
👎 Setting separate ports and directories manually: https://dev.mysql.com/doc/refman/8.0/en/multiple-servers.html
Stopped working after the first time for me. Plus, this doesn’t really simulate how the MySQL servers would exist on 2 separate systems.
Second Reference: https://www.toptal.com/mysql/mysql-master-slave-replication-tutorial
❓ Docker
Wouldn’t immediately fix all of the issues with the method above; you still need to separate out the directories - https://stackoverflow.com/questions/46938303/docker-multiple-mysql-containers and https://stackoverflow.com/questions/49059109/docker-compose-run-two-instance-of-mysql
❓ DBDeployer - https://github.com/datacharmer/dbdeployer
❓ Cloud Computing (MS Azure) for Testing
Connecting MySQL Server with Python:
...