Well, thank you very much for your explanation. My problem is I would like to have the data files being saved in a machine behind a proxy but the server running in a machine outside the proxy (the clients don't have access to the machine behind the proxy).
Any ideas? Thank you --- [EMAIL PROTECTED] wrote: > Ruben Carvalho <[EMAIL PROTECTED]> wrote on > 07/06/2005 11:06:10 > AM: > > > I think I haven't understood your question. I > guess > > that in case of a network failure you can have the > > same behavior as a power shutdown. > > > > About the networked drives? Anyone? > > > > > > --- Martijn Tonies <[EMAIL PROTECTED]> wrote: > > > > > Hi Ruben, > > > > > > > I would like to make a short, quick and simple > > > > question. > > > > > > > > Is it possible to have the following line: > > > > > > > > innodb_data_home_dir="X:/data/" > > > > > > > > in a my.ini config file? > > > > > > > > I'm using windows XP, mysql 4.1.12, X: is a > mapped > > > > network drive to a Linux folder using samba, > all > > > the > > > > permissions are set and tested. > > > > > > > > I have seen this posted many times but without > > > many > > > > replies. I want to use a folder in a mapped > drive > > > to > > > > save my InnoDB data. Is this possible? > > > > > > I don't know this particular answer for MySQL, > but I > > > do have 1 question: > > > > > > If the database engine doesn't have control over > the > > > files > > > and/or drive, what should it do in the case of a > > > network > > > failure? > > > > > > Let alone the latency of a networked file... > > > > > > With regards, > > > > > > Martijn Tonies > > > Database Workbench - tool for InterBase, > Firebird, > > > MySQL, Oracle & MS SQL > > > Server > > > Upscene Productions > > > http://www.upscene.com > > > Database development questions? Check the forum! > > > http://www.databasedevelopmentforum.com > > > > > > > > > > > > Rúben Carvalho > > RDBMS over a network: NOT recommended. Not only can > you not enforce > OS-level locking on your files (maybe you can, I > guess it may depend on > your device and inteface protocols) but the MOST > COMMON bottleneck to > database performance is disk I/O. If you went with > networked storage, you > are not only going to suffer through disk lag (seek > time + rotational > positioning before the operation can start) but you > are incurring network > overhead on top of it IN BOTH DIRECTIONS. > > Unless your network device is flash-only (all > memory, no disks), you just > cut your throughput by at least 75%. And even if > your device is flash-only > you will reduce your data throughput by 25-50% (all > performance numbers > are rough estimates pulled out of my a** but based > on the number of extra > network hops necessary to get at and read your > files). > > I don't care how fast your network is, networked > storage can't be as fast > as local disks. Again, it is highly discouraged to > use networked storage > for anything but the most trivial database uses > (small file sizes, low > traffic, etc). For any application that requires > even modest performance, > spend your money on a fast RAID configuration. You > will be much happier in > the long run. > > Shawn Green > Database Administrator > Unimin Corporation - Spruce Pine Rúben Carvalho ___________________________________________________________ How much free photo storage do you get? Store your holiday snaps for FREE with Yahoo! Photos http://uk.photos.yahoo.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
