multiple databases

[webgod]

Question,

Most documentation doesn't give straight information on using mysql on a virtual server with multiple domains. Is is better to set up multiple databases per domain or would it be better to create one large database with tables per domain?

[Vinay]

it wouldnt make much of a difference...

as far as the server is concerned, a table is stored in a file, so, whether you have multiple databases or not, it wouldnt make much of a difference

[freakysid]

Not that I know much about this, but wouldn't their be a difference with security. If you don't want the different domains having access to other domains data then you would need to use different databases. You can then set up a different user account to the sql server for each domain and give them access only to their database.

[webgod]

I am also very new to this thing, however, can't you avoid the security issues by adding table access restrictions?