You could use #wireguard for sure.

As long as your main db is close to your node it should be fine. The replicas are mainly for backup.

For #lightning I just write to two different sqlite instances on two different SSDs, this backup method is supported by #CLN and is the easiest.