One wordpress site on two server instances sharing the same database.

  • Greetings all!

    I had a look at the WP support topic, Installing Multiple WordPress Instances and it deals with two WP sites connected to one database by using different prefixes.

    This does not quite fit what I am attempting to do with WP but it puts me in the right direction.

    The following is an example of what I would consider my perfect WP setup:

    1. Four server instances
    2. Server 1 WP site, MY-WPsite.com (same site as server 2)
    3. Server 2 WP site, MY-WPsite.com (same site as server 1)
    4. Server 3 One shared Database for MY-WPsite.com on servers 1 & 2
    5. Server 4 WP site, staging.MY-WPsite.com (Although this could perhaps be a subdomain on server 1…???)
    6. Load Balancer for servers 1 & 2 directing traffic from servers 1 & 2

    What I do know how to do:

    Setup and secure an Nginx server from a-z. Install and harden WP on that server. Point the DNS to that server. After this, the above becomes a blur…

    Like, how do you install the same WP site on two different server instances and connect the site to a database which resides on a third server instance?

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

  • This is way outside of the scope of this WordPress support forum.

    You should be able to share the database by pointing the WordPress toward the same single database… A better idea might be to replicate the databases within the SQL server for each of the two web servers.

    You might find some help for this kind of project at StackExchange or some dedicated MySQL support sites. Google for that…

    My advice? Put your money on a single decent web server or VPS. Use a really good cache plugin with an actual CDN… Cloudflare is more of a proxy than a CDN but you might spend the extra funds on a Cloudflare account if you think you need that upgrade after you start with a free account there.

    As to the staging site? I don’t normally use them! But I’m not a designer either. My thoughts about staging sites are… Some big sheets of paper and… well that’s about it.

    Aim for slight but continuous improvements instead. Don’t jar your regular visitors with sudden, huge changes.

    Content is King!

    Thread Starter agod

    (@agod)

    Thanks for your assistance and advice. I think you are right. Your suggestion is actually part of the conclusion I came to.

    The other half of that conclusion is doing all of what you mentioned except I think I’ll still put the database on a separate server. Would love to hear your thoughts on that, thanks.

    • This reply was modified 3 years, 8 months ago by agod.
    • This reply was modified 3 years, 8 months ago by agod.
Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘One wordpress site on two server instances sharing the same database.’ is closed to new replies.