<html>
<head>
<meta content="text/html; charset=ISO-8859-1"
http-equiv="Content-Type">
</head>
<body bgcolor="#FFFFFF" text="#000000">
Am 11.11.2014 13:34, schrieb Alexandre:
<blockquote
cite="mid:CAFWc+t8Rdk-FYuTPPGyaa3iFPs6KNbcHxmPuea8g8RY2Q=apYw@mail.gmail.com"
type="cite">
<p dir="ltr">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.</p>
<p dir="ltr">Corosync will still monitor sql resources on www
hosts and return rc 5 but this is expected and works.</p>
<div class="gmail_quote">Le 11 nov. 2014 13:22, "Hauke Homburg"
<<a moz-do-not-send="true"
href="mailto:hhomburg@w3-creative.de">hhomburg@w3-creative.de</a>>
a écrit :<br type="attribution">
<blockquote class="gmail_quote" style="margin:0 0 0
.8ex;border-left:1px #ccc solid;padding-left:1ex">Hello,<br>
<br>
I am installing a 6 Node pacemaker CLuster. 3 Nodes for
Apache, 3 Nodes for Postgres.<br>
<br>
My Cluster Config is<br>
<br>
node kvm-node1<br>
node sql-node1<br>
node sql-node2<br>
node sql-node3<br>
node www-node1<br>
node www-node2<br>
node www-node3<br>
primitive pri_kvm_ip ocf:heartbeat:IPaddr2 \<br>
params ip="10.0.6.41" cidr_netmask="255.255.255.0" \<br>
op monitor interval="10s" timeout="20s"<br>
primitive pri_sql_ip ocf:heartbeat:IPaddr2 \<br>
params ip="10.0.6.31" cidr_netmask="255.255.255.0" \<br>
op monitor interval="10s" timeout="20s"<br>
primitive pri_www_ip ocf:heartbeat:IPaddr2 \<br>
params ip="10.0.6.21" cidr_netmask="255.255.255.0" \<br>
op monitor interval="10s" timeout="20s"<br>
primitive res_apache ocf:heartbeat:apache \<br>
params configfile="/etc/apache2/apache2.conf" \<br>
op start interval="0" timeout="40" \<br>
op stop interval="0" timeout="60" \<br>
op monitor interval="60" timeout="120" start-delay="0"
\<br>
meta target-role="Started"<br>
primitive res_pgsql ocf:heartbeat:pgsql \<br>
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" \<br>
op start interval="0" timeout="120s" \<br>
op stop interval="0" timeout="120s" \<br>
op monitor interval="30s" timeout="30s" depth="0"<br>
location loc_kvm_ip_node1 pri_kvm_ip 10001: kvm-node1<br>
location loc_sql_ip_node1 pri_sql_ip inf: sql-node1<br>
location loc_sql_ip_node2 pri_sql_ip inf: sql-node2<br>
location loc_sql_ip_node3 pri_sql_ip inf: sql-node3<br>
location loc_sql_srv_node1 res_pgsql inf: sql-node1<br>
location loc_sql_srv_node2 res_pgsql inf: sql-node2<br>
location loc_sql_srv_node3 res_pgsql inf: sql-node3<br>
location loc_www_ip_node1 pri_www_ip inf: www-node1<br>
location loc_www_ip_node2 pri_www_ip inf: www-node2<br>
location loc_www_ip_node3 pri_www_ip inf: www-node3<br>
location loc_www_srv_node1 res_apache inf: www-node1<br>
location loc_www_srv_node2 res_apache inf: www-node2<br>
location loc_www_srv_node3 res_apache inf: www-node3<br>
property $id="cib-bootstrap-options" \<br>
dc-version="1.1.7-ee0730e13d124c3d58f00016c3376a1de5323cff"
\<br>
cluster-infrastructurFailed actions:<br>
<br>
Why do i see in crm_mon the following output?<br>
<br>
res_pgsql_start_0 (node=www-node1, call=16, rc=5,
status=complete): not installed<br>
res_pgsql_start_0 (node=www-node2, call=13, rc=5,
status=complete): not installed<br>
pri_www_ip_monitor_10000 (node=www-node3, call=22, rc=7,
status=complete): not running<br>
res_pgsql_start_0 (node=www-node3, call=13, rc=5,
status=complete): not installed<br>
res_apache_start_0 (node=sql-node2, call=18, rc=5,
status=complete): not installed<br>
res_pgsql_start_0 (node=sql-node2, call=12, rc=5,
status=complete): not installed<br>
res_apache_start_0 (node=sql-node3, call=12, rc=5,
status=complete): not installed<br>
res_pgsql_start_0 (node=sql-node3, call=10, rc=5,
status=complete): not installed<br>
res_apache_start_0 (node=kvm-node1, call=12, rc=5,
status=complete): not installed<br>
res_pgsql_start_0 (node=kvm-node1, call=20, rc=5,
status=complete): not installede="openais" \<br>
expected-quorum-votes="7" \<br>
stonith-enabled="false"<br>
<br>
<br>
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?<br>
<br>
Thank for your Help<br>
<br>
greetings<br>
<br>
Hauke<br>
<br>
_______________________________________________<br>
Pacemaker mailing list: <a moz-do-not-send="true"
href="mailto:Pacemaker@oss.clusterlabs.org" target="_blank">Pacemaker@oss.clusterlabs.org</a><br>
<a moz-do-not-send="true"
href="http://oss.clusterlabs.org/mailman/listinfo/pacemaker"
target="_blank">http://oss.clusterlabs.org/mailman/listinfo/pacemaker</a><br>
<br>
Project Home: <a moz-do-not-send="true"
href="http://www.clusterlabs.org" target="_blank">http://www.clusterlabs.org</a><br>
Getting started: <a moz-do-not-send="true"
href="http://www.clusterlabs.org/doc/Cluster_from_Scratch.pdf"
target="_blank">http://www.clusterlabs.org/doc/Cluster_from_Scratch.pdf</a><br>
Bugs: <a moz-do-not-send="true"
href="http://bugs.clusterlabs.org" target="_blank">http://bugs.clusterlabs.org</a><br>
</blockquote>
</div>
<br>
<fieldset class="mimeAttachmentHeader"></fieldset>
<br>
<pre wrap="">_______________________________________________
Pacemaker mailing list: <a class="moz-txt-link-abbreviated" href="mailto:Pacemaker@oss.clusterlabs.org">Pacemaker@oss.clusterlabs.org</a>
<a class="moz-txt-link-freetext" href="http://oss.clusterlabs.org/mailman/listinfo/pacemaker">http://oss.clusterlabs.org/mailman/listinfo/pacemaker</a>
Project Home: <a class="moz-txt-link-freetext" href="http://www.clusterlabs.org">http://www.clusterlabs.org</a>
Getting started: <a class="moz-txt-link-freetext" href="http://www.clusterlabs.org/doc/Cluster_from_Scratch.pdf">http://www.clusterlabs.org/doc/Cluster_from_Scratch.pdf</a>
Bugs: <a class="moz-txt-link-freetext" href="http://bugs.clusterlabs.org">http://bugs.clusterlabs.org</a>
</pre>
</blockquote>
Hello Alexandre,<br>
<br>
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?<br>
<br>
Greetings<br>
<br>
Hauke<br>
</body>
</html>