2

I have recently discovered the multisite functionality of the wordpress core. really exciting! After digging around some more, I noticed that the database simply replicates 9 tables each time we create a new subdomain; but keeps them all in the same database.

The project I am in the planning stages for has a high amount of data information to be stored. The information that would be stored would be proprietary for each company that uses the site.

My question is this. How would I go about getting the entire database to replicate vs getting just a few tables to replicate? Basically, I am looking to create exact copies of the site over and over and over, but each site would have its own database. eventually, each copy of the site would be created once a customer has paid to use the service.

I have seen shardb and hyperdb, but they actually just add databases to store tables from multiple subdomains (at least thats how i interpretted it) to increase site speed.

Im not concerned about site speed as much as I am security and redundency.

Any ideas?

Justin Sellers
  • 48
  • 1
  • 7

1 Answers1

4

One of the features of MultiSite is that all the WP instances use a single WP installation, and a single database, just with different tables.

In answer to your question, a plugin you could use for this is Multi DB https://premium.wpmudev.org/project/multi-db/. Although this plugin is no longer officially supported by them anymore, it's still compatible with WP 4.5.3 according to the site.

As for redundancy, you could run 2 linux VM's for hosting the databases, one a primary, one a failover

If you've heard of EduBlogs (Like Wordpress.com, but for education), they host about 3 million blogs using Multisite. The guys behind it are WPMUDev (Linked to above) but here they have a thorough article for Multisite for a large number of sites and the potential Database issues you may encounter: https://premium.wpmudev.org/blog/ultimate-guide-multisite/

AshboDev
  • 370
  • 2
  • 10
  • Would this still have multiple sites in the same database? Not all of them, but this doesn't provide a single database for a single client right? – Justin Sellers Jun 29 '16 at 16:07
  • Basically wiht Multisite you have one database, and each site has a different prefix, based on the blog ID. This plugin doesn't provide a single DB per client, it simply allows you to have multiple databases, with say 200 sites, rather than 1 with 1000. Having each site on a separate DB defeats the point of mutisite. If you're worried about other blogs being able to see the content of others, that won't happen. Security won't be an issue either, provided your clients secure their blogs, themes and plugins. Server security would be something else to look at too! – AshboDev Jun 30 '16 at 08:15