I have 2 seperate MySQL 8 instances running on Ubuntu 20.04. One starts via systemd "normaly" and the other one I can invoke by using:
mysqld_safe --defaults-file=/home/username/mysqld_replica.cnf &
Now that everything is running I was investigating on how to start the second instance on boot. I discovered mysqld_mulit and wonder now if:
- What are the advantages of mysqld_multi over seperate config files?
- How I can start the second instance on boot if not using mysqld_multi