I would like to thank you all for the help and the explanations. I think I'll stick to the option of having the database behind the firewall. The problem is I don't control that part of the company, as you can imagine so I'll have to ask the network administrators for that.
Just want to resume what was said here: - Even if it was possible, RDBMS over a network is not recommended - if you're working behind a firewall, you'd better open a port for your db server - adding SSL can help making it more secure --- [EMAIL PROTECTED] wrote: > Ruben Carvalho <[EMAIL PROTECTED]> wrote on > 07/06/2005 12:54:24 > PM: > > > 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 > > > > There are different kinds of secure setups. As a > first idea, your database > server and your web server DO NOT need to be on the > same machine. There > are MANY ways to setup a secure web system. How many > of each type of > networking component are at your disposal (proxy > servers, firewalls, web > servers, network interface cards, routers, etc.)? > Different types of > security are available with different > hardware/software configurations. > > Basically, it all boils down to keeping the users > only where you want the > users to be (outside of your network) and allowing > only certain servers > (or even just particular processes on those servers) > to access your > internal resources. > > 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]
