u/BugAdministrative357

I have a VM (for ease lets name it ALPHA) with multiple instance of MySQL. Each instance have their own user, my.cnf, datadir. I used systemd. Not docker due to the requirement being suitable. Less resource use and all instance uses the same version of mysql.

I have a question. How do i set a cluster with the ALHPA which holds all the instances to to be a primary node in the cluster and the secondary nodes (2 secondary nodes) will have the same instances and replicate all those instances. Its it even possible to do it natively?

Why i set it like this is because the requirement specifically asks for each system manage their own instance and have their own encryption and configuration.