Testing With Propagation Delays

I am testing an SQL server on my LAN and the response is very quick. I have problems, though, when testing outside of work over the internet (eg. at Starbucks). There are problems that I only see when there are propagation delays.

How can I stay at work and access my local server after first looping through the internet? If I use the external I.P. address, the router just short circuits to the local machine.

I want the propagation delay. Is there some standard external proxy server I can use to do loopback? I'm wasting too much time driving to Starbucks!

LynnFogwellAsked:
Who is Participating?
 
LynnFogwellAuthor Commented:
MySQL-Proxy is the easiest solution that I found. It is activated with a single, simple command line. I set it up as follows:
I downloaded the latest version of MySQL-Proxy at dev.mysql.com. I created an Amazon EC2 instance (LINUX micro- its free!!!) I then copied the mysql-proxy.tar file, to the EC2 instance, with scp. scp (ssh copy) does an ftp tunnel through my ssh port. I then extracted the tar and ran:

mysql-proxy  --proxy-backend-addresses=123.45.67.89:3306 --daemon

I also needed to open up port 4040 on the EC2 instance (security group function), because that is the default port for the proxy. All my server traffic, including authentication, runs through this proxy. Big fat round-trip delay times...

I had tried iptables, but I could not get it to work (complicated!)  Thanks for the suggestions, above, but this was the 'easiest' for me. Only cost me a day of work....
0
 
nemws1Database AdministratorCommented:
I'd just use a couple SSH tunnels.  Are you familiar with them?
0
 
LynnFogwellAuthor Commented:
I use the terminal shell on my mac. I have never set up any tunneling. I still need a remote machine, right? I have set up an Amazon cloud machine in the past, but that is a good bit of work.
Isn't there a service out there that just provides this? Surely other developers work with various connection qualities.
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

 
Hugh FraserConsultantCommented:
If you've got a separate box with some extra network cards, there's a package called MasterShaper for Linux that will simulate any network delays, whether it's bandwidth or latency, when used as a bridge in your network. It's got a web interface for configuration, and will generate all the graphs you want to see what's happening with your app. I've used it in the past to simulate high-latency trans-Atlantic hops for our systems.

0
 
parparovCommented:
dummynet: http://info.iet.unipi.it/~luigi/dummynet/ 

This may be your tool.
0
 
LynnFogwellAuthor Commented:
I guess i grade myself?
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.