Re: [GENERAL] Understanding streaming replication

2012-11-14 Thread Devrim GÜNDÜZ
Hi, On Tue, 2012-11-13 at 09:40 +0100, Albe Laurenz wrote: > > The only thing I have seen is RedHat's Cluster Suite, which > is commercial. Depends. It is open source, and all components are also available in CentOS and Scientific Linux, and there are companies out there who support clusters

Re: [GENERAL] Understanding streaming replication

2012-11-14 Thread Shaun Thomas
On 11/13/2012 02:40 AM, Albe Laurenz wrote: The only thing I have seen is RedHat's Cluster Suite, which is commercial. I would recommend to have at least three nodes though, because the two node cluster we had was subject to spurious failovers on short quorum disk hiccups. There's also the Pa

Re: [GENERAL] Understanding streaming replication

2012-11-14 Thread Albe Laurenz
Philippe Amelant wrote: >>> So i was thinking it was just a reconnect to the sender (and I can see >>> the standby trying to reconnect in the log) >> Hmmm. I think I was too quick when I said no. >> >> If you ship the WAL archives including the "history" file to the >> standby, then the standby s

Re: [GENERAL] Understanding streaming replication

2012-11-13 Thread Philippe Amelant
Le 13/11/2012 14:57, Albe Laurenz a écrit : Philippe Amelant wrote: So i was thinking it was just a reconnect to the sender (and I can see the standby trying to reconnect in the log) Hmmm. I think I was too quick when I said no. If you ship the WAL archives including the "history" file to t

Re: [GENERAL] Understanding streaming replication

2012-11-13 Thread Albe Laurenz
Philippe Amelant wrote: >>> I'm setting up a 3 nodes cluster and after some tests >>> I just discover that the cascading slave does not recover. >> Right, switching timeline over streaming replication >> is not supported yet. There's a patch by Heikki in >> the pipeline for this, so it will proba

Re: [GENERAL] Understanding streaming replication

2012-11-13 Thread Philippe Amelant
Hello, Thank for all this informations Le 13/11/2012 09:31, Albe Laurenz a écrit : Philippe Amelant wrote: I'm setting up a 3 nodes cluster and after some tests I just discover that the cascading slave does not recover. Right, switching timeline over streaming replication is not supported yet.

Re: [GENERAL] Understanding streaming replication

2012-11-13 Thread Albe Laurenz
Pawel Veselov wrote: >> From your later comments, it's also apparent that these archived WALs will >> be useless after >> failover (for the purpose of recovery), so there is no reason to send them >> to all the nodes after all. > > I obviously lost it here. The archives do need to be synchronize

Re: [GENERAL] Understanding streaming replication

2012-11-13 Thread Albe Laurenz
Pawel Veselov wrote: >>> QUESTION: If multiple pgpools are running, and if there are no network >>> problems, >>> and configuration >>> files are identical, is there any guarantee that the same stand-by node >>> will be selected for >>> promotion? Concern here is that with configuration of (M-SB0

Re: [GENERAL] Understanding streaming replication

2012-11-13 Thread Albe Laurenz
Philippe Amelant wrote: > I'm setting up a 3 nodes cluster and after some tests > I just discover that the cascading slave does not recover. Right, switching timeline over streaming replication is not supported yet. There's a patch by Heikki in the pipeline for this, so it will probably work in 9

Re: [GENERAL] Understanding streaming replication

2012-11-12 Thread Pawel Veselov
On Mon, Nov 12, 2012 at 10:11 AM, Pawel Veselov wrote: > > On Mon, Nov 12, 2012 at 1:36 AM, Albe Laurenz wrote: > >> I'll try to answer the questions I can. >> > > Thank you! > > >> Pawel Veselov wrote: >> > I've been struggling with understanding all the necessary pieces for >> streaming replicat

Re: [GENERAL] Understanding streaming replication

2012-11-12 Thread Pawel Veselov
On Mon, Nov 12, 2012 at 1:36 AM, Albe Laurenz wrote: > I'll try to answer the questions I can. > Thank you! > Pawel Veselov wrote: > > I've been struggling with understanding all the necessary pieces for > streaming replication. So I put > > down the pieces as I did understand them, and would a

Re: [GENERAL] Understanding streaming replication

2012-11-12 Thread Philippe Amelant
Hello all, I read this thread with interest but I still have some questions about cascading replication as you describe it. Le 12/11/2012 10:36, Albe Laurenz a écrit : I'll try to answer the questions I can. 3. Recovery. That part is a bit confusing. The majority of the documentation says th

Re: [GENERAL] Understanding streaming replication

2012-11-12 Thread Albe Laurenz
I'll try to answer the questions I can. Pawel Veselov wrote: > I've been struggling with understanding all the necessary pieces for > streaming replication. So I put > down the pieces as I did understand them, and would appreciate if you guys > could point out any of the > stuff I understood or

[GENERAL] Understanding streaming replication

2012-11-09 Thread Pawel Veselov
Hi. I've been struggling with understanding all the necessary pieces for streaming replication. So I put down the pieces as I did understand them, and would appreciate if you guys could point out any of the stuff I understood or have done wrong. The set up is pgpool + streaming replication + hot