<html>
<head>
<meta content="text/html; charset=ISO-8859-1"
http-equiv="Content-Type">
</head>
<body text="#000000" bgcolor="#FFFFFF">
Hi <br>
I try to configure simple two nodes(Master/Slave)
MYSQL/DRBD/PACEMAKER with MYSQL replication but it does not work.
Everytime I start mysql(M/S) RA,it won't start with these error
below. PLease help if you see if I am doing anything wrong (
attached crm configure show). thank you. <br>
<br>
( Failed actions:<br>
p_mysql:0_monitor_0 (node=mysqldrbd02, call=501, rc=5,
status=complete): not installed<br>
p_mysql:1_monitor_0 (node=mysqldrbd01, call=251, rc=5,
status=complete): not installed<br>
<br>
Reconnecting...[root@mysqldrbd01 etc]# tail -f /var/log/messages<br>
Nov 7 14:33:13 mysqldrbd01 crmd: [8610]: info: run_graph:
====================================================<br>
Nov 7 14:33:13 mysqldrbd01 crmd: [8610]: notice: run_graph:
Transition 795 (Complete=6, Pending=0, Fired=0, Skipped=0,
Incomplete=0, Source=/var/lib/pengine/pe-input-895.bz2): Complete<br>
Nov 7 14:33:13 mysqldrbd01 crmd: [8610]: info: te_graph_trigger:
Transition 795 is now complete<br>
Nov 7 14:33:13 mysqldrbd01 crmd: [8610]: info: notify_crmd:
Transition 795 status: done - <null><br>
Nov 7 14:33:13 mysqldrbd01 crmd: [8610]: info: do_state_transition:
State transition S_TRANSITION_ENGINE -> S_IDLE [
input=I_TE_SUCCESS cause=C_FSA_INTERNAL origin=notify_crmd ]<br>
Nov 7 14:33:13 mysqldrbd01 crmd: [8610]: info: do_state_transition:
Starting PEngine Recheck Timer<br>
Nov 7 14:33:13 mysqldrbd01 cibadmin: [28166]: info: Invoked:
/usr/sbin/cibadmin -Ql <br>
Nov 7 14:33:13 mysqldrbd01 cibadmin: [28171]: info: Invoked:
/usr/sbin/cibadmin -Ql <br>
Nov 7 14:33:17 mysqldrbd01 lrmd: [8607]: info: RA output:
(FAILOVER-ADDR:start:stderr) ARPING 192.168.1.160 from 192.168.1.160
eth1 Sent 5 probes (5 broadcast(s)) Received 0 response(s) <br>
Nov 7 14:33:33 mysqldrbd01 cibadmin: [28513]: info: Invoked:
cibadmin -Ql <br>
Nov 7 14:34:08 mysqldrbd01 cibadmin: [28974]: info: Invoked:
/usr/sbin/cibadmin -Ql <br>
Nov 7 14:34:08 mysqldrbd01 crm_resource: [28975]: info: Invoked:
/usr/sbin/crm_resource --meta -t primitive -r p_mysql -p target-role
-v started <br>
Nov 7 14:34:08 mysqldrbd01 crm_resource: [28986]: info: Invoked:
/usr/sbin/crm_resource --meta -t primitive -r p_mysql -p target-role
-v started <br>
Nov 7 14:34:08 mysqldrbd01 cib: [8606]: info: log_data_element:
cib:diff: - <cib admin_epoch="0" epoch="244" num_updates="24"
><br>
Nov 7 14:34:08 mysqldrbd01 cib: [8606]: info: log_data_element:
cib:diff: - <configuration ><br>
Nov 7 14:34:08 mysqldrbd01 cib: [8606]: info: log_data_element:
cib:diff: - <resources ><br>
Nov 7 14:34:08 mysqldrbd01 cib: [8606]: info: log_data_element:
cib:diff: - <master id="ms_mysql" ><br>
Nov 7 14:34:08 mysqldrbd01 cib: [8606]: info: log_data_element:
cib:diff: - <primitive id="p_mysql" ><br>
Nov 7 14:34:08 mysqldrbd01 cib: [8606]: info: log_data_element:
cib:diff: - <meta_attributes
id="p_mysql-meta_attributes" ><br>
Nov 7 14:34:08 mysqldrbd01 cib: [8606]: info: log_data_element:
cib:diff: - <nvpair value="stopped"
id="p_mysql-meta_attributes-target-role" /><br>
Nov 7 14:34:08 mysqldrbd01 cib: [8606]: info: log_data_element:
cib:diff: - </meta_attributes><br>
Nov 7 14:34:08 mysqldrbd01 cib: [8606]: info: log_data_element:
cib:diff: - </primitive><br>
Nov 7 14:34:08 mysqldrbd01 cib: [8606]: info: log_data_element:
cib:diff: - </master><br>
Nov 7 14:34:08 mysqldrbd01 cib: [8606]: info: log_data_element:
cib:diff: - </resources><br>
Nov 7 14:34:08 mysqldrbd01 cib: [8606]: info: log_data_element:
cib:diff: - </configuration><br>
Nov 7 14:34:08 mysqldrbd01 crmd: [8610]: info:
abort_transition_graph: need_abort:59 - Triggered transition abort
(complete=1) : Non-status change<br>
Nov 7 14:34:08 mysqldrbd01 cib: [8606]: info: log_data_element:
cib:diff: - </cib><br>
Nov 7 14:34:08 mysqldrbd01 crmd: [8610]: info: need_abort: Aborting
on change to admin_epoch<br>
Nov 7 14:34:08 mysqldrbd01 cib: [8606]: info: log_data_element:
cib:diff: + <cib admin_epoch="0" epoch="245" num_updates="1" ><br>
Nov 7 14:34:08 mysqldrbd01 crmd: [8610]: info: do_state_transition:
State transition S_IDLE -> S_POLICY_ENGINE [ input=I_PE_CALC
cause=C_FSA_INTERNAL origin=abort_transition_graph ]<br>
Nov 7 14:34:08 mysqldrbd01 cib: [8606]: info: log_data_element:
cib:diff: + <configuration ><br>
Nov 7 14:34:08 mysqldrbd01 crmd: [8610]: info: do_state_transition:
All 2 cluster nodes are eligible to run resources.<br>
Nov 7 14:34:08 mysqldrbd01 cib: [8606]: info: log_data_element:
cib:diff: + <resources ><br>
Nov 7 14:34:08 mysqldrbd01 crmd: [8610]: info: do_pe_invoke: Query
1487: Requesting the current CIB: S_POLICY_ENGINE<br>
Nov 7 14:34:08 mysqldrbd01 cib: [8606]: info: log_data_element:
cib:diff: + <master id="ms_mysql" ><br>
Nov 7 14:34:08 mysqldrbd01 cib: [8606]: info: log_data_element:
cib:diff: + <primitive id="p_mysql" ><br>
Nov 7 14:34:08 mysqldrbd01 cib: [8606]: info: log_data_element:
cib:diff: + <meta_attributes
id="p_mysql-meta_attributes" ><br>
Nov 7 14:34:08 mysqldrbd01 cib: [8606]: info: log_data_element:
cib:diff: + <nvpair value="started"
id="p_mysql-meta_attributes-target-role" /><br>
Nov 7 14:34:08 mysqldrbd01 cib: [8606]: info: log_data_element:
cib:diff: + </meta_attributes><br>
Nov 7 14:34:08 mysqldrbd01 cib: [8606]: info: log_data_element:
cib:diff: + </primitive><br>
Nov 7 14:34:08 mysqldrbd01 cib: [8606]: info: log_data_element:
cib:diff: + </master><br>
Nov 7 14:34:08 mysqldrbd01 cib: [8606]: info: log_data_element:
cib:diff: + </resources><br>
Nov 7 14:34:08 mysqldrbd01 cib: [8606]: info: log_data_element:
cib:diff: + </configuration><br>
Nov 7 14:34:08 mysqldrbd01 cib: [8606]: info: log_data_element:
cib:diff: + </cib><br>
Nov 7 14:34:08 mysqldrbd01 cib: [8606]: info: cib_process_request:
Operation complete: op cib_modify for section resources
(origin=local/crm_resource/4, version=0.245.1): ok (rc=0)<br>
Nov 7 14:34:08 mysqldrbd01 crmd: [8610]: info:
do_pe_invoke_callback: Invoking the PE: query=1487,
ref=pe_calc-dc-1320698048-1740, seq=1368, quorate=1<br>
Nov 7 14:34:08 mysqldrbd01 cib: [28988]: info: write_cib_contents:
Archived previous version as /var/lib/heartbeat/crm/cib-29.raw<br>
Nov 7 14:34:08 mysqldrbd01 pengine: [8609]: notice: unpack_config:
On loss of CCM Quorum: Ignore<br>
Nov 7 14:34:08 mysqldrbd01 cib: [28988]: info: write_cib_contents:
Wrote version 0.245.0 of the CIB to disk (digest:
031a742e444fdb356e1d0657a8a1f516)<br>
Nov 7 14:34:08 mysqldrbd01 pengine: [8609]: info: unpack_config:
Node scores: 'red' = -INFINITY, 'yellow' = 0, 'green' = 0<br>
Nov 7 14:34:08 mysqldrbd01 cib: [28988]: info: retrieveCib: Reading
cluster configuration from: /var/lib/heartbeat/crm/cib.mHBHHN
(digest: /var/lib/heartbeat/crm/cib.66XEVP)<br>
Nov 7 14:34:08 mysqldrbd01 pengine: [8609]: info:
determine_online_status: Node mysqldrbd02 is online<br>
Nov 7 14:34:08 mysqldrbd01 pengine: [8609]: info:
determine_online_status: Node mysqldrbd01 is online<br>
Nov 7 14:34:08 mysqldrbd01 pengine: [8609]: notice: unpack_rsc_op:
Operation DRBD:0_monitor_0 found resource DRBD:0 active on
mysqldrbd02<br>
Nov 7 14:34:08 mysqldrbd01 pengine: [8609]: notice: unpack_rsc_op:
Hard error - p_mysql:0_monitor_0 failed with rc=5: Preventing
ms_mysql from re-starting on mysqldrbd02<br>
Nov 7 14:34:08 mysqldrbd01 pengine: [8609]: info: find_clone:
Internally renamed DRBD:0 on mysqldrbd01 to DRBD:1<br>
Nov 7 14:34:08 mysqldrbd01 pengine: [8609]: notice: unpack_rsc_op:
Operation DRBD:0_monitor_0 found resource DRBD:1 active in master
mode on mysqldrbd01<br>
Nov 7 14:34:08 mysqldrbd01 pengine: [8609]: notice: unpack_rsc_op:
Hard error - p_mysql:1_monitor_0 failed with rc=5: Preventing
ms_mysql from re-starting on mysqldrbd01<br>
Nov 7 14:34:08 mysqldrbd01 pengine: [8609]: notice: group_print:
Resource Group: AP-CLUST<br>
Nov 7 14:34:08 mysqldrbd01 pengine: [8609]: notice:
native_print: SRV-MOUNT (ocf::heartbeat:Filesystem):
Started mysqldrbd01<br>
Nov 7 14:34:08 mysqldrbd01 pengine: [8609]: notice:
native_print: FAILOVER-ADDR (ocf::heartbeat:IPaddr2):
Started mysqldrbd01<br>
Nov 7 14:34:08 mysqldrbd01 pengine: [8609]: notice: clone_print:
Master/Slave Set: DRBD-DATA<br>
Nov 7 14:34:08 mysqldrbd01 pengine: [8609]: notice:
short_print: Masters: [ mysqldrbd01 ]<br>
Nov 7 14:34:08 mysqldrbd01 pengine: [8609]: notice:
short_print: Slaves: [ mysqldrbd02 ]<br>
Nov 7 14:34:08 mysqldrbd01 pengine: [8609]: notice: clone_print:
Clone Set: PING-NET-CLONE<br>
Nov 7 14:34:08 mysqldrbd01 pengine: [8609]: notice:
short_print: Started: [ mysqldrbd02 mysqldrbd01 ]<br>
Nov 7 14:34:08 mysqldrbd01 pengine: [8609]: notice: clone_print:
Master/Slave Set: ms_mysql<br>
Nov 7 14:34:08 mysqldrbd01 pengine: [8609]: notice:
short_print: Stopped: [ p_mysql:0 p_mysql:1 ]<br>
Nov 7 14:34:08 mysqldrbd01 pengine: [8609]: info: master_color:
Promoting DRBD:1 (Master mysqldrbd01)<br>
Nov 7 14:34:08 mysqldrbd01 pengine: [8609]: info: master_color:
DRBD-DATA: Promoted 1 instances of a possible 1 to master<br>
Nov 7 14:34:08 mysqldrbd01 pengine: [8609]: info: master_color:
Promoting DRBD:1 (Master mysqldrbd01)<br>
Nov 7 14:34:08 mysqldrbd01 pengine: [8609]: info: master_color:
DRBD-DATA: Promoted 1 instances of a possible 1 to master<br>
Nov 7 14:34:08 mysqldrbd01 pengine: [8609]: info: native_color:
Resource p_mysql:0 cannot run anywhere<br>
Nov 7 14:34:08 mysqldrbd01 pengine: [8609]: info: native_color:
Resource p_mysql:1 cannot run anywhere<br>
Nov 7 14:34:08 mysqldrbd01 pengine: [8609]: info: master_color:
ms_mysql: Promoted 0 instances of a possible 1 to master<br>
Nov 7 14:34:08 mysqldrbd01 pengine: [8609]: notice: LogActions:
Leave resource SRV-MOUNT (Started mysqldrbd01)<br>
Nov 7 14:34:08 mysqldrbd01 pengine: [8609]: notice: LogActions:
Leave resource FAILOVER-ADDR (Started mysqldrbd01)<br>
Nov 7 14:34:08 mysqldrbd01 pengine: [8609]: notice: LogActions:
Leave resource DRBD:0 (Slave mysqldrbd02)<br>
Nov 7 14:34:08 mysqldrbd01 pengine: [8609]: notice: LogActions:
Leave resource DRBD:1 (Master mysqldrbd01)<br>
Nov 7 14:34:08 mysqldrbd01 pengine: [8609]: notice: LogActions:
Leave resource PING-NET:0 (Started mysqldrbd02)<br>
Nov 7 14:34:08 mysqldrbd01 pengine: [8609]: notice: LogActions:
Leave resource PING-NET:1 (Started mysqldrbd01)<br>
Nov 7 14:34:08 mysqldrbd01 pengine: [8609]: notice: LogActions:
Leave resource p_mysql:0 (Stopped)<br>
Nov 7 14:34:08 mysqldrbd01 pengine: [8609]: notice: LogActions:
Leave resource p_mysql:1 (Stopped)<br>
Nov 7 14:34:08 mysqldrbd01 crmd: [8610]: info: do_state_transition:
State transition S_POLICY_ENGINE -> S_TRANSITION_ENGINE [
input=I_PE_SUCCESS cause=C_IPC_MESSAGE origin=handle_response ]<br>
Nov 7 14:34:08 mysqldrbd01 crmd: [8610]: info: unpack_graph:
Unpacked transition 796: 0 actions in 0 synapses<br>
Nov 7 14:34:08 mysqldrbd01 crmd: [8610]: info: do_te_invoke:
Processing graph 796 (ref=pe_calc-dc-1320698048-1740) derived from
/var/lib/pengine/pe-input-896.bz2<br>
Nov 7 14:34:08 mysqldrbd01 crmd: [8610]: info: run_graph:
====================================================<br>
Nov 7 14:34:08 mysqldrbd01 crmd: [8610]: notice: run_graph:
Transition 796 (Complete=0, Pending=0, Fired=0, Skipped=0,
Incomplete=0, Source=/var/lib/pengine/pe-input-896.bz2): Complete<br>
Nov 7 14:34:08 mysqldrbd01 crmd: [8610]: info: te_graph_trigger:
Transition 796 is now complete<br>
Nov 7 14:34:08 mysqldrbd01 crmd: [8610]: info: notify_crmd:
Transition 796 status: done - <null><br>
Nov 7 14:34:08 mysqldrbd01 crmd: [8610]: info: do_state_transition:
State transition S_TRANSITION_ENGINE -> S_IDLE [
input=I_TE_SUCCESS cause=C_FSA_INTERNAL origin=notify_crmd ]<br>
Nov 7 14:34:08 mysqldrbd01 crmd: [8610]: info: do_state_transition:
Starting PEngine Recheck Timer<br>
Nov 7 14:34:08 mysqldrbd01 pengine: [8609]: info:
process_pe_message: Transition 796: PEngine Input stored in:
/var/lib/pengine/pe-input-896.bz2<br>
Nov 7 14:34:08 mysqldrbd01 cibadmin: [28990]: info: Invoked:
/usr/sbin/cibadmin -Ql <br>
Nov 7 14:34:21 mysqldrbd01 cibadmin: [29177]: info: Invoked:
/usr/sbin/cibadmin -Ql <br>
Nov 7 14:34:21 mysqldrbd01 crm_resource: [29178]: info: Invoked:
/usr/sbin/crm_resource --meta -t primitive -r p_mysql -p target-role
-v stopped <br>
Nov 7 14:34:23 mysqldrbd01 crm_resource: [29190]: info: Invoked:
/usr/sbin/crm_resource --meta -t primitive -r p_mysql -p target-role
-v stopped <br>
Nov 7 14:34:23 mysqldrbd01 cib: [8606]: info: log_data_element:
cib:diff: - <cib admin_epoch="0" epoch="245" num_updates="1" ><br>
Nov 7 14:34:23 mysqldrbd01 cib: [8606]: info: log_data_element:
cib:diff: - <configuration ><br>
Nov 7 14:34:23 mysqldrbd01 cib: [8606]: info: log_data_element:
cib:diff: - <resources ><br>
Nov 7 14:34:23 mysqldrbd01 cib: [8606]: info: log_data_element:
cib:diff: - <master id="ms_mysql" ><br>
Nov 7 14:34:23 mysqldrbd01 cib: [8606]: info: log_data_element:
cib:diff: - <primitive id="p_mysql" ><br>
Nov 7 14:34:23 mysqldrbd01 cib: [8606]: info: log_data_element:
cib:diff: - <meta_attributes
id="p_mysql-meta_attributes" ><br>
Nov 7 14:34:23 mysqldrbd01 cib: [8606]: info: log_data_element:
cib:diff: - <nvpair value="started"
id="p_mysql-meta_attributes-target-role" /><br>
Nov 7 14:34:23 mysqldrbd01 cib: [8606]: info: log_data_element:
cib:diff: - </meta_attributes><br>
Nov 7 14:34:23 mysqldrbd01 cib: [8606]: info: log_data_element:
cib:diff: - </primitive><br>
Nov 7 14:34:23 mysqldrbd01 cib: [8606]: info: log_data_element:
cib:diff: - </master><br>
Nov 7 14:34:23 mysqldrbd01 cib: [8606]: info: log_data_element:
cib:diff: - </resources><br>
Nov 7 14:34:23 mysqldrbd01 cib: [8606]: info: log_data_element:
cib:diff: - </configuration><br>
Nov 7 14:34:23 mysqldrbd01 crmd: [8610]: info:
abort_transition_graph: need_abort:59 - Triggered transition abort
(complete=1) : Non-status change<br>
Nov 7 14:34:23 mysqldrbd01 cib: [8606]: info: log_data_element:
cib:diff: - </cib><br>
Nov 7 14:34:23 mysqldrbd01 crmd: [8610]: info: need_abort: Aborting
on change to admin_epoch<br>
Nov 7 14:34:23 mysqldrbd01 cib: [8606]: info: log_data_element:
cib:diff: + <cib admin_epoch="0" epoch="246" num_updates="1" ><br>
Nov 7 14:34:23 mysqldrbd01 crmd: [8610]: info: do_state_transition:
State transition S_IDLE -> S_POLICY_ENGINE [ input=I_PE_CALC
cause=C_FSA_INTERNAL origin=abort_transition_graph ]<br>
Nov 7 14:34:23 mysqldrbd01 cib: [8606]: info: log_data_element:
cib:diff: + <configuration ><br>
Nov 7 14:34:23 mysqldrbd01 crmd: [8610]: info: do_state_transition:
All 2 cluster nodes are eligible to run resources.<br>
Nov 7 14:34:23 mysqldrbd01 cib: [8606]: info: log_data_element:
cib:diff: + <resources ><br>
Nov 7 14:34:23 mysqldrbd01 crmd: [8610]: info: do_pe_invoke: Query
1488: Requesting the current CIB: S_POLICY_ENGINE<br>
Nov 7 14:34:23 mysqldrbd01 cib: [8606]: info: log_data_element:
cib:diff: + <master id="ms_mysql" ><br>
Nov 7 14:34:23 mysqldrbd01 cib: [8606]: info: log_data_element:
cib:diff: + <primitive id="p_mysql" ><br>
Nov 7 14:34:23 mysqldrbd01 cib: [8606]: info: log_data_element:
cib:diff: + <meta_attributes
id="p_mysql-meta_attributes" ><br>
Nov 7 14:34:23 mysqldrbd01 cib: [8606]: info: log_data_element:
cib:diff: + <nvpair value="stopped"
id="p_mysql-meta_attributes-target-role" /><br>
Nov 7 14:34:23 mysqldrbd01 cib: [8606]: info: log_data_element:
cib:diff: + </meta_attributes><br>
Nov 7 14:34:23 mysqldrbd01 cib: [8606]: info: log_data_element:
cib:diff: + </primitive><br>
Nov 7 14:34:23 mysqldrbd01 cib: [8606]: info: log_data_element:
cib:diff: + </master><br>
Nov 7 14:34:23 mysqldrbd01 cib: [8606]: info: log_data_element:
cib:diff: + </resources><br>
Nov 7 14:34:23 mysqldrbd01 cib: [8606]: info: log_data_element:
cib:diff: + </configuration><br>
Nov 7 14:34:23 mysqldrbd01 cib: [8606]: info: log_data_element:
cib:diff: + </cib><br>
Nov 7 14:34:23 mysqldrbd01 cib: [8606]: info: cib_process_request:
Operation complete: op cib_modify for section resources
(origin=local/crm_resource/4, version=0.246.1): ok (rc=0)<br>
Nov 7 14:34:23 mysqldrbd01 cib: [29192]: info: write_cib_contents:
Archived previous version as /var/lib/heartbeat/crm/cib-30.raw<br>
Nov 7 14:34:23 mysqldrbd01 cib: [29192]: info: write_cib_contents:
Wrote version 0.246.0 of the CIB to disk (digest:
b2c10b5780b5ffd9825112ab624861b5)<br>
Nov 7 14:34:23 mysqldrbd01 cib: [29192]: info: retrieveCib: Reading
cluster configuration from: /var/lib/heartbeat/crm/cib.blvW7w
(digest: /var/lib/heartbeat/crm/cib.zrI8Li)<br>
Nov 7 14:34:23 mysqldrbd01 crmd: [8610]: info:
do_pe_invoke_callback: Invoking the PE: query=1488,
ref=pe_calc-dc-1320698063-1741, seq=1368, quorate=1<br>
Nov 7 14:34:23 mysqldrbd01 pengine: [8609]: notice: unpack_config:
On loss of CCM Quorum: Ignore<br>
Nov 7 14:34:23 mysqldrbd01 pengine: [8609]: info: unpack_config:
Node scores: 'red' = -INFINITY, 'yellow' = 0, 'green' = 0<br>
Nov 7 14:34:23 mysqldrbd01 pengine: [8609]: info:
determine_online_status: Node mysqldrbd02 is online<br>
Nov 7 14:34:23 mysqldrbd01 pengine: [8609]: info:
determine_online_status: Node mysqldrbd01 is online<br>
Nov 7 14:34:23 mysqldrbd01 pengine: [8609]: notice: unpack_rsc_op:
Operation DRBD:0_monitor_0 found resource DRBD:0 active on
mysqldrbd02<br>
Nov 7 14:34:23 mysqldrbd01 pengine: [8609]: notice: unpack_rsc_op:
Hard error - p_mysql:0_monitor_0 failed with rc=5: Preventing
ms_mysql from re-starting on mysqldrbd02<br>
Nov 7 14:34:23 mysqldrbd01 pengine: [8609]: info: find_clone:
Internally renamed DRBD:0 on mysqldrbd01 to DRBD:1<br>
Nov 7 14:34:23 mysqldrbd01 pengine: [8609]: notice: unpack_rsc_op:
Operation DRBD:0_monitor_0 found resource DRBD:1 active in master
mode on mysqldrbd01<br>
Nov 7 14:34:23 mysqldrbd01 pengine: [8609]: notice: unpack_rsc_op:
Hard error - p_mysql:1_monitor_0 failed with rc=5: Preventing
ms_mysql from re-starting on mysqldrbd01<br>
Nov 7 14:34:23 mysqldrbd01 pengine: [8609]: notice: group_print:
Resource Group: AP-CLUST<br>
Nov 7 14:34:23 mysqldrbd01 pengine: [8609]: notice:
native_print: SRV-MOUNT (ocf::heartbeat:Filesystem):
Started mysqldrbd01<br>
Nov 7 14:34:23 mysqldrbd01 pengine: [8609]: notice:
native_print: FAILOVER-ADDR (ocf::heartbeat:IPaddr2):
Started mysqldrbd01<br>
Nov 7 14:34:23 mysqldrbd01 pengine: [8609]: notice: clone_print:
Master/Slave Set: DRBD-DATA<br>
Nov 7 14:34:23 mysqldrbd01 pengine: [8609]: notice:
short_print: Masters: [ mysqldrbd01 ]<br>
Nov 7 14:34:23 mysqldrbd01 pengine: [8609]: notice:
short_print: Slaves: [ mysqldrbd02 ]<br>
Nov 7 14:34:23 mysqldrbd01 pengine: [8609]: notice: clone_print:
Clone Set: PING-NET-CLONE<br>
Nov 7 14:34:23 mysqldrbd01 pengine: [8609]: notice:
short_print: Started: [ mysqldrbd02 mysqldrbd01 ]<br>
Nov 7 14:34:23 mysqldrbd01 pengine: [8609]: notice: clone_print:
Master/Slave Set: ms_mysql<br>
Nov 7 14:34:23 mysqldrbd01 pengine: [8609]: notice:
short_print: Stopped: [ p_mysql:0 p_mysql:1 ]<br>
Nov 7 14:34:23 mysqldrbd01 pengine: [8609]: info: master_color:
Promoting DRBD:1 (Master mysqldrbd01)<br>
Nov 7 14:34:23 mysqldrbd01 pengine: [8609]: info: master_color:
DRBD-DATA: Promoted 1 instances of a possible 1 to master<br>
Nov 7 14:34:23 mysqldrbd01 pengine: [8609]: info: master_color:
Promoting DRBD:1 (Master mysqldrbd01)<br>
Nov 7 14:34:23 mysqldrbd01 pengine: [8609]: info: master_color:
DRBD-DATA: Promoted 1 instances of a possible 1 to master<br>
Nov 7 14:34:23 mysqldrbd01 pengine: [8609]: info: native_color:
Resource p_mysql:0 cannot run anywhere<br>
Nov 7 14:34:23 mysqldrbd01 pengine: [8609]: info: native_color:
Resource p_mysql:1 cannot run anywhere<br>
Nov 7 14:34:23 mysqldrbd01 pengine: [8609]: info: master_color:
ms_mysql: Promoted 0 instances of a possible 1 to master<br>
Nov 7 14:34:23 mysqldrbd01 pengine: [8609]: notice: LogActions:
Leave resource SRV-MOUNT (Started mysqldrbd01)<br>
Nov 7 14:34:23 mysqldrbd01 pengine: [8609]: notice: LogActions:
Leave resource FAILOVER-ADDR (Started mysqldrbd01)<br>
Nov 7 14:34:23 mysqldrbd01 pengine: [8609]: notice: LogActions:
Leave resource DRBD:0 (Slave mysqldrbd02)<br>
Nov 7 14:34:23 mysqldrbd01 pengine: [8609]: notice: LogActions:
Leave resource DRBD:1 (Master mysqldrbd01)<br>
Nov 7 14:34:23 mysqldrbd01 pengine: [8609]: notice: LogActions:
Leave resource PING-NET:0 (Started mysqldrbd02)<br>
Nov 7 14:34:23 mysqldrbd01 pengine: [8609]: notice: LogActions:
Leave resource PING-NET:1 (Started mysqldrbd01)<br>
Nov 7 14:34:23 mysqldrbd01 pengine: [8609]: notice: LogActions:
Leave resource p_mysql:0 (Stopped)<br>
Nov 7 14:34:23 mysqldrbd01 pengine: [8609]: notice: LogActions:
Leave resource p_mysql:1 (Stopped)<br>
Nov 7 14:34:23 mysqldrbd01 crmd: [8610]: info: do_state_transition:
State transition S_POLICY_ENGINE -> S_TRANSITION_ENGINE [
input=I_PE_SUCCESS cause=C_IPC_MESSAGE origin=handle_response ]<br>
Nov 7 14:34:23 mysqldrbd01 pengine: [8609]: info:
process_pe_message: Transition 797: PEngine Input stored in:
/var/lib/pengine/pe-input-897.bz2<br>
Nov 7 14:34:23 mysqldrbd01 crmd: [8610]: info: unpack_graph:
Unpacked transition 797: 0 actions in 0 synapses<br>
Nov 7 14:34:23 mysqldrbd01 crmd: [8610]: info: do_te_invoke:
Processing graph 797 (ref=pe_calc-dc-1320698063-1741) derived from
/var/lib/pengine/pe-input-897.bz2<br>
Nov 7 14:34:23 mysqldrbd01 cibadmin: [29194]: info: Invoked:
/usr/sbin/cibadmin -Ql <br>
Nov 7 14:34:23 mysqldrbd01 crmd: [8610]: info: run_graph:
====================================================<br>
Nov 7 14:34:23 mysqldrbd01 crmd: [8610]: notice: run_graph:
Transition 797 (Complete=0, Pending=0, Fired=0, Skipped=0,
Incomplete=0, Source=/var/lib/pengine/pe-input-897.bz2): Complete<br>
Nov 7 14:34:23 mysqldrbd01 crmd: [8610]: info: te_graph_trigger:
Transition 797 is now complete<br>
Nov 7 14:34:23 mysqldrbd01 crmd: [8610]: info: notify_crmd:
Transition 797 status: done - <null><br>
Nov 7 14:34:23 mysqldrbd01 crmd: [8610]: info: do_state_transition:
State transition S_TRANSITION_ENGINE -> S_IDLE [
input=I_TE_SUCCESS cause=C_FSA_INTERNAL origin=notify_crmd ]<br>
Nov 7 14:34:23 mysqldrbd01 crmd: [8610]: info: do_state_transition:
Starting PEngine Recheck Timer<br>
++++++++++++++++++++++++++++++++++++++<br>
crm configure show:<br>
----------------------<br>
<br>
[root@mysqldrbd01 etc]# crm configure show<br>
node mysqldrbd01 \<br>
attributes standby="off"<br>
node mysqldrbd02 \<br>
attributes standby="off"<br>
primitive DRBD ocf:linbit:drbd \<br>
params drbd_resource="repdata" \<br>
operations $id="DRBD-operations" \<br>
op start interval="0" timeout="240" \<br>
op stop interval="0" timeout="100" \<br>
op monitor interval="120" \<br>
meta target-role="started"<br>
primitive FAILOVER-ADDR ocf:heartbeat:IPaddr2 \<br>
params ip="192.168.1.160" nic="eth1" \<br>
operations $id="FAILOVER-ADDR-operations" \<br>
op monitor start-delay="0" interval="10" \<br>
meta target-role="started"<br>
primitive PING-NET ocf:pacemaker:ping \<br>
params dampen="5s" multiplier="100"
host_list="192.168.209.4" \<br>
op monitor interval="60s" timeout="60" \<br>
op start interval="0" timeout="60s" \<br>
op stop interval="0" timeout="60s" \<br>
meta target-role="started"<br>
primitive SRV-MOUNT ocf:heartbeat:Filesystem \<br>
params device="/dev/drbd0" directory="/data/" fstype="ext3"
\<br>
operations $id="SRV-MOUNT-operations" \<br>
op start interval="0" timeout="60" \<br>
op stop interval="0" timeout="60" \<br>
meta target-role="started"<br>
<b>primitive p_mysql ocf:heartbeat:mysql \<br>
params binary="/usr/bin/mysqld_safe" \<br>
operations $id="p_mysql-operations" \<br>
op start interval="0" timeout="120" \<br>
op promote interval="0" timeout="120" \<br>
op demote interval="0" timeout="120" \<br>
op stop interval="0" timeout="120" \<br>
op monitor interval="10" timeout="30" start-delay="0" \<br>
meta target-role="stopped"</b><br>
group AP-CLUST SRV-MOUNT FAILOVER-ADDR<br>
<b>ms DRBD-DATA DRBD \<br>
meta clone-max="2" notify="true" target-role="started"<br>
ms ms_mysql p_mysql \<br>
meta clone-max="2"</b><br>
clone PING-NET-CLONE PING-NET<br>
location connected_node DRBD-DATA \<br>
rule $id="connected_node-rule" -inf: not_defined pingd or
pingd lte 0<br>
location master-prefer-node-1 FAILOVER-ADDR 25: mysqldrbd01<br>
colocation AP-CLUST_on_DRBD inf: AP-CLUST DRBD-DATA:Master<br>
order AP-CLUST_after_DRBD-DATA inf: DRBD-DATA:promote AP-CLUST:start<br>
property $id="cib-bootstrap-options" \<br>
expected-quorum-votes="2" \<br>
stonith-enabled="false" \<br>
dc-version="1.0.11-1554a83db0d3c3e546cfd3aaff6af1184f79ee87"
\<br>
no-quorum-policy="ignore" \<br>
cluster-infrastructure="openais" \<br>
last-lrm-refresh="1320686593"<br>
rsc_defaults $id="rsc-options" \<br>
resource-stickiness="100"<br>
<br>
</body>
</html>