On 14 Jan 2014, at 10:32 pm, Andrey Rogovsky <a.rogov...@gmail.com> wrote:
> I understand it. So, no way change master better without cluster software > update? crm_resource is just creating (and removing) normal location constraints. no reason you couldn't write a script to create them instead. > > > > 2014/1/14 Andrey Groshev <gre...@yandex.ru> > > > 14.01.2014, 12:39, "Andrey Rogovsky" <a.rogov...@gmail.com>: >> I use Debian 7 and got: >> Reconnecting...root@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 <and...@beekhof.net> >> >> On 13 Jan 2014, at 8:32 pm, Andrey Rogovsky <a.rogov...@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...@lists.linux-ha.org >> > http://lists.linux-ha.org/mailman/listinfo/linux-ha >> > See also: http://linux-ha.org/ReportingProblems >> >> >> _______________________________________________ >> 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 >> , >> _______________________________________________ >> 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 >> > > _______________________________________________ > 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 > > > _______________________________________________ > 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
signature.asc
Description: Message signed with OpenPGP using GPGMail
_______________________________________________ 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
