DB mirroring cannot work due to the latency. This is cross site. sql edition is enterprise.
Asynchronous mirroring will work over any distance.
Your choices are limited by the technology available and the speed of light. You need to discuss with your management what Recovery Point Objective you want, and the Recovery Time Objective. This will help guide you to the appropriate technology. Unless and until you have your RPO and RTO defined you cannot rule out or rule in any given solution.
You need to let the business know that zero data loss is almost impossible to achieve, and getting from 5 seconds data loss to 0.5 seconds data loss could cost orders of magnitude more than getting from 5 minutes data loss to 5 seconds data loss.
Eventually you should get to a solution that your business can afford, both in implementation cost and business risk from data loss.
Original author: https://github.com/SQL-FineBuild/Common/wiki/ 1-click install and best practice configuration of SQL Server 2019, 2017 2016, 2014, 2012, 2008 R2, 2008 and 2005.
When I give food to the poor they call me a saint. When I ask why they are poor they call me a communist - Archbishop Hélder Câmara