[Pacemaker] [Linux-HA] Better way to change master in 3 node pgsql cluster
Andrey Rogovsky
a.rogovsky at gmail.com
Tue Jan 14 15:57:45 UTC 2014
Thanks a lot.
2014/1/14 Andrey Groshev <greenx at yandex.ru>
>
>
> 14.01.2014, 15:37, "Andrey Rogovsky" <a.rogovsky at gmail.com>:
>
> I understand it. So, no way change master better without cluster software
> update?
>
>
>
> You can send a node in standby (crm_stanbdy).
> All resources will move to another node (if available).
> Pgsql resource agent will promote postgresql on another node.
> Anyway ex Master you must resync.
>
>
>
>
>
>
> 2014/1/14 Andrey Groshev <greenx at yandex.ru>
>
>
>
> 14.01.2014, 12:39, "Andrey Rogovsky" <a.rogovsky at gmail.com>:
>
> I use Debian 7 and got:
> Reconnecting...root at a:~# crm_resource --resource msPostgresql --ban
> --master --host a.geocluster.e-autopay.com
> crm_resource: unrecognized option '--ban'
>
>
> No other way to move master?
>
>
>
> 2014/1/13 Andrew Beekhof <andrew at beekhof.net>
>
>
> On 13 Jan 2014, at 8:32 pm, Andrey Rogovsky <a.rogovsky at gmail.com> wrote:
>
> > Hi
> >
> > I have 3 node postgresql cluster.
> > It work well. But I have some trobule with change master.
> >
> > For now, if I need change master, I must:
> > 1) Stop PGSQL on each node and cluster service
> > 2) Start Setup new manual PGSQL replication
> > 3) Change attributes on each node for point to new master
> > 4) Stop PGSQL on each node
> > 5) Celanup resource and start cluster service
> >
> > It take a lot of time. Is it exist better way to change master?
> Newer versions support:
>
> crm_resource --resource msPostgresql --ban --master --host
> a.geocluster.e-autopay.com
>
> >
> >
> >
> > This is my cluster service status:
> > Node Attributes:
> > * Node a.geocluster.e-autopay.com:
> > + master-pgsql:0 : 1000
> > + pgsql-data-status : LATEST
> > + pgsql-master-baseline : 000000002F000090
> > + pgsql-status : PRI
> > * Node c.geocluster.e-autopay.com:
> > + master-pgsql:0 : 1000
> > + pgsql-data-status : SYNC
> > + pgsql-status : STOP
> > * Node b.geocluster.e-autopay.com:
> > + master-pgsql:0 : 1000
> > + pgsql-data-status : SYNC
> > + pgsql-status : STOP
> >
> > I was use http://clusterlabs.org/wiki/PgSQL_Replicated_Cluster for my 3
> > nodes cluster without hard stik.
> > Now I got strange situation all nodes stay slave:
> > ============
> > Last updated: Sat Dec 7 04:33:47 2013
> > Last change: Sat Dec 7 12:56:23 2013 via crmd on a
> > Stack: openais
> > Current DC: c - partition with quorum
> > Version: 1.1.7-ee0730e13d124c3d58f00016c3376a1de5323cff
>
>
> You use 1.1.7 version.
> Option "--ban" added in 1.1.9
> See: https://github.com/ClusterLabs/pacemaker/blob/master/ChangeLog
>
>
>
> > 5 Nodes configured, 3 expected votes
> > 4 Resources configured.
> > ============
> >
> > Online: [ a c b ]
> >
> > Master/Slave Set: msPostgresql [pgsql]
> > Slaves: [ a c b ]
> >
> > My config is:
> > node a \
> > attributes pgsql-data-status="DISCONNECT"
> > node b \
> > attributes pgsql-data-status="DISCONNECT"
> > node c \
> > attributes pgsql-data-status="DISCONNECT"
> > primitive pgsql ocf:heartbeat:pgsql \
> > params pgctl="/usr/lib/postgresql/9.3/bin/pg_ctl" psql="/usr/bin/psql"
> > pgdata="/var/lib/postgresql/9.3/main" start_opt="-p 5432" rep_mode="sync"
> > node_list="a b c" restore_command="cp
> /var/lib/postgresql/9.3/pg_archive/%f
> > %p" master_ip="192.168.10.200" restart_on_promote="true"
> > config="/etc/postgresql/9.3/main/postgresql.conf" \
> > op start interval="0s" timeout="60s" on-fail="restart" \
> > op monitor interval="4s" timeout="60s" on-fail="restart" \
> > op monitor interval="3s" role="Master" timeout="60s" on-fail="restart" \
> > op promote interval="0s" timeout="60s" on-fail="restart" \
> > op demote interval="0s" timeout="60s" on-fail="stop" \
> > op stop interval="0s" timeout="60s" on-fail="block" \
> > op notify interval="0s" timeout="60s"
> > primitive pgsql-master-ip ocf:heartbeat:IPaddr2 \
> > params ip="192.168.10.200" nic="peervpn0" \
> > op start interval="0s" timeout="60s" on-fail="restart" \
> > op monitor interval="10s" timeout="60s" on-fail="restart" \
> > op stop interval="0s" timeout="60s" on-fail="block"
> > group master pgsql-master-ip
> > ms msPostgresql pgsql \
> > meta master-max="1" master-node-max="1" clone-max="3" clone-node-max="1"
> > notify="true"
> > colocation set_ip inf: master msPostgresql:Master
> > order ip_down 0: msPostgresql:demote master:stop symmetrical=false
> > order ip_up 0: msPostgresql:promote master:start symmetrical=false
> > property $id="cib-bootstrap-options" \
> > dc-version="1.1.7-ee0730e13d124c3d58f00016c3376a1de5323cff" \
> > cluster-infrastructure="openais" \
> > expected-quorum-votes="3" \
> > no-quorum-policy="ignore" \
> > stonith-enabled="false" \
> > crmd-transition-delay="0" \
> > last-lrm-refresh="1386404222"
> > rsc_defaults $id="rsc-options" \
> > resource-stickiness="100" \
> > migration-threshold="1"
> > _______________________________________________
> > Linux-HA mailing list
> > Linux-HA at lists.linux-ha.org
> > http://lists.linux-ha.org/mailman/listinfo/linux-ha
> > See also: http://linux-ha.org/ReportingProblems
>
>
> _______________________________________________
> Pacemaker mailing list: Pacemaker at 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
>
> ,
>
> _______________________________________________
> Pacemaker mailing list: Pacemaker at 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
>
>
> _______________________________________________
> Pacemaker mailing list: Pacemaker at 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
>
> ,
>
> _______________________________________________
> Pacemaker mailing list: Pacemaker at 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
>
>
> _______________________________________________
> Pacemaker mailing list: Pacemaker at 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
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.clusterlabs.org/pipermail/pacemaker/attachments/20140114/d68b1899/attachment.htm>
More information about the Pacemaker
mailing list