WPMUdev has a Multi-DB plugin but you won’t see any performance gains from splitting your database up unless you have a very high volume of sites with thousands of tables.
From the plugin instructions:
Step 1: Decide how many databases you
want (16, 256, 4096)So, how do you know that this plugin
is necessary for your install? Well,
there are several factors to consider
beyond the scope of this walkthrough,
but as a basic guideline:1-5,000 blogs/sites you should be fine
with your WordPress default database5,000 – 50,000 blogs/sites – go with
16 databases50,000 – 100,000 blogs/sites – use 256
databases100,000+ blogs/sites – use 4096
databases
Related Posts:
- find a random blogid across my multisite network that has at least one post published
- Within the database, where is the flag which says that a user has Super Admin rights?
- Bulk activate a theme on multisite
- Database Tables Lost Indexes? How to Recover?
- Will changing the folder name two directories above a fresh wordpress installation break the site?
- new multisite, old db
- WP MultiSite: Can’t select database error after changing to new domain
- Get multisite count without php?
- WordPress and SQL – Update and Insert from another table if column value doesn’t exist
- MySql Database In WordPress Multisite
- Plugin data shared in Multisite
- Merging versions of wp_posts based on post_title
- DB connection error after copying a WordPress Multisite instance to a second location
- Add WordPress MU Network Admin via Database
- How to tell which database tables belongs to which multisite site
- what are pmxi tables? [closed]
- Shared table across network
- WP-CLI methods for get_current_blog_id, get_blog_details or $wpdb->prefix
- Multisite: How to store global options vs. site options?
- Built to scale, or worry later?
- Uploading/Deploying a Multi Site Install
- Configure WordPress to read from database only, never write
- Multiple Domains and Subdomains Using Multisite Installation
- SQL Query to Get list of all users along with their blogs
- Is it possible to fix/repair all Index, Primary Key, Unique (and all other) structure of a WordPress MS Database
- Migrating WPMS from apache to IIS7 causes Database Error
- Synchronizing Two WordPress Sites Content
- How to clone and locally run a network for testing
- Two WordPress sites sharing the same database
- Using $wpdb Class to Pull Recent Comments Across a Network
- Is it possible to import a wordpress backup from a single site in to a multi-site configuration?
- How to Move Local Singlesite Database to Remote Multsite Database?
- Multisite Subdomain Using More Resources Than Others?
- How to change the database prefix in multisite (WPMU) install
- Importing Multiple DB to one MU database
- Make WordPress Search for Both Main Domain and Subdomain
- Does WordPress MultiSite use separate MySql databases?
- Bootstrapping WordPress MultiSite Outsite of WordPress – No $wpdb
- Multisite setup creating custom table
- Is there a way to run upgrade.php for one blog?
- Performance on WPMS
- Migrating Multisite – Database error, missing wp_blogs table
- WPML tables not deleted when removing multisite subsite, need help clearing up my sql-file! [closed]
- Removing a wordpress multisite installation and preserving the database before migrate to nginx
- Installed domain-based Multisite but can’t access wp-admin (redirect loop)
- Pushing stored procedure to a multisite database in WordPress
- Multiple multisite instances connecting to the same database
- Query to import data from one MultiSite table to another (pages/sub-pages)
- WordPress Multisite – can I somehow merge the tables?
- Create a database for each site created in multisite?
- WordPress Multisite blogs not working after domain swap
- Least expensive way to get table prefix in multisite installation
- 2 website 1 database… Local to online
- Obtaining user table for one site on multisite set up
- Removing Mutlisite lines stop DB connection
- Renaming admin user on multisite install by MySQL
- how to migrate wpmu from one host to the other?
- Share DB tables between two blogs on the same WP Multisite installation
- How can I create blog specific database table in multisite?
- How many databases do I need?
- How do I display offsite database info on my wordpress site?
- Locking one blog of many in a multi user/blog WordPress installation
- WordPress Multisites or Multiple WP Single sites?
- $wpdb->update prefixes database name to table when executing query
- Delete all user’s meta without knowing all the ‘key’
- Combining user database tables while keeping all other data in seperate for multiple sites?
- How to make multi site with single Database?
- Update WP install to WP network & it broke the DB connection
- Sharing users across multiple sites, each on their own database
- importing data into wordpress db
- How to share User Database between Two Multisite Installations + More
- add_blog_option blog ID
- How long is “as long as possible” in wp_cache_set()?
- WPMU on MySQL limited to 1GB of space?
- How does WP decide how to evaluate database integrity
- How to create a blogs category page with Blog-Types Plugin
- A database for each category?
- Can I use the main Multisite as a backend only?
- Problems with WordPress multisite directories/url structures and admin access after migration
- allow multisite in the installation process
- Error establishing a database connection after moving local wordpressmultisite from one directory to another
- Search returns “Nothing Found” on a sub directory
- How To Upload Existing WordPress Site To WordPress Multisite Using SSH
- WordPress Database Cleanup
- Optimal setup for Multi Domain WordPress with Woocommerce
- wordpress multisite – handle Database
- Importing Posts into New Website with Same User ID’s
- WordPress automatic Login on other page?
- How to reconnect database to existing wordpress multisite setup after changing site name
- Multi-site database upgrade claims success, but db_version not updated
- WordPress Multisite with thousands of blog
- Multiple domain with one database
- WP DB Location for “Next Post to Create” Index Value
- Multisite Tables the same as Single Install?
- WordPress multisite and one database
- WordPress Multisite platform for different city for single db
- 4th Network Site Database Errors?
- Is there a full explanation on how to share a database with two WordPress sites on same server?
- HyperDB, Multisite – on new site creation put site’s tables to specific database
- Too much slow queries with my multisite