We help IT Professionals succeed at work.

Load Balance Wordpress

pixelcellar
pixelcellar asked
on
Medium Priority
1,295 Views
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.
Comment
Watch Question

Commented:
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 http://technet.microsoft.com/en-us/library/cc753479.aspx 

Not the solution you were looking for? Getting a personalized solution is easy.

Ask the Experts

Author

Commented:
jonasp

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

Commented:
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.
Access more of Experts Exchange with a free account
Thanks for using Experts Exchange.

Create a free account to continue.

Limited access with a free account allows you to:

  • View three pieces of content (articles, solutions, posts, and videos)
  • Ask the experts questions (counted toward content limit)
  • Customize your dashboard and profile

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.