Share certain DB tables across the network

  • Straight to the question – i do have 3 sites:

    main.xyz – my store for stuff
    help.main.xyz – dedicated support website (for visual distinguishing)
    authors.main.xyz – and the third one, where users can submit their items and details for approval, before appearing on the first website.
    What i’m trying to get is: all 3 websites sharing most of database tables, such as users, items, orders, etc, but i need some tables (wp_options, for example) to be unique (so there is few tables for all websites that should be excluded from uniting).

    I already know about [define Custom_USER_TABLE] function, which is no use for multiple tables. And i’ve looked into Broadcast plugin (which might be bad, as i use same DB for all websites and it will literally kill DB with duplicates (sorry if i’m wrong)).

    So, is there any way to define DB table prefix (through wp-config maybe?) for certain tables or tables themselves for multiple domains inside WP Multisite installation?

    Any help would be much appreciated!

Viewing 1 replies (of 1 total)
  • Moderator Tellyworth

    (@tellyworth)

    I suspect the easier approach would be to have a single site, and use a plugin that allows the use of multiple domains on that site. There is a plugin called Multiple Domain Mapping on Single Site that might do what you need.

Viewing 1 replies (of 1 total)
  • The topic ‘Share certain DB tables across the network’ is closed to new replies.

Tags