By hprashi on
Hi,
I wanted to know how many multisites can be hosted using a same codebase but different databases, without sacrificing performance?
1) wanted an estimate number of sites that can be hosted in
i) shared hosting
ii) virtual
iii) dedicated hosting
given that all the sites have low traffic about 100 hits per day...
2)does having too many databases affect the performance of mysql server?
3)which is preferred .. having seperate database for each of the sites or using the same database for all websites with table prefix?
Comments
=-=
I believe the only time you would use a shared DB , is if you intend on sharing tables. ie: users, sessions, content etc.
The more DBs on a server the more is required of the server yes, this holds true even with a file based CMS on a standard server.
The number of sites you can host is dependant on your servers. No one can answer this witout kwoing everything there is to know about your servers and OS set up. have you done any benchmarking ?
_____________________________________________________________________
My posts & comments are usually dripping with sarcasm.
If you ask nicely I'll give you a towel : )
Probably hundreds, even thousands
If each site is only getting 100 hits a day.
--
Prometheus
it still depends on your specific situation
1)There are many different factors that can affect how many you can host. Your question is like asking how many boxes can be sent to a warehouse using:
a) a vehicle using a road
b) by air
c) by sea
and no, I'm not going to give you any other information other than the boxes are small and light.
As VeryMisunderstood suggested, you should do some benchmarking using the setup you wish to use, e.g. modules, features, and configuration. In each of the categories you ask about the capabilities can vary a lot by hoster/hosting plan or server purchased.
Also shared server's performance can be affected by the other accounts on the server which you are sharing.
2) While my experience is with 'real' Relational DBMSs and not MySQL, which I only use for Drupal, it would depends DB size, usage pattern, available RAM, disk speed(I/O), configuration options etc. An experienced DBA will be able to help you with performance and optimization issues, but quality, experience DBAs are not cheap. Actually poor, inexperienced DBAs are not cheap either, at least in the US.
3) More DBs will increase your maintenance overhead but make it more likely that a problem in a DB will not affect all your sites. A single DB prefixed will be easier to backup, maintain and optimize but can lead to a single point of failure. It all depends on your needs, expecations and capabilities.
As a rule of thumb, the more you want to do, the more traffic you are getting and the more dynamic a site is, the more resources it will take to run it. Since one size does not fit all, any specific answers that someone provides should have YMMV, your milage may vary, attached to it.
Joel