[wp-hackers] multiple databases vs different database prefixes
kenzaraque at gmail.com
Mon Aug 16 04:04:43 UTC 2010
Thank you for all the responses.
What I am hearing is "a single database instance with different prefixes per site" is a good way to go... A good example of how well it scales is wordpress.com . Am I right?
To those who recommended hosting sites: currently the client needs the sites to be hosted internally. If that changes, I will definitely look into the links you recommended.
On Aug 15, 2010, at 4:26 PM, Mike Schinkel wrote:
> On Aug 15, 2010, at 7:24 PM, scribu wrote:
>> On Mon, Aug 16, 2010 at 2:11 AM, Mike Schinkel <mikeschinkel at newclarity.net>wrote:
>>> The fact is the multisite creates multiple databases with different table
>>> prefixes for each site. And with the addition of HyperDB you should be
>>> able to use multiple databases if and when you need to all with one
>>> WordPress multisite installation that will make managing all the sites much
>> To be exact, by default, MS creates tables with different prefixes in a
>> single database.
> Yes, typo on my part, thanks for correcting.
> wp-hackers mailing list
> wp-hackers at lists.automattic.com
More information about the wp-hackers