Im going to setup an HA solution. Im planning to use Orchestrator. But seems MHA is also doing well.
If anyone already used/using any one these solutions, please suggest me to choose a right one with the following requirements.
- Fastest failover
- Multiple slaves are there.
- Make old master as read only it comes back.
- Im using ProxySQL on top it. Will it automatically detect the new master?
- GTID is enabled.