Multiple databases???

[triexa]

I've looked at hosting plans.. and some offer 1 mysql database, others offer a few more.. and the rest unlimited...

Why do you need more than 1 mysql database though?

[thirdcherry]

Hi there,

Actually, I'm working on a client's site right now that we are discussing adding an additional database to.

We are adding a news section that will archive old headlines for product releases. This will enable us to update the new headlines easier, control the amount of new headlines we want to show in a given area, and have a manageable archive, that will not interfere the with the main product database, which we do not want to bog down added information.

By keeping them in separate databases, the site stays lean and more functional.

I'm sure there are many others out there doing even more complex things that would make sense to have more than one database.

Best Regards,
Michael Wisniach
3rd Cherry Designs

[triexa]

Hmm... okay, I guess it really seems to be made for the organizational purposes...

[thirdcherry]

In my case it is, but I'm sure there are others who are doing more with databases that can add to the list of reasons why one would need more than one database.

Best of luck in finding a good host, it can be tough!

Best Regards,
Michael Wisniach
3rd Cherry Designs

[platinum]

The main reason is backing up IMO - it's easy to just say, right, I want this database backed up... rather than sifting through 50 tables.

It's also just nice to seperate out bits and pieces, when someone finds the user/pass to your database, they can access everything, rather than just a single site feature.

I generally have one database for site functions, one for forums and one for any other major systems...

If one database gets corrupted, everything goes down