From: Wei Weng <wweng@kencast.com>
To: Michael A Nachbaur <mike@nachbaur.com>
Cc: pgsql-sql@postgresql.org
Subject: Re: pgsql Replication Proxy (was Re: Replication for a
Date: Tue, 06 May 2003 15:10:02 -0400
Message-ID: <3EB8088A.5010205@kencast.com> (raw)
In-Reply-To: <200305061040.03364.mike@nachbaur.com>
References: <B51F0C636E578A4E832D3958690CD73E0130C42C@es04snlnt.sandia.gov>
<200305061040.03364.mike@nachbaur.com>
Michael:
1: It will probably need a messaging system that can properly
register/unregister a backend database system. a SIP like syntax comes
into mind. (or a XML message, for the ease of future expansion)
2: What do you mean by "per-database basis"? Database as the concept of
database schema? or seperate physical database server?
3: How does the proxy server know that a backend server failed in commit?
Wei
Michael A Nachbaur wrote:
>LOL! Depending on how much FUD I can throw at the guys higher up in the food
>chain at my office, I might be able to get some budget space to develop
>something like this. There are some significant technical hurdles I have to
>overcome, but I think it's doable. The analogy I came up with is SCSI RAID
>for databases. You can rip a database server out, and the overall system
>will still function...toss it back in, and updates will still happen. I
>would also like to be able to throw a fresh database in place and have it
>mirror the existing database servers in the background so you don't have to
>go through the complicated procedure of dumping/restoring the database
>servers by hand.
>
>Re: FIFO, yeah, I realized that after I sent the message.
>
>Does anyone have any ideas for me on this? I think it might make sense to use
>PostgreSQL as the storage mechanism for the proxy server, but that sort of
>defeats the purpose of having a replication system. Maybe spread can be used
>to distribute the messages to different servers, but I'm not too familiar
>with it.
>
>Also, one final note, I'm a Perl programmer, so anything I build will be
>written in that. If anyone has objections, let me know and maybe we could
>work together on something.
>
>
>
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: wweng@kencast.com, mike@nachbaur.com
Subject: Re: pgsql Replication Proxy (was Re: Replication for a
In-Reply-To: <3EB8088A.5010205@kencast.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox