At current stage I have two servers installed, whereby the first one
does all, but the second is a database server.

I need to install on different location a server pair, which should work
together, fail-fall-over, ...

The idea is to have in the dns for the servers:

abc.example.com <== general term
tw.abc.example.com <== redirected to, if the user is closer to Taiwan
de.abc.example.com <== redirected to, if the user is closer to Germany

abc will be in my office (10Mbps), tw.abc & de.abc are server
co-location with each 150 Mbps.

The database server is connected to the web server via second Ethernet
port and a private IP (192.168.x.x) via cross over cable.
The other ethernet port of the web server is connected to the Internet
(either through another ADSL, like at my office) or to like the web
server directly to the Internet HUB.
The mySQL servers should be set-up as a cluster server and should work
together within a VPN.

Questions:
1. Any hints on above configuration?
2. Has anybody experience with a cluster mysql?
3. How to get the web servers working with the closest connection
(according to the users IP) ?
4. How do I get info about the users IP (within the web server) to
provide startup settings, like Time zone & so time of the user,
language, country, ... ?
5. How to make it fail-fall-over if one of the server (web and/or
database server!) is not working?

Thanks for you input!

bye

Ronald

Ronald Wiplinger wrote:

> Questions:
> 1. Any hints on above configuration?

I would take a look at LinuxHA for a high-availability N+1 solution.

> 2. Has anybody experience with a cluster mysql?
> 3. How to get the web servers working with the closest connection
> (according to the users IP) ?

You could set up two different views on your DNS, and then try to pick
the right view depending on the geographical location of your customer.
There are also systems out there that will examine the routing tables,
and pick the "closest" server based on that. I think UltraMonkey will
do something like that.

> 4. How do I get info about the users IP (within the web server) to
> provide startup settings, like Time zone & so time of the user,
> language, country, ... ?

Geographical mapping of the IP is your best option. Lookup the IP in a
database to determine the country, then set a default for timezone,
language etc., but let the user override it.

> 5. How to make it fail-fall-over if one of the server (web and/or
> database server!) is not working?

A high availability for geographically dispersed servers? Maybe you
should take a look at Linux Virtual Server, I'm not certain it'll
though.


/Per Jessen, Zürich