Are 10 Databases better than 1?

Gary_Kambic

Hello,

A web hosting service is offering 10 MySQL data bases instead of the usual one. I asked them why, and they said that I could split the seven tables I have into individual tables on each of the data bases. They said this would be more efficient and prevent the message "Too many connections" I have been receiving from my current hosting service.

I guess my question is: is it more efficient to keep all the tables on one data base or to separate them onto their own data base?

Thanks for the help,

Gary

Sxooter

Sounds like these guys have no clue.

you have multiple databases because you have multiple, unrelated datasets that don't need to interact.

If all your data are related, then put them in the same database.

Seperating out your selects for the same site onto 10 different databases is NOT a good solution to the "too many connects" problem.

stolzyboy

where do you host so i make sure NOT to ever go there

like Sxooter says, i don't think they have a clue what they are talking about

Gary_Kambic

Here's what the guy said:

"We would allow you to have up to 10 databases. Each database can have multiple tables/entries/etc... You would be able to store your data in different databases, and most likely on different database servers. If you can split your site to access different databases for different things then yes, it should help with the connections errors you see."

They told me their settings are as follows:

Our max_connections is set to 200, however our max_user_connections

is set to 20. As long as your are properly closing your connections
this should not be a problem. Our wait_timeout is 600.

I think I will still go with them. My current web hosting company must have something configured wrong on their MySQL server as I don't think I should be receiving so many "Too many connections" error messages.

Any problem with their settings?

Thanks for the information.

stolzyboy

I think the 20 user connection limit is kinda low, wow you can only have 20 people on your site accessing mysql at once, pretty crappy, kinda makes a forum or something of the like undoable

Gary_Kambic

I agree with you that it is really poor.

The Hosting Site I'm considering is:

http://www.pair.com

My current Hosting Site is:

http://www.bizland.com

I receive "500 Internal Server Errors" and "Too Many Connections: MySQL" Quite often with bizland.

Can you guys recommend a good Hosting Site that can handle thousands of MySQL queries simultaneously?

Thanks, Gary

stolzyboy

www.olm.net is what i usually use

Sxooter

Originally posted by Gary Kambic
I agree with you that it is really poor.

The Hosting Site I'm considering is:

http://www.pair.com

My current Hosting Site is:

http://www.bizland.com

I receive "500 Internal Server Errors" and "Too Many Connections: MySQL" Quite often with bizland.

Can you guys recommend a good Hosting Site that can handle thousands of MySQL queries simultaneously?

Thanks, Gary

So, I assume those guys are hosting on windows, since 500 errors are pretty common on that platform.

I'd recommend a good BSD/Linux based hosting company. I've found that places that host on Windows are often much lower on the food chart than those that host using some flavor of Unix.

Gary_Kambic

Thanks for all the info. I will be more careful when selecting my next hosting company.

abda53

you should check out http://www.icestorn.com on the special packages.. ive been with them for a few years, and have 2 sites hosted with them. and if you do sign up, put down abda53.com or upixs.com as a referal 😃

stolzyboy

Originally posted by abda53
you should check out http://www.icestorn.com on the special packages.. ive been with them for a few years, and have 2 sites hosted with them. and if you do sign up, put down abda53.com or upixs.com as a referal 😃

i think he means www.icestorm.com not www.icestorn.com

abda53

thank you
typos!! but yeah.. www.icestorm.com good stuff check it out (im not tryin to spam or nothin.. i feel it just is that good..

csn

Wow, this is bad - sounds like they just want to be able to market "10 mysql databases"!!!

Two points:

splitting related tables into 2 or more databases will make relational queries impossible, i.e.:

select * from tab1, tab2 where tab1.id=tab2.id1

Splitting tables up into 2 or more databases would actually require more connections. In a single script you'd have to establish a separate connection to each database.