2👍
✅
No, it will not. Automatic failover is hard to get right. The reason being that it’s difficult to detect failures reliably. In case you’ve sorted it out (and your slave gets automatically promoted to master) you could change the ip-address of the old slave to the one of the failed master.
Source:stackexchange.com