Load Balance Wordpress

Posted on 2009-02-10
Last Modified: 2012-05-06
I'm looking at implementing Wordpress over 2 load balanced servers that are already setup and in use. The database will be on another server so in theory all will be well with one exception.
Files uploaded (blogs, downloads etc) will only get placed on the node that is used to render the site and as such will need syncing across to the other server. Whilst i could just have this run as a scheduled task and have it nearly always synced I'd rather look at a more elegant solution of creating a database trigger of some kind to run the sync process when a new post is added into the DB, if possible when the newly entered row has reference to an upload.

I need some help with this trigger though; not sure whether to use XCOPY or a third party app like Second Copy or SyncBack so could so with a working example of a trigger using one of these methods preferably.
Question by:pixelcellar
    LVL 2

    Accepted Solution

    It sounds like you're running Windows. How about having a look at DFS and perhaps put the upload directory on a DFS Share. Your can read more about DFS here

    Author Comment


    It is a Windows platform we are running on so i will have a look into the viability of this now. Hadn't really thought about that; just thought of a potential programmatical solution.

    Author Closing Comment

    DFS turned out to be far more efficient than any automated copying process monitoring a folder structure so  I went with that in the end. Obviously you need to install and configure it but was not hard.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Highfive Gives IT Their Time Back

    Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

    Things That Drive Us Nuts Have you noticed the use of the reCaptcha feature at EE and other web sites?  It wants you to read and retype something that looks like this.Insanity!  It's not EE's fault - that's just the way reCaptcha works.  But it is …
    These days socially coordinated efforts have turned into a critical requirement for enterprises.
    The purpose of this video is to demonstrate how to add AdSense Ads to a WordPress Website, and how to set up WordPress to automatically place Ads in Sidebars. This will be demonstrated using a Windows 8 PC. Log into your AdSense account. : Cli…
    The viewer will learn how to create and use a small PHP class to apply a watermark to an image. This video shows the viewer the setup for the PHP watermark as well as important coding language. Continue to Part 2 to learn the core code used in creat…

    760 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    15 Experts available now in Live!

    Get 1:1 Help Now