MySQL: Separate installations vs. one

by 2 replies
3
Hey Warriors,

I know just enough about MySQL to be dangerous.

Here's the deal:

I have several apps that I intend to install in subdirectories of one domain. For example:

mytools.com/projects
mytools.com/graphics
mytools.com/stats

Rather than create separate databases for each app, is it advisable to simply use one database with separate table prefixes for each app?

I think I've read about the pros and cons of each approach somewhere online - but can't find the info now that I need it.

Thanks!

- Darrel
#programming #installations #mysql #separate
  • It doesn't really matter, but I think it makes a lot more sense to keep more than one database if they're really different apps. This is just for convenience, I'm not aware of any performance differences one way or the other. If you're going to manage all the information from one place however, you better put it into one database.
  • All right. I guess I'll try separate databases. Thanks for the insights!

Next Topics on Trending Feed