We are opening a new store in the United Arab Emirates. What would be the optimal solution for us to locally run an ERPNext server on Windows? We plan to move or connect to the cloud after a term.
Production image (OVA)
Question 1: Does using the production image in VirtualBox risk our critical data from being corrupted if we accidentally lose electricity that abruptly shuts the instance down?
Question 2: Is using docker only meant for development purposes?
Question 3: Will WSL do fine to host an ERPNext server since it is new to Windows?
Note: The data is critical, we cannot afford to lose it.
Data is “critical “ forget Windows.
Using virtual machine is a plus, because you can make snapshots (clone) and immediately try out new Doctypes ect.
You can manage in virtual machine your backups + you can download/backup the entire system as an .ova file.
Hope this helps to decide.
Electric interruption can harvest your data + damage your computer.
Use UPS (uninterruptible power supply).
It is the only solution agains power loss, or rent a server in a server park, provider may taking care of the backups and to run the server, depending of the fee.
If you plan to use POS at the store here’s what you need to do
Install ERPNext on cloud server
Use Offline POS at the store on a laptop. It syncs every 3 minutes to server
Get UPS of about 7000kv. May run only for about 10 15 minutes which is good enough for UAE. Plus laptop has power battery.
Master Slave replication is worth consideration too
If you go the route of having a second server somewhere, you would neither need backups 4 times an hour nor risk losing even a few minutes of user work if you opted for
Master Slave replication.
Concerning brown outs.
Whenever there are network failures any updates on the master are not reflected to the slave. When connection resumes, the slave quickly catches up to the right position in the log file and everything is good again.
Play it safe and hassle free. Buy a cloud subscription from Frappe. You don’t have to rely on help from the forum as you get dedicated support from Frappe.
I run my small shop like this since 2011 and reading the many technical issues raised on this forum I am glad never attempted self implementation