Load Balance Wordpress
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.
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.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
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.
ASKER
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.