time out's while FTPing files between servers

Hi all,

The website runs on 4 webservers(CFMX) that are load balanced.

We have a page that lets a user upload images/video to the website.

So when they come to the website they are basically on one of the 4 machines. Say Machine 1.

So if an image gets approved, the plan is to FTP it to the other servers using CFFTP. The images are less than 1000k and video files are less than 2000k.

How should I handle scenario when the file transfer fails(especially because of timeouts) and the files are not on all the servers. I do plan to run a scheduled task at midnight to sync the servers.

Any leads or suggestions will be very usefull.

tx,
rig

I would keep a record in the database for each uploaded image, with a column for synchronized, set to false by default. Once the image is copied you can set this to true. This way you can tell which images failed to copy correctly and you can try again (or just set your scheduled task to query for and copy all images where synchronized is false).