In a scenario when hosting multiple sites, could someone comment on pros and
cons of having a single database vs. multiple databases.
This is way I see it:
If a fresh database is used for every new site, it's easier to recover if
anything goes wrong (ie. corruption of data). It's possible to backup every
database separately, and to recover it in the same manner.
The down side would be that the admin interface has to be copied to every
db. If any changes are made to the original admin interface it could be
quite a hassle to update it in all existing databases.
Further, could the number of persistent database connections be an issue?
If everything is done through the single database there are no problems with
updateing the admin interface, but it seems to me that big problems could
arrise if the data gets corrupted. It would be a problem to selectively
restore backed up data. Possibly, all sites in the database could be
affected, couldn't they?
Any thoughts?
Thanks,
Vanja Bertalan
--
This is The Midgard Project's mailing list. For more information,
please visit the project's web site at http://www.midgard-project.org
To unsubscribe the list, send an empty email message to address
[EMAIL PROTECTED]
