Forums

Managing content, 2 web servers, 1 DB (6 posts)

  1. bblades
    Member
    Posted 2 years ago #

    I have WordPress installed and load-balanced on two different application servers, both referencing the same mysql DB on one of the servers. How can i ensure content uploaded through the wordpress application is distributed to both servers?

  2. greiz
    Member
    Posted 2 years ago #

    make sure both servers are pointing to the same database host and the same database name,user, and password.

  3. bblades
    Member
    Posted 2 years ago #

    they are. anything else i can check?

  4. greiz
    Member
    Posted 2 years ago #

    Have you checked firewall settings? (if you're running any OS default or 3rd party)

  5. ojobson
    Member
    Posted 1 year ago #

    We recently did something similar, however you still have a single point of failure in that you are operating just one database. Our issue was slightly different in that we were running 5 different websites.

    We opted to use a staging server where we make changes and test before copying content to our load balanced servers. Each of our servers is self contained (running WordPress with it's own database) so we rsync the files and database to each of our load balanced server over SSH using a simple script - all we need do is log on to the staging server and activate the script and all the new content goes live. You can also tailor the script to select which website(s) to update.

    I have written more about load balancing WordPress here.. If anyone is interested I could post details of the script too.

  6. arkgroup
    Member
    Posted 1 year ago #

    bblades,

    I agree with ojobson. Use rsync, it's not so hard, and works fine.

Topic Closed

This topic has been closed to new replies.

About this Topic