• Yes. Or you can set it so that whenever either A or B is the primary, the other one is read-only, so they can fail over quite happily with minimal intervention from you. You'll need to use a listener to route the connections to the right place.