Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

I am debating on whether I should have three separate wordpress installs with three separate databases, or whether it would be okay to use multisite (which only uses one central db).

I am concerned that after having my site (blog, photo portfolio, development forum) up for a few years it will start to lag (since mySQL is supposedly not that scalable).

Is this a concern at all? Or should I just go to with multisite?

share|improve this question

closed as not constructive by Shane Madden, Scott Pack, Chris S, voretaq7, mailq Nov 18 '11 at 23:07

As it currently stands, this question is not a good fit for our Q&A format. We expect answers to be supported by facts, references, or expertise, but this question will likely solicit debate, arguments, polling, or extended discussion. If you feel that this question can be improved and possibly reopened, visit the help center for guidance.If this question can be reworded to fit the rules in the help center, please edit the question.

1  
"mySQL is supposedly not that scalable" says who? –  Javier Nov 18 '11 at 2:24
    
Your scalability problems are Wordpress - not mysql. –  symcbean Nov 18 '11 at 10:44

1 Answer 1

up vote 0 down vote accepted

I am debating on whether I should have three separate wordpress installs with three separate databases, or whether it would be okay to use multisite

In the case of Wordpress I doubt you would see any serious difference in database performance between either setup. A wordpress multisite setup creates separate tables for each blog. There are only a few shared tables, and those mostly have to do with user accounts, and supporting the network. The difference between a separate table in the same database, and a separate table in a different database is almost certainly minuscule.

It should be easier to maintain a single instance of Wordpress, and easier to keep it updated. This should almost certainly be a bigger concern.

share|improve this answer

Not the answer you're looking for? Browse other questions tagged or ask your own question.