Multiple WordPress instances with multiple databases

If you want a database for each website then you need to run discrete sites instead of a multisite…

The closest you can get to having a discrete database for each multisite would be to run either hyperdb or shardb on your multisite and shard the databases. Your user database and network data tables will still be on the main site.

If you need to be able to export sites after a time from the multisite then you might look at something like NS Cloner but I think you’ll need the pro version of that free plugin.

Hope this helps… and there was an ebook available at one time for the shardb database setup if a Hyper or Sharded Database will do the trick.

Hello @jnashhawkins
I’ve tried this to create multi site with different database using that plugin which are recommended by you. but the plugin will not create a separate database it will create only another tables.

as u can see in the screenshot https://prnt.sc/suarkl, there are multiple table will create it self. i need separate database to handle separate site.

I’ve required to create Multi-Tenant concept which have one admin and multiple site with their separate database.

Can you please help me with create Multi-Tenant solution of wordpress.

Thanks
Sachin.

Hi @sachinsuthar759,

Reread my answer above about discrete WordPress instances. A control panel makes that a bit easier but Multisite is just one large database…

Sharded databases are as close as you’ll get to that in a WordPress multisite.

CPanel, WebMin, maybe Sentora, or my new favorite, VestaCP, would be great for a control panel. In the above order for most users.

You’ll find lots of info about multisite on sites such as WPMUDev.

From what I’ve seen, WHMCS has some hooks for ‘on the fly’, user-driven provisioning if that’s your concern. I know very little about WHMCS and that’s not a subject for these forums. StackExchange might be a better forum for that.

My own leanings would be toward Multisite with database sharding… secondbest for me would be the control panel and WHMCS but I’m not willing to learn WHMCS just for that.

—
Another option that comes to mind is to dump all that ‘noise’ on a really good Web Reseller system such as GoDaddy’s Wild West Domains or Liquidnet’s Reseller program.

—
It’s probably not a good idea to continue any of this thread on this other OP’s topic. If you need more help feel free to start your own topic. Thanks!