Euronode

This pages describes the way the euronode mirror works

We are moving to a system where we have geographically specific servers (nodes); we will try to direct users to the node which is appropriate for them.

The node for a given server is specified in the hg.conf file; e.g. the machines in california will have the following in their hg.conf file:

browser.node=1

The euronode will have:

browser.node=2

We may add other nodes in the future (e.g. in asia).

The table hgFixed.gbNodeReal contains the metadata for each node (e.g. domain, country and description).

The table hgcentral.geoIpNode is used to map a user's IP to the appropriate node. If an IP is not found in geoIpNode, the system assumes the user belongs in node 1 (UCSC).

hgcentral.geoIpNode is based on hgFixed.geoIpNode, which built by Galt using a publicly available IP => country mapping database. The copy in hgcentral may be modified (e.g. to add the IP used by QA team for testing).

Note that the IP's are stored in the tables using a numeric representation (for speed). mysql has a built in function, INET_ATON, which can be used to convert the dotted notation to the numeric form; e.g. to add a new entry to geoIpNode:

hgsql hgcentral -s -e "insert into geoIpNode VALUES (INET_ATON('128.114.49.36'), INET_ATON('128.114.49.36'), 2)"