up vote -3 down vote favorite
share [g+] share [fb]

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?

link|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
feedback

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

This question is not a good fit to our Q&A format. We expect answers to generally involve facts, references, or specific expertise; this question will likely solicit opinion, debate, arguments, polling, or extended discussion. See the FAQ for guidance on how to improve it.

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.

link|improve this answer
feedback

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