Josh Marshall wrote: > >> I have sometimes wondered about storing (large? say > n mbytes) >> attachments as files outside the DB. > If you use a multi-mailserver system (using a common SQL server) then > these files would then have to be accessible via nfs. It's easier in > my circumstance to have the one location for all the data. With mysql > it's easy to have failover, and with the LVS project it's easy to have > multiple mailservers in a round-robin loop with redundancy. > > With NFS you then have locking issues etc. > > Regards, > Josh. You don't really need locking (as far as I can tell) because you wont modify files, create read and delete are about all. If you are using a multi-sql server system then you should probably be using some kind of perdition thing to get load balance and redundancy. The whole point is as a simple file server can flood a 100mbit link without breaking a sweat. Keep the SQL for doing things SQL is good at (searching, linking togther bunches of different information) and files for well storing files ;->
_______________________________________________ DBmail mailing list [email protected] https://mailman.fastxs.nl/mailman/listinfo/dbmail
