master-slave replication setup (1 master with 2 slaves. the slaves are hot standby in case the master fails).
- How can I do a backup under normal circumstances? Are all nodes are backed up individually and restored accordingly to their own backup files?
- If the Master fails and one of the slaves is appointed the new master, how do I reintroduce the master? Will this old master become a slave now?