I'm a small business owner with around 10 employees spread across 4 different locations. We've mostly been working locally until now, but we're transitioning to a new ERP, and I thought it would be the ideal time to revamp our server infrastructure as well. My plan is to set up a dedicated server using a provider like OVH or Hetzner. The idea is to install Proxmox and create two Windows Server VMs: one for a centralized ERP database to replace our current separate databases, and the other for RDP clients to streamline employee access. I also want to set up Nextcloud on a third VM for file storage, aiming for direct RDP login on local PCs as they start up, so everyone works directly within the VM with ERP access. This way, I hope to reduce local PC failures and manage file storage more effectively. I'm a bit of a novice in this area, but we're planning to continue our current operations until I've sorted out a reliable new solution. I'm looking for feedback on this setup and any advice you might have!
4 Answers
If you're handling your local infrastructure successfully for years, you likely have some good instincts! However, running a server can be a different ballgame. Make sure you’re prepared for things like updates, backups, and maintenance. It may also be worth hiring an IT pro, especially for the initial setup to avoid any major slip-ups. Remember, if your server goes down, so does your business, at least until you get it back up!
It sounds like you have a good concept going on! Centralizing everything on a dedicated server is a smart move for multiple locations. Just keep in mind that RDP for all users means your RDP server becomes a single point of failure. If it goes down, all your stores could be impacted. It's crucial to separate the roles of your VMs—like having distinct ones for the database, ERP, and RDS. Also, plan for resilient backups and a way to handle internet outages since that could halt business operations. Sounds like you're on the right path, but just ensure you think through these risk factors!
Yeah, I totally get that. I'm actually thinking about setting up dual WAN routers at each store to have a backup internet connection. That should help with connectivity issues!
I think your plan is heading in the right direction! But I recommend considering a few things before diving in. It's great to centralize your database and file storage, but make sure you have a strategy for network security between your stores and the server. Secure tunnels are essential, especially since you're working across multiple locations. What are your thoughts on handling connectivity and security?
We were planning to set up WireGuard for secure connections, so I hope that helps with security concerns!
Your approach might indeed be a bit overengineered for your current needs. Have you thought about why not use a SaaS ERP solution instead? This could simplify things by reducing overhead and complexity. But if local options are limited, consolidating your resources as proposed can work—just focus on robust backups and failover planning
Unfortunately, we're in a niche market, and the SaaS options available here are really lacking.
I had considered this, but I feel competent enough to manage the infrastructure, even though I know it's a different challenge!