Question: How do I set up a WordPress MU site using multiple databases? The site will become very large if it's all on one database.

Questions

WordPress Development

How do I set up a WordPress MU site using multiple databases? The site will become very large if it's all on one database.

I don't want to use sub-domains, but would rather the set up be www.domain.com/1, www.domain.com/2 etc. I can do this with new wp installations for each - but I go through the home wp site, create a page name 1, then go to Cpanel and create the 1 folder with new setup of WP - this all works, but is this proper?

Answer This Question

Answers

Brandon Brotsky

Dev / Designer / Founder of Brotsky, LLC

Check out these WordPress plugins: https://wordpress.org/plugins/shardb/ and https://premium.wpmudev.org/project/multi-db/

Good luck!

Answered over 8 years ago

Filip Van

WordPress Expert, Consultancy & Coach

What do you mean with large? WordPress MU is handy when you want to centralise plugins and themes. If your sites vary in that way I should propose to use single WordPress installations and control its throughout the Cpanel.

Answered over 8 years ago

Oscar Gonzalez

Websystems expert. Digital & social marketer

You have 2 recommended options. Use single installations for each /1, /2, /3 and a main installation as the home page.

Or just use the one database. As your site grows, if you need to add more resources to the database, you'll add extra database servers to handle the load but the data will still be in one database, you'll just use load-balancing technology to distribute the load.

Answered over 7 years ago