0

I have a application whose code is hosted on GitHub. This application is a school management system built using the Laravel Framework. I need advise on how I can implement it with the following architecture.

  1. Each school has its own database. (Multi-tenancy-multi-database)
  2. All schools share the same codebase
  3. Each school has it's own custom subdomain.

Currently I am using Heroku. What happens in Heroku is;

  1. I simply create an app,
  2. Update the ENV Variables (DB_Name)
  3. Get the DNS Nameserver address and create a CNAME record on CloudFlare to create the custom subdomain for the school.

I now have to replicate the same workflow in a different server provider (AWS or On-Premise Server)

If I was to choose AWS, how can I implement the above workflow? And I were to go for ON Premise how can I implement it?

I just need the advise around which tools to use, the rest I think I can figure out. I am still new in DevOps, my technical knowledge is still very foundational.

I would really appreciate a guide on how I can best go about it.

3
  • One database or one server per school? Either model is unusual outside of very high security systems, but it's useful if your code is buggy and can't be trusted to enforce security.
    – Tim
    Apr 21, 2023 at 20:15
  • One container per school.Data Isolation is a key requirment in this case
    – Ation
    Apr 25, 2023 at 15:51
  • Ah. You're basically just deploying many instances of your application. You would deploy it the same way as the existing host, the services just have different names. I would probably deploy the application in ECS using Fargate containers, database into RDS with many databases on one database server (though you can use one server per customer if you like), Route53 DNS. AWS is reliable, but can be expensive, particularly for bandwidth. You could consider AWS Lightsail VPS VMs, but then you have to use docker and manage everything yourself. Digital Ocean or similar would be cheaper.
    – Tim
    Apr 25, 2023 at 19:56

0

You must log in to answer this question.

Browse other questions tagged .