Managing content, 2 web servers, 1 DB

  • 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?

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

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

    Thread Starter bblades

    (@bblades)

    they are. anything else i can check?

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

    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.

    bblades,

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

Viewing 5 replies - 1 through 5 (of 5 total)
  • The topic ‘Managing content, 2 web servers, 1 DB’ is closed to new replies.