Re: "Too far out of the mainstream"

From: Achilleas Mantzios <achill(at)smadev(dot)internal(dot)net>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: "Too far out of the mainstream"
Date: 2012-09-05 14:01:45
Message-ID: 3124961.tmAbAIay6W@smadev.internal.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Τετ 05 Σεπτ 2012 23:44:08 Chris Angelico wrote:
> On Wed, Sep 5, 2012 at 7:40 PM, Achilleas Mantzios
> <achill(at)smadev(dot)internal(dot)net> wrote:
> > (single master, 80+ slaves in 80+ vessels in the 7 seas (80+ = 80 and growning))
>
> Cool!! How do your nodes communicate with each other? Is it an
> off-line resynchronization, or do you maintain long-range (satellite?)
> comms?

Hello,
our topology is star-like. The system is based on good ol' UUCP
running on top of either ISDN lines or (as of late) over TCP/IP.
It is asynchronous and off-line by design. Vessels connect to the central master server
and get all their data, receive replication updates, and also send their data
to the office (central master cerver).
UUCP does the management of the queues (for the unitiated, think of UUCP as
something like JMS or AMQP or even better like JMS (API)+AMQP (wire protocol))
The comms (ISDN and TCPIP) are all done of course over a satellite service
(very expensive, so compression and minimal data replication were/are and will be
major concern)
In the case of ISDN, the billing is by time, so clearly this had to fit in the off-line category.
In the case of TCPIP, the billing is by data size, but we use that under UUCP
just like the ISDN off-line asynchronous mode.

Vessels can operate without connection to the office, and vice versa.

>
> The system I'm setting up at work kinda pales in comparison to that.
> It's designed to scale "to infinity and beyond" (and that quote is
> kinda appropriate, since we run this all on Debian Linux), but at the
> moment, all the testing I've done has been on a half-dozen
> off-the-shelf Dell laptops. But the same applies; we want absolute
> guaranteed reliability, so we NEED a good database. Postgres all the
> way! (Plus we need bindings for C++, Pike, and PHP, and I'm a lot
> happier with Postgres than several other options in that area.)
>
> ChrisA
>
>
>
-
Achilleas Mantzios
IT DEPT

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Gauthier, Dave 2012-09-05 14:16:17 alter view, add/drop column
Previous Message damien clochard 2012-09-05 13:46:51 pgBadger 2.0 released