Am 11.11.2014 16:25, schrieb Andrei Borzenkov:
В Tue, 11 Nov 2014 16:19:56 +0100
Hauke Homburg<hhomb...@w3-creative.de>  пишет:

Am 11.11.2014 13:34, schrieb Alexandre:
You should use an opt out cluster. Set the cluster option
symmetrical=false. This will tell corosync not to place a resource
anywhere on the cluster, unless a location rule explicitly tell the
cluster where it should run.

Corosync will still monitor sql resources on www hosts and return rc 5
but this is expected and works.

Le 11 nov. 2014 13:22, "Hauke Homburg"<hhomb...@w3-creative.de
<mailto:hhomb...@w3-creative.de>>  a écrit :

     Hello,

     I am installing a 6 Node pacemaker CLuster. 3 Nodes for Apache, 3
     Nodes for Postgres.

     My Cluster Config is

     node kvm-node1
     node sql-node1
     node sql-node2
     node sql-node3
     node www-node1
     node www-node2
     node www-node3
     primitive pri_kvm_ip ocf:heartbeat:IPaddr2 \
             params ip="10.0.6.41" cidr_netmask="255.255.255.0" \
             op monitor interval="10s" timeout="20s"
     primitive pri_sql_ip ocf:heartbeat:IPaddr2 \
             params ip="10.0.6.31" cidr_netmask="255.255.255.0" \
             op monitor interval="10s" timeout="20s"
     primitive pri_www_ip ocf:heartbeat:IPaddr2 \
             params ip="10.0.6.21" cidr_netmask="255.255.255.0" \
             op monitor interval="10s" timeout="20s"
     primitive res_apache ocf:heartbeat:apache \
             params configfile="/etc/apache2/apache2.conf" \
             op start interval="0" timeout="40" \
             op stop interval="0" timeout="60" \
             op monitor interval="60" timeout="120" start-delay="0" \
             meta target-role="Started"
     primitive res_pgsql ocf:heartbeat:pgsql \
             params pgctl="/usr/lib/postgresql/9.1/bin/pg_ctl"
     psql="/usr/bin/psql" start_opt=""
     pgdata="/var/lib/postgresql/9.1/main"
     config="/etc/postgresql/9.1/main/postgresql.conf" pgdba="postgres" \
             op start interval="0" timeout="120s" \
             op stop interval="0" timeout="120s" \
             op monitor interval="30s" timeout="30s" depth="0"
     location loc_kvm_ip_node1 pri_kvm_ip 10001: kvm-node1
     location loc_sql_ip_node1 pri_sql_ip inf: sql-node1
     location loc_sql_ip_node2 pri_sql_ip inf: sql-node2
     location loc_sql_ip_node3 pri_sql_ip inf: sql-node3
     location loc_sql_srv_node1 res_pgsql inf: sql-node1
     location loc_sql_srv_node2 res_pgsql inf: sql-node2
     location loc_sql_srv_node3 res_pgsql inf: sql-node3
     location loc_www_ip_node1 pri_www_ip inf: www-node1
     location loc_www_ip_node2 pri_www_ip inf: www-node2
     location loc_www_ip_node3 pri_www_ip inf: www-node3
     location loc_www_srv_node1 res_apache inf: www-node1
     location loc_www_srv_node2 res_apache inf: www-node2
     location loc_www_srv_node3 res_apache inf: www-node3
     property $id="cib-bootstrap-options" \
             dc-version="1.1.7-ee0730e13d124c3d58f00016c3376a1de5323cff" \
             cluster-infrastructurFailed actions:

     Why do i see in crm_mon the following output?

         res_pgsql_start_0 (node=www-node1, call=16, rc=5,
     status=complete): not installed
         res_pgsql_start_0 (node=www-node2, call=13, rc=5,
     status=complete): not installed
         pri_www_ip_monitor_10000 (node=www-node3, call=22, rc=7,
     status=complete): not running
         res_pgsql_start_0 (node=www-node3, call=13, rc=5,
     status=complete): not installed
         res_apache_start_0 (node=sql-node2, call=18, rc=5,
     status=complete): not installed
         res_pgsql_start_0 (node=sql-node2, call=12, rc=5,
     status=complete): not installed
         res_apache_start_0 (node=sql-node3, call=12, rc=5,
     status=complete): not installed
         res_pgsql_start_0 (node=sql-node3, call=10, rc=5,
     status=complete): not installed
         res_apache_start_0 (node=kvm-node1, call=12, rc=5,
     status=complete): not installed
         res_pgsql_start_0 (node=kvm-node1, call=20, rc=5,
     status=complete): not installede="openais" \
             expected-quorum-votes="7" \
             stonith-enabled="false"


     I set the infinity for pgsql on all 3 sql nodes, but not! on the
     www nodes. Why tries Pacemaker to start the Postgres SQL Server on
     the www Node? In example?

     Thank for your Help

     greetings

     Hauke

     _______________________________________________
     Pacemaker mailing list: Pacemaker@oss.clusterlabs.org
     <mailto: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
Hello Alexandre,

Why can't i set the infinity for the SQL servernodes to start the SQL
Daemon only on the sql-nodes? I thought that has to be all?

http://clusterlabs.org/doc/en-US/Pacemaker/1.0/html/Pacemaker_Explained/s-resource-location.html

Greetings

Hauke
You are right.

The Page says score: Values of +/- |INFINITY| change "can" to "must".

I have set location loc_sql_srv_node1 res_pgsql inf: sql-node1. But not to www-node1. So i am wondering.

Greetings
_______________________________________________
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

Reply via email to