StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

POFile / Image Replication
text
Body
copied!<p>I have a simple question and wish to hear others' experiences regarding which is the best way to replicate images across multiple hosts.</p> <p>I have determined that storing images in the database and then using database replication over multiple hosts would result in maximum availability.</p> <p>The worry I have with the filesystem is the difficulty synchronising the images (e.g I don't want 5 servers all hitting the same server for images!).</p> <p>Now, the only concerns I have with storing images in the database is the extra queries hitting the database and the extra handling i'd have to put in place in apache if I wanted 'virtual' image links to point to database entries. (e.g AddHandler)</p> <p>As far as my understanding goes:</p> <ul> <li>If you have a script serving up the images: Each image would require a database call.</li> <li>If you display the images inline as binary data: Which could be done in a single database call.</li> <li>To provide external / linkable images you would have to add a addHandler for the extension you wish to 'fake' and point it to your scripting language (e.g php, asp).</li> </ul> <p>I might have missed something, but I'm curious if anyone has any better ideas?</p> <hr> <p>Edit: Tom has suggested using mod_rewrite to save using an AddHandler, I have accepted as a proposed solution to the AddHandler issue; however I don't yet feel like I have a complete solution yet so please, please, keep answering ;)</p> <p>A few have suggested using lighttpd over Apache. How different are the ISAPI modules for lighttpd?</p>

Querying!

Guidance

An individual column

Larger individual text columns get their own page to allow for proper reading.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload