Vikram A wrote:
Is it So? then i may have the following, when ever i want the image of a i
need look for the share machine! If it is not available it may cause some
difficulties.
1) NFS sharing a file (any file) is better suited for this task.
2) The DB should only hold the file path (pointing to the NFS share)
Your comment above, what if the NFS share is unavailable, it will
cause a problem. While this is true, the same can be said about your
SQL server. What if it becomes unavailable?
Point is, use the tools you have available for what they're best
intended for. You can have 1 master server that is both your NFS as
well as your MySQL server and that sits at one end of your intranet.
Then you have the second machine, at the other end of the intranet, act
as the MySQL slave and replicate everything from the master DB. As long
as the paths stored in MySQL are pointing to the NFS path, everything
should work fine.
And if you don't want to run NFS, you can run rsync on the slave
server and pull all the images from the master machine into the slave
one. This will avoid images not being found if your master server goes
down.
There are many ways to skin this cat ...
--
H | It's not a bug - it's an undocumented feature.
+--------------------------------------------------------------------
Ashley M. Kirchner <mailto:ash...@pcraft.com> . 303.442.6410 x130
IT Director / SysAdmin . 800.441.3873 x130
Photo Craft Imaging . 2901 55th Street
http://www.pcraft.com ..... . . . Boulder, CO 80301, U.S.A.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org
