Re: Network drive
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 devic
RE: Network drive
He doesn't need ODBC to make a connection, his Java app is doing that already... I agree with J.R., you should move your database server behind your firewall and just open the one port (3306). If you would prefer, you can designate your database server to use a different port (42000 for example) so that anyone that hits your site with a port scanner won't automatically detect that you are running a MySQL server. Just adjust your Java clients and firewall to use the same port number. This is not a great security suggestion as I personally do not believe in "security through obscurity" but the combination of using an unreserved port and opening only that port through your firewall at least creates two obstacles to anyone wanting to do damage. For a more secure client-server config, enable SSL and require it on all connections. If you add up the effects of SSL + strange port + firewall you can see how each layer contributes to the overall security of your application. Using SSL, even your logins are encrypted. Without it, anyone sniffing your network traffic can see both the queries and the responses. Nothing that goes over the internet can be perfectly secure but there are levels of security that are both reasonable and practical. How much security you need depends entirely on how sensitive your data is. Shawn Green Database Administrator Unimin Corporation - Spruce Pine "J.R. Bullington" <[EMAIL PROTECTED]> wrote on 07/06/2005 01:27:39 PM: > "something" = ODBC is the first thing that comes to mind. > > You can set specific permissions on the ODBC and you don't have to open up > but 1 port (3306 or whatever you choose) in your proxy / firewall. Whenever > your app calls the ODBC, the connection is made and everything is happy. > > Just my $.02 > J.R. > > -Original Message- > From: Ruben Carvalho [mailto:[EMAIL PROTECTED] > Sent: Wednesday, July 06, 2005 1:20 PM > To: [EMAIL PROTECTED] > Cc: mysql@lists.mysql.com > Subject: Re: Network drive > > > I don't have a web server, I mean, I have a standalone java application > running in my clients and the application calls the database. > > Is there any way of having "something" listening to my application calls in > my open machine (outside the > proxy) and this "something" would then call the database running behind the > proxy? > > > > --- [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 > &g
RE: Network drive
"something" = ODBC is the first thing that comes to mind. You can set specific permissions on the ODBC and you don't have to open up but 1 port (3306 or whatever you choose) in your proxy / firewall. Whenever your app calls the ODBC, the connection is made and everything is happy. Just my $.02 J.R. -Original Message- From: Ruben Carvalho [mailto:[EMAIL PROTECTED] Sent: Wednesday, July 06, 2005 1:20 PM To: [EMAIL PROTECTED] Cc: mysql@lists.mysql.com Subject: Re: Network drive I don't have a web server, I mean, I have a standalone java application running in my clients and the application calls the database. Is there any way of having "something" listening to my application calls in my open machine (outside the proxy) and this "something" would then call the database running behind the proxy? --- [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 incurr
Re: Network drive
I don't have a web server, I mean, I have a standalone java application running in my clients and the application calls the database. Is there any way of having "something" listening to my application calls in my open machine (outside the proxy) and this "something" would then call the database running behind the proxy? --- [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 > base
Re: Network drive
Ruben Carvalho wrote: 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 By proxy do you mean firewall? If so, open up/forward the mysql port. Much simpler than trying to get file sharing working through the proxy. I have clients that connect the mysql server through a firewall and there are no issues. Just open up the correct ports and you should be set. It's much more difficult (IMHO) to open up ports for file sharing. Also, if it is a true proxy, this means you will incur even more lag due to the proxy with file sharing. It may be better to keep the files on the machine that is accessible by the clients: then use whatever kind of firewall software/hardware necessary to keep the computer more secure (if that's the aim of the proxy.) If it's necessary to keep the files on the computer behind the proxy for backup purposes, then ftp|sftp etc through the proxy|firewall with hot backup|db dump may be the best option. Again, a quick breakdown of what you are trying to do may lead to better suggestions from the list. -- Thanks, James -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Network drive
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
Re: Network drive
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]
Re: Network drive
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
Re: Network drive
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 ___ Yahoo! Messenger - NEW crystal clear PC to PC calling worldwide with voicemail http://uk.messenger.yahoo.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Network drive
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 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Network drive
Hello everyone, 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? Thank you very much Rúben Carvalho ___ Yahoo! Messenger - NEW crystal clear PC to PC calling worldwide with voicemail http://uk.messenger.yahoo.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Network drive for datadir
Neil Freeman writes: > Thanks for doing the test Miguel - yes my drive is mapped correctly. Does not want to > work though :( > Hi! Try putting both basedir and datadir on X: ... -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus <___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Network drive for datadir
Thanks for doing the test Miguel - yes my drive is mapped correctly. Does not want to work though :( Miguel Angel Solorzano wrote: > At 16:00 04/02/2002 +, Neil Freeman wrote: > Hi! > > I did the test in my small network and works. The only care I > did is to mapped the network drive, assign a letter (in my case > F). Please take a look if effectively you had mapped the drive > X (trying to access the X drive with an DOS prompt). > > Regards, > Miguel > > >Hi, > > > >Ideally I wish to keep all of my database files on a network drive > >(X:\). Using WinMySQLAdmin.exe I have created a my.ini file which > >resides in my WINNT directory. > > > >my.ini contents... > >[mysqld] > >basedir=C:/mysql > >#bind-address=127.0.0.1 > >datadir=X:/Shared/MyData/data > >#language=C:/mysql/share/your language directory > >#slow query log#= > >#tmpdir#= > >#port=3306 > >#set-variable=key_buffer=16M > >[WinMySQLadmin] > >Server=C:/mysql/bin/mysqld-nt.exe > >user=guest > >password=guest > > > >Upon starting the MySQL service though I receive the error message > >"Could not start the Mysql service on \\DELL02. Error 1067: The process > >terminated unexpectedly". I have copied the databases to a local drive > >(D:\) and altered the my.ini file and all works well. > > > >Does anyone know why I cannot use MySQL to access databases on a > >networked drive??? > > > >Neil > > > > > > Email: [EMAIL PROTECTED] > > [EMAIL PROTECTED] > > > > > > > > > >- > >Before posting, please check: > >http://www.mysql.com/manual.php (the manual) > >http://lists.mysql.com/ (the list archive) > > > >To request this thread, e-mail <[EMAIL PROTECTED]> > >To unsubscribe, e-mail <[EMAIL PROTECTED]> > >Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > > -- > For technical support contracts, goto https://order.mysql.com/ > __ ___ ___ __ >/ |/ /_ __/ __/ __ \/ /Miguel A. Solórzano <[EMAIL PROTECTED]> > / /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer > /_/ /_/\_, /___/\___\_\___/ Mogi das Cruzes - São Paulo, Brazil > <___/ www.mysql.com > > - > Before posting, please check: >http://www.mysql.com/manual.php (the manual) >http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > > *** > This message was virus checked with: SAVI 3.53 Jan 2002 > last updated 30th January 2002 > *** -- Email: [EMAIL PROTECTED] [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Network drive for datadir
At 16:00 04/02/2002 +, Neil Freeman wrote: Hi! I did the test in my small network and works. The only care I did is to mapped the network drive, assign a letter (in my case F). Please take a look if effectively you had mapped the drive X (trying to access the X drive with an DOS prompt). Regards, Miguel >Hi, > >Ideally I wish to keep all of my database files on a network drive >(X:\). Using WinMySQLAdmin.exe I have created a my.ini file which >resides in my WINNT directory. > >my.ini contents... >[mysqld] >basedir=C:/mysql >#bind-address=127.0.0.1 >datadir=X:/Shared/MyData/data >#language=C:/mysql/share/your language directory >#slow query log#= >#tmpdir#= >#port=3306 >#set-variable=key_buffer=16M >[WinMySQLadmin] >Server=C:/mysql/bin/mysqld-nt.exe >user=guest >password=guest > >Upon starting the MySQL service though I receive the error message >"Could not start the Mysql service on \\DELL02. Error 1067: The process >terminated unexpectedly". I have copied the databases to a local drive >(D:\) and altered the my.ini file and all works well. > >Does anyone know why I cannot use MySQL to access databases on a >networked drive??? > >Neil > > > Email: [EMAIL PROTECTED] > [EMAIL PROTECTED] > > > > >- >Before posting, please check: >http://www.mysql.com/manual.php (the manual) >http://lists.mysql.com/ (the list archive) > >To request this thread, e-mail <[EMAIL PROTECTED]> >To unsubscribe, e-mail <[EMAIL PROTECTED]> >Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- For technical support contracts, goto https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Miguel A. Solórzano <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer /_/ /_/\_, /___/\___\_\___/ Mogi das Cruzes - São Paulo, Brazil <___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Network drive for datadir
Neil, Tuesday, February 05, 2002, 11:19:35 AM, you wrote: NF> That's a bit of a pain :) Any idea if this will be supported at some point? Apparently it will not be supported. Disk file system differs from networking file system. MySQL will not work via networking file system. NF> Cheers, Neil NF> Victoria Reznichenko wrote: >> Neil, >> >> Monday, February 04, 2002, 6:00:18 PM, you wrote: >> NF> Hi, >> >> NF> Ideally I wish to keep all of my database files on a network drive >> NF> (X:\). Using WinMySQLAdmin.exe I have created a my.ini file which >> NF> resides in my WINNT directory. >> >> NF> Upon starting the MySQL service though I receive the error message >> NF> "Could not start the Mysql service on \\DELL02. Error 1067: The process >> NF> terminated unexpectedly". I have copied the databases to a local drive >> NF> (D:\) and altered the my.ini file and all works well. >> >> NF> Does anyone know why I cannot use MySQL to access databases on a >> NF> networked drive??? >> >> MySQL doesnt support loading files from Windows/samba shares. >> -- For technical support contracts, goto https://order.mysql.com/ This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net <___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Network drive for datadir
That's a bit of a pain :) Any idea if this will be supported at some point? Cheers, Neil Victoria Reznichenko wrote: > Neil, > > Monday, February 04, 2002, 6:00:18 PM, you wrote: > NF> Hi, > > NF> Ideally I wish to keep all of my database files on a network drive > NF> (X:\). Using WinMySQLAdmin.exe I have created a my.ini file which > NF> resides in my WINNT directory. > > NF> my.ini contents... > NF> [mysqld] > NF> basedir=C:/mysql > NF> #bind-address=127.0.0.1 > NF> datadir=X:/Shared/MyData/data > NF> #language=C:/mysql/share/your language directory > NF> #slow query log#= > NF> #tmpdir#= > NF> #port=3306 > NF> #set-variable=key_buffer=16M > NF> [WinMySQLadmin] > NF> Server=C:/mysql/bin/mysqld-nt.exe > NF> user=guest > NF> password=guest > > NF> Upon starting the MySQL service though I receive the error message > NF> "Could not start the Mysql service on \\DELL02. Error 1067: The process > NF> terminated unexpectedly". I have copied the databases to a local drive > NF> (D:\) and altered the my.ini file and all works well. > > NF> Does anyone know why I cannot use MySQL to access databases on a > NF> networked drive??? > > MySQL doesnt support loading files from Windows/samba shares. > > NF> Neil > > -- > For technical support contracts, goto https://order.mysql.com/ > This email is sponsored by Ensita.net http://www.ensita.net/ >__ ___ ___ __ > / |/ /_ __/ __/ __ \/ /Victoria Reznichenko > / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] > /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ><___/ www.mysql.com > > - > Before posting, please check: >http://www.mysql.com/manual.php (the manual) >http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > > *** > This message was virus checked with: SAVI 3.53 Jan 2002 > last updated 30th January 2002 > *** -- Email: [EMAIL PROTECTED] [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Network drive for datadir
Neil, Monday, February 04, 2002, 6:00:18 PM, you wrote: NF> Hi, NF> Ideally I wish to keep all of my database files on a network drive NF> (X:\). Using WinMySQLAdmin.exe I have created a my.ini file which NF> resides in my WINNT directory. NF> my.ini contents... NF> [mysqld] NF> basedir=C:/mysql NF> #bind-address=127.0.0.1 NF> datadir=X:/Shared/MyData/data NF> #language=C:/mysql/share/your language directory NF> #slow query log#= NF> #tmpdir#= NF> #port=3306 NF> #set-variable=key_buffer=16M NF> [WinMySQLadmin] NF> Server=C:/mysql/bin/mysqld-nt.exe NF> user=guest NF> password=guest NF> Upon starting the MySQL service though I receive the error message NF> "Could not start the Mysql service on \\DELL02. Error 1067: The process NF> terminated unexpectedly". I have copied the databases to a local drive NF> (D:\) and altered the my.ini file and all works well. NF> Does anyone know why I cannot use MySQL to access databases on a NF> networked drive??? MySQL doesnt support loading files from Windows/samba shares. NF> Neil -- For technical support contracts, goto https://order.mysql.com/ This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net <___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Network drive for datadir
Hi, Ideally I wish to keep all of my database files on a network drive (X:\). Using WinMySQLAdmin.exe I have created a my.ini file which resides in my WINNT directory. my.ini contents... [mysqld] basedir=C:/mysql #bind-address=127.0.0.1 datadir=X:/Shared/MyData/data #language=C:/mysql/share/your language directory #slow query log#= #tmpdir#= #port=3306 #set-variable=key_buffer=16M [WinMySQLadmin] Server=C:/mysql/bin/mysqld-nt.exe user=guest password=guest Upon starting the MySQL service though I receive the error message "Could not start the Mysql service on \\DELL02. Error 1067: The process terminated unexpectedly". I have copied the databases to a local drive (D:\) and altered the my.ini file and all works well. Does anyone know why I cannot use MySQL to access databases on a networked drive??? Neil Email: [EMAIL PROTECTED] [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
