Often application needs to know where a user is physically
located. The easiest way to figure that out is by looking up
their IP address in a special database. It can all be implemented
in MySQL, but I often see it done inefficiently. In my post I
will show how to implement a complete solution that offers great
performance.

Importing Geo IP data

First you will require a database mapping network addresses to
real locations. There are various resources available, but I
chose the one nginx web server uses with its
geoip module. GeoLite …

Recently I had to turn a few EC2 instances into MySQL database
servers. The third time I had to do it, I grabbed the list of
steps from my previous sessions and just replayed it. Later I
thought maybe polishing information a little bit and publishing a
step-by-step walkthrough on the blog may help a few people. So
here it is.

Before you begin.

For my MySQL instances I used the following:

Extra Large, High-Memory, and High-CPU instances. Although
the instruction should work on any type of instance.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.