My hosted database is supposed to be in one location, but the IP that gets returned is in another.

lor1974
lor1974 used Ask the Experts™
on
Hello,

I have a database that is supposed to be hosted in Toronto.  I discovered today that when I am connected to the database, the IP I see is located in Saint Louis, Missouri.  I asked the host why this is, and the response I got was that this is normal to see from this company, and even though the server is indeed in Toronto, the extra hops on the traceroute are normal.

When I do the trace, I see the hops going from:

1 = my local ISP in Montreal
2 = Bell Canada in Toronto
3 = The host in Toronto  (I would expect it to stop here)
4 = The host in Chicago
5 = A different IP of the host in Chicago
6 = again the same as 5
7 = the last hop of the host in Missouri (which is the IP that I actually see from my pc while connected to the database)

It does not make sense to me that I am not seeing the IP from Toronto where my data is supposed to be stored.  Is there a logical reason for this?  Am I seeing some sort of IP spoofing/masking, or does my data actually reside in Missouri?

Any insight is appreciated!

Thanks
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Dave BaldwinFixer of Problems
Most Valuable Expert 2014

Commented:
First line support rarely knows where things actually are.  The network admins are likely to put your data where ever it 'needs' to be.  Is it actually important?  

Large hosting companies have data centers in many locations.  Godaddy, for example, has their original site in Arizona but they also have a data center in Texas and probably other locations.  They only way you will know this is if you get an actual IP address that you can use to look up a location.

Author

Commented:
Is it important...yes, our contract is for the data to be in Toronto.  Under no circumstances can it be in the US.  While the hosting company is very large, with many locations, we are dealing with a 3rd party and have been guaranteed that all is on the up & up.  This is a major corporate contract, and not a generic, GoDaddy type of web hosting setup.

While I would be shocked to find out our database is not where it is supposed to be, I am looking for a technical reason to explain why the IP would be coming from one of their other locations.

Thanks
Dave BaldwinFixer of Problems
Most Valuable Expert 2014

Commented:
Can you post the IP address so we can cross check it?
Top Expert 2016

Commented:
they could have a mpls from the Toronto data center to their St Louis location.  So technically the data resides in Toronto and St. Louis is load balanced location for customer access.  The differentiation is between their internal storage and their external access. For the same reasoning their external endpoint could be in Toronto but internally the data center is located in Missouri.  The second scenario would have you believe that the data is in Toronto but actually stored in the US.

What you would prefer is that the internal and external locations do not cross the border.

Author

Commented:
David, what you are saying makes sense and I have reached out to my contact to try and get a more detailed answer to the question.  I will follow up after I get the response.

Thanks

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial