Need Advice: Redundancy with VM Ware + connecting remote office

KurskKnyaz

Senior member
Dec 1, 2003
880
1
81
We have a company with 20 workstations in NY and 6 in a remote location in Europe. The server in NY is the domain controller, NVR for the security cameras, file server and stores profiles and user data for our roaming profiles. Currently the office in Europe is connected to our router through a VPN tunnel which results in a lot of latency when opening excel files from the server. Both offices work in excel files but we plan to put everything in an SQL database in the future
We are planning to do a major upgrade by the end of the year and I would like some advice on what the best way to do this is.
I plan on building a server in NY running VM Ware ESXi which will host separate VMs as follows:

Domain Controller/LDAP (Windows Server 2019 – should these be separate?)
File Server (Windows Server 2019)
NVR (Windows 10)
UPS Shipping Database server (Windows 10)
Punch clock software (Windows 10)
User Profiles (Windows Server 2019)
SQL Database (Windows Server 2019)
NetWrix Auditor 9.5 (Windows Server 2016)
Acronis Backup for VM Ware

I need to accomplish 2 two goals:
1. Reduce the latency for the office in Europe
2. Have redundancy for the server in NY so that the office can work in the event of a hardware failure and also work in the event that someone breaks into the office and steals the server.

For the first goal, I was considering on building a server for the office in Europe and having it synchronize the data with our server in NY. Right now we are only using Excel but we will have a database in the future. This seems like the optimal solution because the office in Europe will be able to work if the internet goes down. Should their server goes down they will connect to the NY server with higher latency. What is the best way to do this?

Another option I was considering was to host VM workstations and have the office in Europe remote desktop into them. The disadvantage of this is that if either the NY office or Europe office internet goes down the office in Europe won’t be able to work.

A third option that I was considering was to host everything in the Amazon AWS cloud, but that is something we would have to pay for monthly. Is there a point to this given that we can just run our own servers for a one time flat fee? Is it recommended to have the Domain Controller in the cloud? If our internet goes down the entire office won’t be able to work.

For the second goal, I was considering on running a separate server with VM Ware ESXi at a remote location and having it set up in a way that if the server in NY fails the offices in NY and Europe will connect to the Remote server instantly with no down time and then resort back to the server in the NY office once it is back up and running. What is the best way to accomplish this? Is there a point of having the backup server in the cloud on Amazon AWS as opposed to having it on a remote locations like the boss’s house?

If I was to have such a setup would there be any point in running RAID 1? Also, he have many solid state drives available, is there any advantage of making every VM its own drive? Or should we just get 1 big drive and have VM Ware allocate the space between VMs? How much RAM would you recommend for the NY Server and is a powerful CPU necessary?
 

mxnerd

Diamond Member
Jul 6, 2007
6,799
1,103
126
Another domain controller in Europe and configure Windows DFS probably is all you need for Excel files replication if you already have VPN setup.

https://www.youtube.com/watch?v=nJiw-Ee5akk

Then either NY or Europe domain controller / server goes down, both offices can still login and access files.
 
Last edited: