Understood. Below are my further
DBaaS are way too expensive when compared to VMs of same configuration
Keeping DB outside the docker swarm will put additional ops effort and UI for maintenance, provisioning and analysing the logs
Changed the architecture a bit. Please share your thoughts
- One Primary VM for Docker Swarm Init and Portainer
docker swarm init --advertise-addr=X.X.X.X
-
Provision Regional VM and join the Swarm
-
Prepare regional Shared/Private MariaDB stacks from portainer and deploy - I have no idea on this on how to achieve. I think i have to play around with your below comment
- Create Worker Nodes for frappe apps stack placement, use node labels and placement constraints in stack.
- Prepare ERPNext stacks and connect to respective mariadb network.