托管数千个Wordpress安装时，MySQL的最佳做法是什么？

Question

When hosting thousands (or potentially millions) of iterations of Wordpress (e.g wordpress.com), is it better to to have one database per install, or assign a prefix to each install and use only one database?

Obviously, it would be easier (from an administration prospective) to create a new database for every install, but how does it affect server resources?

Maybe there is compromise between functionality and resource saving, for instance; grouping 100 installs per 1 MySQL database (using unique table prefixes for each install).

What is MySQL best practice when scaling multiple installs of any script that uses a database?

Any help would be greatly appreciated.

Many thanks, S.>

Answer 1

If you have "potentially millions" of mysql installs, you might end up needing multiple mysql servers.

I think sharing the databases and having multiple prefixes makes no sense, given you definitely need to be able to "move clients around" and to "protect clients from each other", this is achieved by having one db per wp install.

HTH.