Skip site navigation (1) Skip section navigation (2)

Standalone synchronous master

From: Rajeev rastogi <rajeev(dot)rastogi(at)huawei(dot)com>
To: "pgsql-hackers(at)postgresql(dot)org" <pgsql-hackers(at)postgresql(dot)org>
Subject: Standalone synchronous master
Date: 2013-11-13 13:09:19
Message-ID: BF2827DCCE55594C8D7A8F7FFD3AB7713DD9A622@SZXEML508-MBX.china.huawei.com (view raw or flat)
Thread:
Lists: pgsql-hackers
This patch implements the following TODO item:

Add a new "eager" synchronous mode that starts out synchronous but reverts to asynchronous after a failure timeout period
This would require some type of command to be executed to alert administrators of this change.
http://archives.postgresql.org/pgsql-hackers/2011-12/msg01224.php

This patch implementation is in the same line as it was given in the earlier thread.
Some Of the additional important changes are:

1.       Have added two GUC variable to take commands from user to be executed

a.       Master_to_standalone_cmd: To be executed before master switches to standalone mode.

b.      Master_to_sync_cmd: To be executed before master switches from sync mode to standalone mode.

2.       Master mode switch will happen only if the corresponding command executed successfully.

3.       Taken care of replication timeout to decide whether synchronous standby has gone down. i.e. only after expiry of

wal_sender_timeout, the master will switch from sync mode to standalone mode.

Please provide your opinion or any other expectation out of this patch.

I will add the same to November commitFest.

Thanks and Regards,
Kumar Rajeev Rastogi

Attachment: replication_new_modeV1.patch
Description: application/octet-stream (14.2 KB)

Responses

pgsql-hackers by date

Next:From: Peter EisentrautDate: 2013-11-13 13:23:44
Subject: Re: The number of character limitation of custom script on pgbench
Previous:From: Steve SingerDate: 2013-11-13 12:44:28
Subject: Re: logical changeset generation v6.5

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group