Title: Multiple WordPress instances with multiple databases
Last modified: June 4, 2020

---

# Multiple WordPress instances with multiple databases

 *  [Vishnu Prajapati](https://wordpress.org/support/users/vishnuprajapati/)
 * (@vishnuprajapati)
 * [6 years ago](https://wordpress.org/support/topic/multiple-wordpress-instances-with-multiple-databases/)
 * Hi Support,
 * We want Multiple WordPress instances with multiple databases. I have done multisite
   by using Network Settings, but we have requirement for multi database for each
   website. can you please help me? how can I do that?
 * Thanks,
    Vishnu

Viewing 3 replies - 1 through 3 (of 3 total)

 *  [JNashHawkins](https://wordpress.org/support/users/jnashhawkins/)
 * (@jnashhawkins)
 * [6 years ago](https://wordpress.org/support/topic/multiple-wordpress-instances-with-multiple-databases/#post-12937999)
 * 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.
 *  [Sachin Suthar](https://wordpress.org/support/users/sachinsuthar759/)
 * (@sachinsuthar759)
 * [6 years ago](https://wordpress.org/support/topic/multiple-wordpress-instances-with-multiple-databases/#post-12943172)
 * Hello [@jnashhawkins](https://wordpress.org/support/users/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](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.
 *  [JNashHawkins](https://wordpress.org/support/users/jnashhawkins/)
 * (@jnashhawkins)
 * [6 years ago](https://wordpress.org/support/topic/multiple-wordpress-instances-with-multiple-databases/#post-12944743)
 * Hi [@sachinsuthar759](https://wordpress.org/support/users/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!

Viewing 3 replies - 1 through 3 (of 3 total)

The topic ‘Multiple WordPress instances with multiple databases’ is closed to new
replies.

## Tags

 * [multi database](https://wordpress.org/support/topic-tag/multi-database/)

 * In: [Networking WordPress](https://wordpress.org/support/forum/multisite/)
 * 3 replies
 * 3 participants
 * Last reply from: [JNashHawkins](https://wordpress.org/support/users/jnashhawkins/)
 * Last activity: [6 years ago](https://wordpress.org/support/topic/multiple-wordpress-instances-with-multiple-databases/#post-12944743)
 * Status: not resolved

## Topics

### Topics with no replies

### Non-support topics

### Resolved topics

### Unresolved topics

### All topics