I have bought hosting with PRQ.se. They only allow one sql database per account. I need to install vBulletin, vBSEO, Openx and Piwik to the account. Would I be able to point all of them to the one sql database or would they need seperate databases each? Thank you.
Damn, that is not good news. Why would a hosting company only allow one database per account? I feel cheated
As SQL database increases server load - therefore the company you bought from dont want to increase their server load - there might be 100-factors why they dont want to increase server load - if you have opt for budget plan.
Just been told this: 02:33:57 PM) Host: As long as they all access the same database using the same username and password, it should be able to as long as all those use a compatible database. (02:34:57 PM) Cassandra: What would make the database "compatible"? If all the scripts performed the same function or what? (02:38:55 PM) Host: Well, it would need to have the same tables, otherwise you're going to get a huge database that will take more time to access since you would have the tables and data from four different apps. It's possible to do it without them needing a compatible database, but it isn't recommended. I have no idea what to do now
What does all this talk about compatibility etc. mean? You can pretty much have as many applications using one database as you want. You can even install multiple instances of wordpress that use the same database - just use a different table prefix. Especially if you are talking about different php scripts, you can go ahead and install them all in parallel. In some rare cases the applications might try to create a database with the same name, so try to use a different prefix on all your scripts that support it.
You should be able to run multiple sites on one SQL database. It is preferred to have multiple databases, but they should work on one. If you host is limiting you to one database, you should find a different host.
I totally agree, i have hundreds of scripts all using the same database with hundreds of tables and there are no lagging issues at all. The servers are now clustered, however, this was only for redundancy and nothing else. As mentioned previously just use different prefixes for your applications so there is no possibility of two applications trying to use the same table name.