Hello ERPNext/Frappe community,
I’m running ERPNext and N8N on a Hostinger VPS with Traefik as a reverse proxy (all containerized with Docker). I’m looking to improve the resilience of my setup to minimize potential downtime.
Current Infrastructure:
Hostinger VPS
ERPNext deployed via Docker containers
Traefik as reverse proxy
N8N workflow automation tool
I’ve researched several approaches to enhance uptime and would appreciate feedback or corrections:
- Database separation: Move the ERPNext database to a separate remote server
- Monitoring solution: Implement real-time monitoring with ERPNext-CrateDB + N8N for alerts
- Failover system: Set up DNS failover to route traffic to a backup ERPNext instance (sharing the same database)
I’ve also looked up the strategies for database scaling that would help with this but I’m just really not sure which is the best option:
This is from “Scaling ERPNext Whitepaper documentation: https://erpnext.com/files/Scaling%20ERPNext.pdf” :
Master - Replica: “Replication enables data from one MySQL server (the master) to
be replicated to one or more MySQL servers (the slaves)."MaxScale: “MariaDB MaxScale is a database proxy that extends the high
availability, scalability, and security of MariaDB Server while at the same time
simplifying application development by decoupling it from underlying database
infrastructure."Galera Cluster: “Galera Cluster for MySQL is a true Multi-Master Cluster based on
synchronous replication.”
What additional measures would you recommend for maximizing uptime in this setup?
Thank you in advance.