Re: website design

From: Francisco Reyes <lists(at)natserv(dot)com>
To: Jeff MacDonald <jeff(at)tsunamicreek(dot)com>
Cc: "Marc G(dot) Fournier" <scrappy(at)hub(dot)org>, Vince Vielhaber <vev(at)michvhf(dot)com>, <pgsql-general(at)postgresql(dot)org>
Subject: Re: website design
Date: 2002-06-23 16:51:13
Message-ID: 20020623124349.H62790-100000@zoraida.natserv.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


On Fri, 21 Jun 2002, Jeff MacDonald wrote:

> Eekk.. good point. back to the drawing board..
>
> Could we get a list of folks that would be willing to run a replicated
> server,
> make them into a "server pool" and get the mirrors to connect to them..
>
> I'm not sure if that would be a great solution, cause i'm not sure if most
> of the traffic is because of images, static code, or whatever would be
> coming
> from the database...
>
> I guess at the very least it's still good for discussion.

It would also be a great test case and learning experience of distributed
databases and replication.

I would be very interested in further discussion along these lines.

I don't know about the existing site but perhaps we could split the
mirrors on DB mirrors and www mirrors. The list visible to users will only
list www mirrors.

We could have two DNS entries. One fixed to the main DB site and another
to a round robbin list of DB mirrors. The web site programs could try to
connect to the round robbin DBs first and if that fails then go to the
main site.

We could even have configuration files so mirror sites could
perhaps specify a preferred DB mirror and then the site would try the
preferred first, then the round robbin and then the primary site.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message David Ford 2002-06-23 16:57:59 Re: Optimizing suggestions
Previous Message Tom Lane 2002-06-23 16:48:11 Re: SQL server application porting headache