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.

  1. Fastest failover
  2. Multiple slaves are there.
  3. Make old master as read only it comes back.
  4. Im using ProxySQL on top it. Will it automatically detect the new master?
  5. GTID is enabled.
  • For "fastest", I think you will have to benchmark it in your environment. – Rick James Oct 30 '18 at 22:36

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.