WordPress Multisite with thousands of blog

The number of tables is not an issue by itself. Actually separating the tables for each blog make each operation related to a specific blog more performant. Your scaling problem will come more likely from the big monolithic users tables.

Scaling issues will come from the amount of requests your DB will have to handle, not the actual organization of the data, and this is where the flexibility of having of having separate tables per blog shines as a simple technique you can implement is to move some of them to another DB (use blog number modulo 2 to decided which blog goes where between two DB servers)

When will you need to split the DB? IMO with proper caching and modern hardware you should probably handle more then thousands on one server, but this really depends on specific usage patterns.

Related Posts:

  1. Moving a WP Multisite to a subdirectory
  2. Multisite in subfolder – How to make new sites to be in same level subfolders as the main site
  3. How to individually set WP_DEBUG on a sub-directory multisite?
  4. Benefits or Problems for using Sub-Directory vs Sub-Domain install of WP Network
  5. find a random blogid across my multisite network that has at least one post published
  6. Multisite: differences between subdomain and subdirectory mode? Can it be switch after installation?
  7. NGinx + WordPress Subdomain Multi with core in Subdirectory
  8. Built to scale, or worry later?
  9. Multisite installation combining subdomains and subdirectories
  10. SQL Query to Get list of all users along with their blogs
  11. Suppress subdirectory from WordPress Multisite primary URL
  12. Subfolder multisite issue. Themes and plugin files 404
  13. How to do Domain Mapping to Subdirectories?
  14. Using $wpdb Class to Pull Recent Comments Across a Network
  15. Limit multisite/network site names to a property of the user
  16. On WordPress Network(multisite), Sub Blogs in Subdirectories or Subdomains? What’s better?
  17. Split a database will improve performance?
  18. Change multi-site installation from sub-domains to sub-directories
  19. Subdirectory multisite installation with several domain names?
  20. Can’t access WordPress multisite after connecting to domain
  21. WordPress multisite subdirectory on nginx behind reverse proxy
  22. Media library not loading after switching the main site of multisite
  23. Installing multisite on domain with existing subdirectory wordpress installations
  24. Depth > 2 possible with multisite?
  25. How to run a subdirectory multisite install under a subdomain
  26. Within the database, where is the flag which says that a user has Super Admin rights?
  27. Performance on WPMS
  28. Bulk activate a theme on multisite
  29. Make a user administrator to a sub directory site and a contributor to main site in multisite network
  30. Removing a wordpress multisite installation and preserving the database before migrate to nginx
  31. Database Tables Lost Indexes? How to Recover?
  32. Multisite setup help – plain domain/subsite always redirects to domain with subdir multisite
  33. Multiple wordpress installations that shares WordPress & Theme but with separated database
  34. WordPress Multisite new sites in directory
  35. Pushing stored procedure to a multisite database in WordPress
  36. Query to import data from one MultiSite table to another (pages/sub-pages)
  37. multisite subdomain behind reverse proxy
  38. Multisite Subdirectory with same domain subdomain
  39. Will changing the folder name two directories above a fresh wordpress installation break the site?
  40. How to host unrelated pages on WordPress domain
  41. Obtaining user table for one site on multisite set up
  42. new multisite, old db
  43. Renaming admin user on multisite install by MySQL
  44. One Domain, Two Installs of WordPress
  45. Set up Network Locally on a Flash Drive
  46. Multisite installation on an existing single installation
  47. why there is a large file named core in wpmu’s directory?
  48. Multisite – One Site with multiple URLs
  49. Sub-sub folders of WordPress Multisite subdirectory
  50. Delete all user’s meta without knowing all the ‘key’
  51. How to organize my js files
  52. WP MultiSite: Can’t select database error after changing to new domain
  53. After setting up multisite on localhost, requests to localhost redirect to production domain
  54. Working with Reverse Proxies and Multisite Installation
  55. Can I use the same Folder name as a Multisite Blog?
  56. add_blog_option blog ID
  57. Multisite for main in subdirectory, subdomain and subfolders (EN/ES)
  58. Infamous admin login redirect
  59. How to create a blogs category page with Blog-Types Plugin
  60. Trying to Decide Between Reverse-proxy and Multisite
  61. How to use the same “wp_posts” table for different subdirectories in the same DB?
  62. multisite installed on subdomain now want another subsite on subdirectory
  63. Structure of multilingual and multiregional directory listing website for translation
  64. Can I use the main Multisite as a backend only?
  65. Problems with WordPress multisite directories/url structures and admin access after migration
  66. Using WordPress multisite for subsites only
  67. How do I split a single WPML site with 6 languages (English is Main) into Multisite with 5 subfolders
  68. Search returns “Nothing Found” on a sub directory
  69. How To Upload Existing WordPress Site To WordPress Multisite Using SSH
  70. Sub-directory domain on subdomain multisite?
  71. Using multisite, how can I get two different sites on the network to have different active themes?
  72. Max number of sub folders
  73. Multisites with different root directory
  74. WordPress Multisite subdomains and sharing the same upload folder
  75. Get multisite count without php?
  76. Nested folder paths for WordPress multisite
  77. WordPress Multisite redirect loop
  78. WordPress and SQL – Update and Insert from another table if column value doesn’t exist
  79. Multisite, different domains, optional subdirectory, and htaccess
  80. Subdirectory and domain multisite installation
  81. Installed in root, want second in subdirectory
  82. MySql Database In WordPress Multisite
  83. WP Multisite .htaccess interferes with cgi-bin
  84. Multisite Tables the same as Single Install?
  85. Multisite installation without using domain root
  86. Primary site file uploads failing, subdirectory subsites upload fine
  87. Plugin data shared in Multisite
  88. How to put a Custom Folder under one sub-site of Multisite WP?
  89. How can I set up a completely separate (not multisite) WordPress installation as a subdirectory of an existing WordPress blog?
  90. How do I make a copy of WordPress to other folder
  91. Merging versions of wp_posts based on post_title
  92. Is it possible to install a different wordpress installation in a subdirectory? [duplicate]
  93. Moved WP Multisite, cannot access sites
  94. Multi site root site installed on subdomain, with child sites as subdirectories
  95. Too much slow queries with my multisite
  96. How do I remove/delete an old super admin user?
  97. What methods should be used to fend off splogs in a multiuser install? [closed]
  98. Unable to apply theme to WordPress Network Site install
  99. Redirecting two Multisite domains to Single site on different host
  100. Trying to create site-wide Active Directory sync with Multisite
techhipbettruvabetnorabahisbahis forumutaraftarium24eduseduseduedusedusedueduseduseduedu