I'm building an encyclopedia website. There are about 20 subjects that must be stored in the Database (media,library,article,translations,...) and we want to create 20 databases and allocate one DB for every subject. is it possible to do such thing? The main site has 3 sub domains and every sub domain covers specific rows of the subjects. for example the
library is a subject and
math.mainsite.com must have access only to the math type of the library subject.
the sub-domains must not have not any data, they all should get their data from the 20 above mentioned DBs, so every site must connect to 20 DB.
We selected this strategy because the subjects are subdomain as well, I mean
article.mainsite.com and ... are valid urls.