I’m wondering with High Availability, what happens if the connection between the Primary and the Secondary stops working?
I thought that both the primary and the secondary would stay available but the Secondary would begin lagging. Especially if we have Automatic Failover turned off.
Or would the Primary and/or the Secondary become unavailable?