I am working on an WordPress multi-site network.Our multi-site network is going to be increase more than 1000 sites (sub site).As i have seen in database every new site create 10 new database tables .So if my network increases up-to 1000 sites then there will be 10000 tables in database.

I want to avoid this and spit this tables into multiple databases.

For this i researched on internet and found WPMU's MULTI DB plugin but which is not available anymore.

Plz suggest me solutions for this or any plug-in(paid/unpaid)

  • 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. WP Multisite has no limit, on creating on sites. But make sure you have purchased a better hosting account data limit according to your site sizes. 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. – Aishan May 18 '17 at 6:36
  • Yes i know it uses single database and there is no limit to create blogs.But if it creates 5000 blogs then there will be 50000 table's in single database. And don't want that much tables in one db so want to split them into multiple databases even i had dedicated server. – CyberAbhay May 20 '17 at 6:04
  • Multi-DB is still available. I used it last year without issues. I is just not supported by WPMU anymore. github.com/wpmudev/multi-db – David Labbe Sep 14 '17 at 14:19
  • @DavidLabbe it is available on GitHub where its entire code using mysql. And i want to use that with php7 – CyberAbhay Sep 15 '17 at 11:20
  • I am confused. Why can't you use it with php7? – David Labbe Sep 15 '17 at 12:32

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.