Title: Multisite large database
Last modified: May 24, 2024

---

# Multisite large database

 *  [thecreator01](https://wordpress.org/support/users/thecreator01/)
 * (@thecreator01)
 * [2 years ago](https://wordpress.org/support/topic/multisite-large-database/)
 * Hello, all subsites and main site use the same database. So what kind of solutions
   do you implement when the network grows? I think WordPress no longer supports
   the hyper-db plugin. [https://wordpress.org/plugins/hyperdb/](https://wordpress.org/plugins/hyperdb/)
 * So what database solutions does WordPress offer for a growing multisite? Or any
   ideas?

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

 *  [moeo](https://wordpress.org/support/users/moeo/)
 * (@moeo)
 * [2 years ago](https://wordpress.org/support/topic/multisite-large-database/#post-17782022)
 * Hello
   We use master-slave or master-master replication setup for such huge websites
   so this is something that you may consider. Your server admin should be able 
   to set it up for you.
 *  [geraldine198](https://wordpress.org/support/users/geraldine198/)
 * (@geraldine198)
 * [2 years ago](https://wordpress.org/support/topic/multisite-large-database/#post-17788658)
 * Hello, [@thecreator01](https://wordpress.org/support/users/thecreator01/) [SpotifyPie](https://www.spotify-pie.com)
 * There are several database solutions and strategies you can implement to ensure
   optimal performance and scalability:
 * Database Clustering: Use MySQL clustering to distribute database load across 
   multiple servers. This helps manage high traffic and ensures high availability.
 * Database Replication: Set up master-slave replication for MySQL. The master handles
   write operations, while slaves handle read operations, balancing the load and
   improving performance.
 * Horizontal Scaling: Implement horizontal scaling by splitting your database into
   multiple shards. Each shard can handle a portion of the data, which reduces the
   load on a single database instance.
 * Object Caching: Use an object caching mechanism like Redis or Memcached to reduce
   database load by caching frequently accessed data.
 * WP-Specific Solutions: Consider using plugins designed for scalable WordPress
   environments:
 * HyperDB: Despite WordPress.org no longer supporting HyperDB, you can still use
   it from the GitHub repository. It supports database partitioning, replication,
   and failover.
   DB Cache Reloaded Fix: This plugin caches database queries, reducing
   the load on your database.Hosting Solutions: Consider managed WordPress hosting
   providers that specialize in high-performance, scalable solutions. Providers 
   like WP Engine, Kinsta, and Pantheon offer robust infrastructure with built-in
   scalability.
 * I hope this information helpful to you.
 * Best regards
   geraldine198

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

The topic ‘Multisite large database’ is closed to new replies.

 * In: [Networking WordPress](https://wordpress.org/support/forum/multisite/)
 * 2 replies
 * 3 participants
 * Last reply from: [geraldine198](https://wordpress.org/support/users/geraldine198/)
 * Last activity: [2 years ago](https://wordpress.org/support/topic/multisite-large-database/#post-17788658)
 * Status: not resolved

## Topics

### Topics with no replies

### Non-support topics

### Resolved topics

### Unresolved topics

### All topics