timezone and visitor address

rblampain · 01-05-2006, 08:16 AM

Our problem:
We are setting up a world-wide Not-For-Profit organization and we'd like to segregate the members according to their timezone in order to
disconnect and carry out maintenance every day between 2 and 2:30 AM for every time zone.

When a member access our system, this member would be directed to a particular hard drive containing the data pertaining to the member's particular timezone.

Is there anyone with some experience in this? Some hints etc?

bigrigdriver · 01-08-2006, 01:48 AM

I don't have any experience setting up such an arrangement. If I had to try, I'd probably try to set up an SQL database: tables with membership information, including timezone, and the disk to which to forward users from each timezone.

You might try posting this question on the MySQL newbie forum, just to see what kind of response you get.
www.mysql.com, click on Support. Scroll down to Community, and click on forum.

You may have to register in order to post.

T.Hsu · 01-08-2006, 02:00 AM

I'm totally ignorant on this topic, but it sounds like "geographic load balancing".

http://www.linuxjournal.com/article/5501

rblampain · 01-09-2006, 07:01 AM

Thank you for your replies. We're using flat files and have very little use for databases. The "geographic load balancing" looks like an overkill solution. We've got a bit of an idea about what to do but we thought somebody may have a better one, we'll just have to experiment a bit.