[CLUG-tech] Synchronise mysql databases with images

J-P Human jp at unix.co.za
Fri Feb 3 16:30:44 SAST 2006


Ok im going to try moving these images into the database, my only concern is
when they do a search it may easily have to display about 500 images at
average of 1mb per image, this may put the server under heavy load. ( they
did just get nice new power edge 1800)

J-P

-----Original Message-----
From: clug-tech-bounces at clug.org.za [mailto:clug-tech-bounces at clug.org.za]
On Behalf Of Calvyn Du Toit
Sent: 03 February 2006 14:25
To: Technical Questions and Answers
Subject: RE: [CLUG-tech] Synchronise mysql databases with images

Why not store them in the database,  that way you only have to worry about
Mysql replicating,  I havent had any problems with images stored in mysql
And some of mine are over 10mb.

 

-----Original Message-----
From: J-P Human [mailto:jp at unix.co.za]
Sent: 03 February 2006 02:20 PM
To: 'Technical Questions and Answers'
Subject: [CLUG-tech] Synchronise mysql databases with images

Hi

I have a php/mysql database I need to keep synchronised between 2 servers (
in remote locations ). Synching mysql is easy enough and the php scripts
rarely change, my problem is the images for the database are stored in a
normal folder on the file system and are constantly changing from both
sides. There is a gig or two of images.

What would be the best way to keep the image folders in sync?

I was thinking of either using something like unison or maybe nfs but when
they create pdfs from the system they need to pull in the images which may
cause the system to look slow if it has to copy the images over nfs over the
net.

Or

I was thinking of storing the images in mysql, people say this is a bad
thing has anybody had experience with this?

Thanks and Regards
J-P Human
021 7944821
083 665 9975
 


--
Clug-tech mailing list
Clug-tech at clug.org.za
To (un)subscribe:
http://lists.clug.org.za/mailman/listinfo/clug-tech
Wiki: http://wiki.clug.org.za
IRC: irc.zanet.net #clug



--
Clug-tech mailing list
Clug-tech at clug.org.za
To (un)subscribe:
http://lists.clug.org.za/mailman/listinfo/clug-tech
Wiki: http://wiki.clug.org.za
IRC: irc.zanet.net #clug



More information about the Clug-tech mailing list