Re: pgsql Replication Proxy (was Re: Replication for a

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.
>
>
>