[wp-hackers] multiple databases vs different database prefixes
paul at codehooligans.com
Sun Aug 15 22:56:34 UTC 2010
I thought I read somewhere that wordpress.com uses the same basic multisite engine and database setup as you mentioned. Other than having redundant and beefier hardware I thing the architecture scales pretty well.
On Aug 15, 2010, at 6:24 PM, Mike Schinkel wrote:
> Not sure if my advice on the subject would be relevant (I've never done anything that large) but you might be interested in talking to these guys who are offering a service for managing lots of WordPress installs:
> On Aug 15, 2010, at 5:48 PM, Ken Zaraque wrote:
>> Hello to All,
>> I will be creating numerous WP sites - roughly 300+. I will not be using the multisite feature. These are 300+ separate WP installations.
>> Question: Is it better to create each site with it's own database, or should all 300+ sites be in one database but each site having different table prefixes?
>> My concern is scaling. I am concerned that running all 300+ sites in one database would slow down performance vs having separate databases. Although, having all tables be in one database is very convenient if I ever need to share information between sites.
>> Maybe I can use a combination of both?
>> What are your thoughts?
>> wp-hackers mailing list
>> wp-hackers at lists.automattic.com
> wp-hackers mailing list
> wp-hackers at lists.automattic.com
More information about the wp-hackers