Actually on 3 hosts, but only the primary is at the edge, one other is a hot-standby at another geographic location and the third is for incremental backup purposes via ZFS. The database sync connection are tunneled via Wireguard. Failover to the hot-standby is done via DNS (ClouDNS). Also I run the setup in a Linux Container (LXC). Deployment is done via SCP and Tar. :-D This setup is very reliable to me and at the other hand cheap!