A quite lengthy post I posted once relating to HA:
as you will see it’s not so straightforward or simple, especially if you are thinking about achieving this with two servers. In particular to attempt what you want with just simple replication to allow connection to the nearest server from the location in question.