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.