WP Multisite: different fron-end server, db server and admin

  • Hello All!
    I’ve a question about WordPress installation:
    I need to install 3 sites on different server; each of these can be managed with only one “admin” console on separate server? The db of each site, can be separate and can be hosted on dedicated database server?
    Example:
    SERVER 1
    https://www.site1.com [NOT WP-ADMIN]
    SERVER 2
    https://www.site2.com [NOT WP-ADMIN]
    SERVER 3
    https://www.site3.com [NOT WP-ADMIN]
    SERVER 4
    admin.site.com [ONLY WP-ADMIN]
    SERVER 5 (db server)
    dbsite1
    dbsite2
    dbsite3

    Thanks in advance.

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

  • This is a complicated use-case. I dont think it can be done the way you described above. I think it could be possible if all the data was in one database.

    Thread Starter dariowp

    (@dariowp)

    Thanks,
    If I use only one database, for store all data, the other things are possible?
    I’ve found a WordPress MU Domain Mapping plugin, that enable to manage site on other network: is this case?
    It’s possible disable only front-end side or only back-end site?
    Thanks.

    Hello to all.
    It could be interesting to me too if someone has a solution for the dariowp question.
    Thanks!

    This is how I would do it:
    1) point DNS to their respective servers, as you have designated above
    2) install WP multisite with root at admin.site.com
    3) install Domain Mapping plugin
    4) Create sites and map to server. For example: admin.site.com/site1 -> https://www.site1.com, admin.site.com/site2 -> https://www.site2.com, etc

    The admin console can be removed/deleted from all sub-sites, thereby forcing everyone to use the admin console through admin.site.com. Note that this solution uses one database, which is different than what the OP requested. I cannot think of any way this would work with different databases for each site.

    Thread Starter dariowp

    (@dariowp)

    Thanks jkhongusc.

    I will try to do this on virtual server, before mapping DNS for test, and i will post a feedback.
    The problem for the same db is only for maintenance: suppose in future I will want move only 1 site, i will enable to do this. With only one databse I must do a select for extract data and insert in a separate db.
    I have think that a possible solution is: use a main db for the admin wp with its standard table, and create a custom page/connection/management to a different db, each for every site. The problem in this case is that I’m not enable to join the table (user and permission with my custom table).

    But your solution is a good point where start!
    Thank you very much!
    Dario

    If you want to move a site in the future, even if you separate/shard the multisite database per site you cannot just copy the tables over. There are some site specific tables and some global tables… you will have to do a lot of massaging using this method.

    On the other hand exporting/importing from multisite to another WP single or multisite is fairly straight-forward.

Viewing 6 replies - 1 through 6 (of 6 total)
  • The topic ‘WP Multisite: different fron-end server, db server and admin’ is closed to new replies.