As we all know the erpnext is having HR Sales and many modules so if the company is having 500 users and only 100 are important and using several modules, those hundred users will use Cloud system.
But the rest users Who fall in Employee category and Only using HR module for their Leave application and Leave balance will be using local server, so if the data of the cloud server will replicate on local server (of those hundred users) then company don’t have to pay for the rest 400 hundred users and also they can maintain the redundancy.
Here I am talking about one way replication which is cloud to local.
I can pay for the installation of instances if it is required, but the question is still same, moving those 100 users on cloud will avoid the important users to Erpnext cloud services or amazon AWS will give those users almost no downtime, but you know you cannot commit 100% uptime with your local server, so if Erpnext will work as One way data sync to local server will help.
On the other side I think Erpnext cloud services selling will improve (this is my assumption), you can restrict this feature for erpnext cloud services only.
Even I am planning for the same like database replication, this can be easy because mysql is the backend of this system, and that database can be replicated, but will it replicate all the things? like settings and other stuff.
I will explore NAVICAT but have anyone tried this before ?
Just looking at prices, using the cloud for 100 users will cost $1500, and unlimited users costs $3000.
So, you’re looking at a difference of $1500/year. Now, it will cost you maybe $1000+ a year (admin, backups, maintenance, VM, testing, updates, security, etc) to host internally. So you will maybe save $500/year on this.