I would like to have a MySQL separated on two servers with one being a master and the other a slave. Can juju detect if the master is down and promote the slave or would I have to do it manually?
OK after playing around with this a little more I realized that adding a MySQL unit is not the same as adding a MySQL slave. In the gui it shows multiple instances of MySQL not slaves with relationship with master.
What are these units that are being added? Backups or slaves? If they are slaves how can you tell which unit is the master? If the master reboots does one of the slaves become master?