Tell me more ×
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
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

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 specific 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, see the FAQ for guidance.

1 Answer

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.