Hi Richard 2013/11/1 Richard Colley <rcol...@cardaccess.com.au>: > I have just setup a postgres 9.3 cluster using the pgsql ra. It's all > working now (despite much hair pulling to start with :). > > I would like to extend this to multiple sites. > > I've decided not to try and have a single cluster across the WAN. Instead, > I have 2 independent clusters. > > I thought to use a ticket to transition a cluster between the "active" & > "passive" state. Creating the ticket & creating a ticket constraint was > easy enough. > > But now I need to do something with each site's cluster when this change > occurs. In particular, I need to make sure all postgres instances in the > passive site are in slave mode and replicate from the vip of the promoted > site. The active site will just use the standard pgsql RA behaviour. > > Has anyone done anything like this before?
This ? https://github.com/t-matsuo/resource-agents/wiki/Resource-agent-for-postgresql-9.2-for-disaster(split)-site You can use rep_mode="slave". > If not, I might try and update the pgsql ra with this capability. Any > advice? I note that the mysql ra has this capability, so I might refer to > it's implementation. > > Thanks, > Richard > > > _______________________________________________ > Pacemaker mailing list: Pacemaker@oss.clusterlabs.org > http://oss.clusterlabs.org/mailman/listinfo/pacemaker > > Project Home: http://www.clusterlabs.org > Getting started: http://www.clusterlabs.org/doc/Cluster_from_Scratch.pdf > Bugs: http://bugs.clusterlabs.org > Thanks, Takatoshi MATSUO _______________________________________________ Pacemaker mailing list: Pacemaker@oss.clusterlabs.org http://oss.clusterlabs.org/mailman/listinfo/pacemaker Project Home: http://www.clusterlabs.org Getting started: http://www.clusterlabs.org/doc/Cluster_from_Scratch.pdf Bugs: http://bugs.clusterlabs.org
