Why would you need multiple MySQL?

bloggerbee · #1 (**permalink**) 02-03-09, 09:13

I see some hosting packages offer unlimited databases or a large number of them, at least. Why would someone need multiple databases within the same website?

carl owen · #2 (**permalink**) 02-03-09, 18:20

It is not necessary to have multiple MySQL databases for one website. It basically depends on the requirements of the customer. If someone needs multiple MySQL for same website, he can have them. It is also good to have multiple MySQL databases for the security as if one of the databases gets affected the other databases will not get affected and as a result the whole website will not get affected.

php_rules · #3 (**permalink**) 02-04-09, 06:31

You dont really need multiple databases, unless you have massive databases that is. Normal use wouldn't really cause much of a hit on a database, but if you have a ten gig database that is getting hammered all the time you might want to separate it into ten 1 gig databases and query then all at the same time - it would take much less time to return a result.

BodShane · #4 (**permalink**) 02-04-09, 14:23

Absolutely Correct. ;)

Joseph · #5 (**permalink**) 02-04-09, 18:40

PHP rules has answered your question. It is not really important to have multiple databases if your database is not that large. If you have a larger database then you can have multiple databases as it has more benefits.

Lazlo90 · #6 (**permalink**) 02-06-09, 23:06

I'd say for security reasons, as someone else stated. That's the main reason why I use multiple databases, and as a tip, you should use a different password for your other databases just in case.

BodShane · #7 (**permalink**) 02-07-09, 09:54

Password that has a mixture of Upercase and Lowercase alphabets with numbers. ;)

php_rules · #8 (**permalink**) 02-07-09, 11:51

Dont forget about spaces =) most of my sensitive passwords are more like 'pass phrases' or 'pass stories' instead of using '14xDTbg67' which no one is going to remember but something like 'this is the red site that I like posting on' is going to be hard to brute force and easy to remember!!

centelo · #9 (**permalink**) 02-09-09, 13:23

I think more host's will worry about a client demanding to have multiple (different) IP's than just more DB's. I have seen some scammer folk get busted for things like this.

BodShane · #10 (**permalink**) 02-10-09, 17:08

Indeed. Allocation of IP addresses to the servers is a critical task and it's inappropriate to provide IPs without proper IP justification.

Regards,

Shane Phillips

bluetrance05 · #11 (**permalink**) 03-18-09, 13:10

You will need one mysql database if you're not running a business website. But if you do, you will need multiple databases for different web environments in order to store structured data of users' names, passwords, preferences and more.

Nefrec · #12 (**permalink**) 03-19-09, 08:22

If you are using multiple scripts but want to separate them, you could use different databases as well. It is nice to organize everything by it self. Also, they offer that many to attract customers because they know most people won't use that many.

Martin · #13 (**permalink**) 03-21-09, 05:34

We can not only use multiple MySQL databases for the security reasons but also to optimize performance on the website.

Windac · #14 (**permalink**) 03-21-09, 10:21

I've always tried to use more than 1 or 2 databases but I don't really need to. Most of the times, multiple databases are for real, heavy-duty, users. Companies that need to keep stock and stuff like that may use more databases.

userdan · #15 (**permalink**) 05-30-09, 13:24

Personally, I prefer to use multiple databases especially if I have multiple scripts running on the same website. Sure, I can get away with using only one, but it's just that much more organized to have the databases separated. Also, in case of database corruption, at least some parts of your site will still be up.

BlueGigs · #16 (**permalink**) 07-09-09, 17:18

I totally agree with userdan - the ability to create multiple databases keeps me organized. Most of my databases have over a dozen tables, and lumping them into one

e database would give me more than the occasional headache.

centelo · #17 (**permalink**) 07-10-09, 13:50

Quote:

Originally Posted by Shane Phillips

Indeed. Allocation of IP addresses to the servers is a critical task and it's inappropriate to provide IPs without proper IP justification.

A friend of mine runs a fairly small reseller hosting company and has had this issue, and your post made me think back to it. How can you tell the difference between a real justification and a false one? He ended up with a false one and caught it late, after the power had already been abused. :(

JeremyWJ · #18 (**permalink**) 07-10-09, 21:35

I try not to use one database for more than one application. Otherwise its a mess. Organization is key, and that is the reason for more than 1 database.

Plus you run the risk of two applications conflicting trying to use the same table or something, thus corrupting your data.

Gelato · #19 (**permalink**) 11-17-09, 09:25

Quote:

Originally Posted by Shane Phillips

Password that has a mixture of Upercase and Lowercase alphabets with numbers. ;)

And using symbols is also fun too. I try to randomize things and then nobody breaks into your account (or at least very rarely). I substitute in symbols for letters sometimes as well.

carl owen · #20 (**permalink**) 11-17-09, 17:46

It is recommended that you do not save the passwords of the databases or servers and other important websites in your Browser or any other password saving tools and applications for better security