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!