First of all, Happy New Year to all.
I'm new to Rails, so please tolerate any misuse of terminology ...
I developed a simple Rails application supported by a MySQL database.
Now I would like to deploy this application to several independent user groups (i.e. this is a club application, and I would like to deploy it to several completely independent clubs).
I would like to use the same Rails application code as much as possible and just have a separate database instance for each club.
Since each instance will run on the same server (as long as loading on the server proves to be a problem), I assume that I can use a different port for each Rails server to manage users in the correct group?
I would read that there are test and production modes, is it possible to have several [additional] instances of production modes, for example. club1, club2, all use the same code with unique databases?
My questions are: how to maintain multiple individual database instances, and also what is the best way to direct them?
Any advice on how to do this is greatly appreciated.
ruby-on-rails
Snips
source share