pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedPg 9.1 master-slave replication
5+ messages / 4 participants
[nested] [flat]
* Pg 9.1 master-slave replication
@ 2013-02-20 15:48 Viktor <viktor@okservers.eu>
0 siblings, 1 reply; 5+ messages in thread
From: Viktor @ 2013-02-20 15:48 UTC (permalink / raw)
To: pgsql-admin
Hello,
Could explain somebody what will happen, if the slave server fails ?
Will it affect the master functionality/availability ?
I'm using simple master-slave replication with 2 servers.
--
Best regards
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: Pg 9.1 master-slave replication
@ 2013-02-20 15:56 Gilberto Castillo <gilberto.castillo@etecsa.cu>
parent: Viktor <viktor@okservers.eu>
0 siblings, 1 reply; 5+ messages in thread
From: Gilberto Castillo @ 2013-02-20 15:56 UTC (permalink / raw)
To: Viktor <viktor@okservers.eu>; +Cc: pgsql-admin
>
> Hello,
>
> Could explain somebody what will happen, if the slave server fails ?
> Will it affect the master functionality/availability ?
nothing!!! the Master continuo work. ;-)))
> I'm using simple master-slave replication with 2 servers.
>
>
> --
> Best regards
>
>
> --
> Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-admin---
> This message was processed by Kaspersky Mail Gateway 5.6.28/RELEASE
> running at host imx2.etecsa.cu
> Visit our web-site: <http://www.kaspersky.com;, <http://www.viruslist.com;
>
Saludos,
Gilberto Castillo
La Habana, Cuba
---
This message was processed by Kaspersky Mail Gateway 5.6.28/RELEASE running at host imx3.etecsa.cu
Visit our web-site: <http://www.kaspersky.com;, <http://www.viruslist.com;
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: Pg 9.1 master-slave replication
@ 2013-02-20 16:04 Viktor <viktor@okservers.eu>
parent: Gilberto Castillo <gilberto.castillo@etecsa.cu>
0 siblings, 1 reply; 5+ messages in thread
From: Viktor @ 2013-02-20 16:04 UTC (permalink / raw)
To: gilberto.castillo@etecsa.cu; +Cc: pgsql-admin
Ook, thanks =)
On 2/20/2013 5:56 PM, Gilberto Castillo wrote:
>
>> Hello,
>>
>> Could explain somebody what will happen, if the slave server fails ?
>> Will it affect the master functionality/availability ?
> nothing!!! the Master continuo work. ;-)))
>
>> I'm using simple master-slave replication with 2 servers.
>>
>>
>> --
>> Best regards
>>
>>
>> --
>> Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
>> To make changes to your subscription:
>> http://www.postgresql.org/mailpref/pgsql-admin---
>> This message was processed by Kaspersky Mail Gateway 5.6.28/RELEASE
>> running at host imx2.etecsa.cu
>> Visit our web-site: <http://www.kaspersky.com;, <http://www.viruslist.com;
>>
>
> Saludos,
> Gilberto Castillo
> La Habana, Cuba
>
>
> ---
> This message was processed by Kaspersky Mail Gateway 5.6.28/RELEASE running at host imx3.etecsa.cu
> Visit our web-site: <http://www.kaspersky.com;, <http://www.viruslist.com;
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: Pg 9.1 master-slave replication
@ 2013-02-21 01:40 Prashanth Ranjalkar <prashant.ranjalkar@gmail.com>
parent: Viktor <viktor@okservers.eu>
0 siblings, 1 reply; 5+ messages in thread
From: Prashanth Ranjalkar @ 2013-02-21 01:40 UTC (permalink / raw)
To: Viktor <viktor@okservers.eu>; +Cc: gilberto.castillo@etecsa.cu; pgsql-admin
It depends on the type of replication is used.
If it's a slony replication then master continues to work and will catch up
when slave is available.
However if the Streaming replication is used, Matser continues to work if
slave is unavailable till it finds space for WAL archiving on master,
depends on the archieving strategy that implemented while configuring
replication. WAL's keep accumulating on the master server till it applies
to Slave server after it is available. As long as it find space on master,
there is no impact but once it fills all the space, master may go down.
**
*Thanks & Regards,*
*** *
*Prashanth Ranjalkar*
*Database Consultant & Architect*
*www.postgresdba.net*
On Wed, Feb 20, 2013 at 9:34 PM, Viktor <viktor@okservers.eu> wrote:
> Ook, thanks =)
>
>
> On 2/20/2013 5:56 PM, Gilberto Castillo wrote:
>
> Hello,
>
> Could explain somebody what will happen, if the slave server fails ?
> Will it affect the master functionality/availability ?
>
> nothing!!! the Master continuo work. ;-)))
>
>
> I'm using simple master-slave replication with 2 servers.
>
>
> --
> Best regards
>
>
> --
> Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
> To make changes to your subscription:http://www.postgresql.org/mailpref/pgsql-admin---
> This message was processed by Kaspersky Mail Gateway 5.6.28/RELEASE
> running at host imx2.etecsa.cu
> Visit our web-site: <http://www.kaspersky.com; <http://www.kaspersky.com;, <http://www.viruslist.com; <http://www.viruslist.com;
>
> Saludos,
> Gilberto Castillo
> La Habana, Cuba
>
>
>
> ---
> This message was processed by Kaspersky Mail Gateway 5.6.28/RELEASE running at host imx3.etecsa.cu
>
> Visit our web-site: <http://www.kaspersky.com; <http://www.kaspersky.com;, <http://www.viruslist.com; <http://www.viruslist.com;
>
>
>
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: Pg 9.1 master-slave replication
@ 2013-02-21 18:23 Kevin Grittner <kgrittn@ymail.com>
parent: Prashanth Ranjalkar <prashant.ranjalkar@gmail.com>
0 siblings, 0 replies; 5+ messages in thread
From: Kevin Grittner @ 2013-02-21 18:23 UTC (permalink / raw)
To: Prashanth Ranjalkar <prashant.ranjalkar@gmail.com>; Viktor <viktor@okservers.eu>; +Cc: gilberto.castillo@etecsa.cu <gilberto.castillo@etecsa.cu>; pgsql-admin
Prashanth Ranjalkar <prashant.ranjalkar@gmail.com> wrote:
>> Hello, Could explain somebody what will happen, if the slave
> It depends on the type of replication is used.
>
> If it's a slony replication then master continues to work and
> will catch up when slave is available.
>
> However if the Streaming replication is used, [...] once it fills
> all the space, master may go down.
That strikes me a false distinction -- Slony also stores data to be
replicated until the slave becomes available. Either way you can
control where that is stored, and you need to watch out for space
problems on an extended outage of a replica.
An issue I don't think I've seen mentioned is that if you use
synchronous replication you are telling PostgreSQL not to return an
indication of success for a data-modifying transaction until the
work of that transaction has been persisted on at least one
replica. To avoid stalls on the master, you may want to define
multiple synchronous replicas, so that when one goes down you keep
running without DBA intervention.
--
Kevin Grittner
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
^ permalink raw reply [nested|flat] 5+ messages in thread
end of thread, other threads:[~2013-02-21 18:23 UTC | newest]
Thread overview: 5+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2013-02-20 15:48 Pg 9.1 master-slave replication Viktor <viktor@okservers.eu>
2013-02-20 15:56 ` Gilberto Castillo <gilberto.castillo@etecsa.cu>
2013-02-20 16:04 ` Viktor <viktor@okservers.eu>
2013-02-21 01:40 ` Prashanth Ranjalkar <prashant.ranjalkar@gmail.com>
2013-02-21 18:23 ` Kevin Grittner <kgrittn@ymail.com>
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