Title: Multisite database architecture
Last modified: August 31, 2016

---

# Multisite database architecture

 *  [metamp](https://wordpress.org/support/users/metamp/)
 * (@metamp)
 * [10 years, 5 months ago](https://wordpress.org/support/topic/multisite-database-architecture/)
 * Each site in wp multisite has it’s own wp_posts and wp_postsmeta tables with 
   the site id in the table name as a prefix
    now if I want to use the same post
   across 10 sites the post would be duplicated 10 times in wp_posts and wp_postsmeta
   tables.
 * I’m not sure if this is a good solution
 * would it be possible to code posts template page that would pull posts from wp_posts
   table from another site in the multisite network?

Viewing 1 replies (of 1 total)

 *  Moderator [Bet Hannon](https://wordpress.org/support/users/bethannon1/)
 * (@bethannon1)
 * [10 years, 5 months ago](https://wordpress.org/support/topic/multisite-database-architecture/#post-7083360)
 * Have you looked at a plugin like this one: [https://wordpress.org/plugins/multisite-post-duplicator/](https://wordpress.org/plugins/multisite-post-duplicator/)

Viewing 1 replies (of 1 total)

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

 * In: [Networking WordPress](https://wordpress.org/support/forum/multisite/)
 * 1 reply
 * 2 participants
 * Last reply from: [Bet Hannon](https://wordpress.org/support/users/bethannon1/)
 * Last activity: [10 years, 5 months ago](https://wordpress.org/support/topic/multisite-database-architecture/#post-7083360)
 * Status: not resolved

## Topics

### Topics with no replies

### Non-support topics

### Resolved topics

### Unresolved topics

### All topics