I do it quite frequently when i need to debug issues using the staging database running on a remote host.
ssh -L 3306:localhost:3306 usern...@remoteserver.com Then i point my locally running code at 127.0.0.1 and the mysql connection will get carried over ssh. It's not noticeably slower than a direct connection would be - though the quality of either will depend on how fast the connection between you and the server is. Graham On Thu, Mar 4, 2010 at 10:57 AM, Ludwig Magnusson <lud...@itcatapult.com> wrote: > Well I wasn't planning on writing anything complex, mostly simple programs > that I can run on my computer (instead of uploading them to my webabb and > run them there) that does some kind of manipulation with the data. > If there is no simple way of doing it, it's not worth the effort. > /Ludwig > > -----Original Message----- > From: Greg Monroe [mailto:greg.mon...@dukece.com] > Sent: den 4 mars 2010 15:25 > To: 'Apache Torque Users List' > Subject: RE: Can I use torque over ssh? > > All true... but remember that interaction with an SQL Server (regardless > of the method) is generally net traffic intensive. Using a method like > this has two possible "gotchas". > > First, the added complexity may cause communication problems. SQL Servers > are not built around handling frequently dropping packets/clients. Your > code will need to do a lot of transaction protection and you will need to > be prepared to clear out deadlocks created by clients dropping. > > Also, distance and SSH are both going to add some lag factors. So don't > expect the normal SQL rapid response. Make sure all your users are > aware of this too. > > Bottom line, IMHO, this is probably OK for something that just retrieves > a little bit of data... with a nice stable network connection and users > who don't mind lag/variable response times. But I wouldn't build a > fully interactive app that allows data modification, etc with it. > > >> -----Original Message----- >> From: Emmanuel Bardet [mailto:ebar...@bardet-u2ee.com] >> Sent: Thursday, March 04, 2010 3:16 AM >> To: Apache Torque Users List >> Subject: Re: Can I use torque over ssh? >> >> Hello Ludwig, >> >> It's not really Torque related but more to your jdbc driver. From an >> ssh perspective, as long as it uses TCP/IP to connect to your database >> server AND IF your ssh server allows ssh-tunneling (ana ssh-port- >> forwarding) then you should be fine. There's a few how-to available. >> >> E >> >> Le 4 mars 10 à 04/03-08:56, Ludwig Magnusson a écrit : >> >> > Hi! >> > >> > If I have a database on a server that I can connect to via ssh, can >> > I use >> > torque to access that database? I.e write a java program that runs >> > on my >> > compyter but reads/writes to the database. >> > >> > Can I also run maven goals like torque:datadump that connects to the >> > remote >> > database? >> > >> > /Ludwig >> > >> >> >> --------------------------------------------------------------------- >> To unsubscribe, e-mail: torque-user-unsubscr...@db.apache.org >> For additional commands, e-mail: torque-user-h...@db.apache.org > > DukeCE Privacy Statement: > Please be advised that this e-mail and any files transmitted with > it are confidential communication or may otherwise be privileged or > confidential and are intended solely for the individual or entity > to whom they are addressed. If you are not the intended recipient > you may not rely on the contents of this email or any attachments, > and we ask that you please not read, copy or retransmit this > communication, but reply to the sender and destroy the email, its > contents, and all copies thereof immediately. Any unauthorized > dissemination, distribution or copying of this communication is > strictly prohibited. > > --------------------------------------------------------------------- > To unsubscribe, e-mail: torque-user-unsubscr...@db.apache.org > For additional commands, e-mail: torque-user-h...@db.apache.org > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: torque-user-unsubscr...@db.apache.org > For additional commands, e-mail: torque-user-h...@db.apache.org > > --------------------------------------------------------------------- To unsubscribe, e-mail: torque-user-unsubscr...@db.apache.org For additional commands, e-mail: torque-user-h...@db.apache.org
