3 {{ upvoteCount | shortNum }}
3 {{ upvoteCount | shortNum }}

MySQL: Separate installations vs. one

by Darrel Hawes
2 replies
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
#installations #mysql #separate
  • Profile picture of the author wayfarer
    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.
    Signature
    I build web things, server things. I help build the startup Veenome. | Remote Programming Jobs
    {{ DiscussionBoard.errors[3483097].message }}
  • Profile picture of the author Darrel Hawes
    All right. I guess I'll try separate databases. Thanks for the insights!
    Signature
    Darrel Hawes - Blog
    {{ DiscussionBoard.errors[3483171].message }}

Trending Topics